Design and Implementation of a Gateway for Object-Oriented Interface on Relational Database

This paper describes the design and implementation of schema which allows accesses to RDBMS through the object-oriented interface. The proposed schema gateway supports translation of RBD schemas to OODB schemas, mapping informations of both schemas, and translation of queries written in OQL to SQL queries. Schema translation is based on the analysis of foreign key semantics which and be classified into inheritance, reference, relationship, and set attributes in relational databases. The major advantage of the proposed framwork is that it may be served as the uniform data model in the multi or heterogeneous database environment.