Providing an Object-relational Interface for a Relational Database

• Main Authors: Ho Kuo-Wei, 何國維
• Other Authors: Chen Huei-Huang
• Format: Others
• Language: zh-TW
• Published: 1998
• Online Access: http://ndltd.ncl.edu.tw/handle/59575108547545841748

碩士 === 大同工學院 === 資訊工程研究所 === 86 === Typically, today's applications always have many demands on multimedia and complex data type, there is every reason to believe that the DBMS with object-oriented technology will dominate the market place in the near future. Researchers expected that object-relational DBMS will get widespread acceptance in the transition period from relational DBMS to object-oriented DBMS. So our investigation is to provide an object-relational interface for a relational database. The overall procedure for creating the object-relational interface consists of two main steps: schema translation and program conversion. The objective of schema translation is to provide end user a virtual schema by which he or she can develop applications. We obey the indirect translation rule that means mapping relational schema to EER model through reverse engineering. Then, we map the translated EER model to an object-relational schema by forwarding. Program conversion focuses on transforming path expression in embedded OSQL C program to join operation in embedded SQL C program. The all information needed in this step can be acquired from relational and translated object-relational database schema. The advantage derived from this approach are providing end user a consistent interface to query legacy databases and keeping application working on existing relational database. This approach can also help extend the life of an existing relational DBMS. A prototype system has been implemented by the authors to verify the conversion algorithm.