Providing an Object-relational Interface for a Relational Database
碩士 === 大同工學院 === 資訊工程研究所 === 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 tha...
Main Authors: | , |
---|---|
Other Authors: | |
Format: | Others |
Language: | zh-TW |
Published: |
1998
|
Online Access: | http://ndltd.ncl.edu.tw/handle/59575108547545841748 |
id |
ndltd-TW-086TTIT0392018 |
---|---|
record_format |
oai_dc |
spelling |
ndltd-TW-086TTIT03920182015-10-13T17:34:49Z http://ndltd.ncl.edu.tw/handle/59575108547545841748 Providing an Object-relational Interface for a Relational Database 在關連式資料庫上提供物件關連式介面 Ho Kuo-Wei 何國維 碩士 大同工學院 資訊工程研究所 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. Chen Huei-Huang 陳煇煌 1998 學位論文 ; thesis 0 zh-TW |
collection |
NDLTD |
language |
zh-TW |
format |
Others
|
sources |
NDLTD |
description |
碩士 === 大同工學院 === 資訊工程研究所 === 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.
|
author2 |
Chen Huei-Huang |
author_facet |
Chen Huei-Huang Ho Kuo-Wei 何國維 |
author |
Ho Kuo-Wei 何國維 |
spellingShingle |
Ho Kuo-Wei 何國維 Providing an Object-relational Interface for a Relational Database |
author_sort |
Ho Kuo-Wei |
title |
Providing an Object-relational Interface for a Relational Database |
title_short |
Providing an Object-relational Interface for a Relational Database |
title_full |
Providing an Object-relational Interface for a Relational Database |
title_fullStr |
Providing an Object-relational Interface for a Relational Database |
title_full_unstemmed |
Providing an Object-relational Interface for a Relational Database |
title_sort |
providing an object-relational interface for a relational database |
publishDate |
1998 |
url |
http://ndltd.ncl.edu.tw/handle/59575108547545841748 |
work_keys_str_mv |
AT hokuowei providinganobjectrelationalinterfaceforarelationaldatabase AT héguówéi providinganobjectrelationalinterfaceforarelationaldatabase AT hokuowei zàiguānliánshìzīliàokùshàngtígōngwùjiànguānliánshìjièmiàn AT héguówéi zàiguānliánshìzīliàokùshàngtígōngwùjiànguānliánshìjièmiàn |
_version_ |
1717781435203452928 |