THE QUERY TRANSLATION BETWEEN OBJECT-ORIENTED AND RELATIONAL DATABASES

摘要

In this paper, we propose a solution for the query translation between object-oriented and relational databases. The translation was accomplished through a schema transformer and a query translator. The mapping rules defined within the schema transformer describe the transformation between an object-oriented schema and a relation schema. Then the query translator provides users a relational view of an object-oriented database, and vice-versa. In this work, we used Entity/Relationship model as a tool to describe the real world since Entity/Relationship model can be easily mapped to an object-oriented or relational schema according to the underlying DBMS. Finally, we implemented the query translation between OOSQL for WOO, an object-oriented database system developed at the Institute for the Information Industry, and SQL for the Microsoft FoxPro relational database system.