1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH
RDB has been dominant in the industry for the last decade. OODB is recognized as a post-relational technology that can improve productivity. Hierarchical Database and Network Database were popular in the ‘70s, and have been developed into legacy database systems. The DBMS of various data models have...
Main Author: | |
---|---|
Other Authors: | |
Format: | Text |
Language: | English |
Subjects: | |
Online Access: | http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.503.7383 http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf |
id |
ftciteseerx:oai:CiteSeerX.psu:10.1.1.503.7383 |
---|---|
record_format |
openpolar |
spelling |
ftciteseerx:oai:CiteSeerX.psu:10.1.1.503.7383 2023-05-15T16:02:05+02:00 1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH Joseph Fong The Pennsylvania State University CiteSeerX Archives application/pdf http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.503.7383 http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf en eng http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.503.7383 http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf Metadata may be used without restrictions as long as the oai identifier remains attached to it. http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf conversion data manipulation language emulation data warehouse text ftciteseerx 2016-01-08T09:15:55Z RDB has been dominant in the industry for the last decade. OODB is recognized as a post-relational technology that can improve productivity. Hierarchical Database and Network Database were popular in the ‘70s, and have been developed into legacy database systems. The DBMS of various data models have proliferated into many companies, and become their important assets. There is a need to integrate these database system into a data warehouse in the company. We investigate a solution to the problem by offering an architecture of a universal database for the connectivity of various DBMSs using different data models. A frame model is chosen to represent the conceptual and logical schema of the universal database, which structures an application domain into classes organized via generalization, aggregation and user-defined relationships, and its data in relational tables. The schemas of the existing database systems are translated into frame model conceptual schemas which are integrated into a global frame model in a knowledge representation that includes classes for object structure descriptions and constraints for supporting user-defined relationships. The universal database is implemented by a relational DBMS as a kernel. In addition to relational tables, the universal database consists of program area to emulate database navigation in nonrelational DBMS, method classes to implement program calls to emulate methods of OODBMS, and constraint classes to preserve semantic and resolve naming conflicts in schema translation and integration. To ensure each database program access the universal database, a database gateway for each source DBMS is developed to translate their DML into SQL, which is chosen to be its kernel database language, for its user-friendliness, standardization and popularity in the industry. Text DML Unknown |
institution |
Open Polar |
collection |
Unknown |
op_collection_id |
ftciteseerx |
language |
English |
topic |
conversion data manipulation language emulation data warehouse |
spellingShingle |
conversion data manipulation language emulation data warehouse Joseph Fong 1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH |
topic_facet |
conversion data manipulation language emulation data warehouse |
description |
RDB has been dominant in the industry for the last decade. OODB is recognized as a post-relational technology that can improve productivity. Hierarchical Database and Network Database were popular in the ‘70s, and have been developed into legacy database systems. The DBMS of various data models have proliferated into many companies, and become their important assets. There is a need to integrate these database system into a data warehouse in the company. We investigate a solution to the problem by offering an architecture of a universal database for the connectivity of various DBMSs using different data models. A frame model is chosen to represent the conceptual and logical schema of the universal database, which structures an application domain into classes organized via generalization, aggregation and user-defined relationships, and its data in relational tables. The schemas of the existing database systems are translated into frame model conceptual schemas which are integrated into a global frame model in a knowledge representation that includes classes for object structure descriptions and constraints for supporting user-defined relationships. The universal database is implemented by a relational DBMS as a kernel. In addition to relational tables, the universal database consists of program area to emulate database navigation in nonrelational DBMS, method classes to implement program calls to emulate methods of OODBMS, and constraint classes to preserve semantic and resolve naming conflicts in schema translation and integration. To ensure each database program access the universal database, a database gateway for each source DBMS is developed to translate their DML into SQL, which is chosen to be its kernel database language, for its user-friendliness, standardization and popularity in the industry. |
author2 |
The Pennsylvania State University CiteSeerX Archives |
format |
Text |
author |
Joseph Fong |
author_facet |
Joseph Fong |
author_sort |
Joseph Fong |
title |
1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH |
title_short |
1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH |
title_full |
1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH |
title_fullStr |
1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH |
title_full_unstemmed |
1 ARCHITECTURE OF A UNIVERSAL DATABASE: A FRAME MODEL APPROACH |
title_sort |
1 architecture of a universal database: a frame model approach |
url |
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.503.7383 http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf |
genre |
DML |
genre_facet |
DML |
op_source |
http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf |
op_relation |
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.503.7383 http://www.cs.cityu.edu.hk/~jfong/homepage/reference/Architecture.pdf |
op_rights |
Metadata may be used without restrictions as long as the oai identifier remains attached to it. |
_version_ |
1766397708423135232 |