Translating update operations from relational to object-oriented databases

Abstract In migrating a legacy relational database system to the object-oriented (OO) platform, when database migration completes, application modules are to be migrated, where embedded relational database operations are mapped into their OO correspondents. In this paper we study mapping relational update operations to their OO equivalents, which include UPDATE 1 , INSERT and DELETE operations. Relational update operation translation from relational to OO faces the touchy problem of transformation from a value-based relationship model to a reference-based model and maintaining the relational integrity constraints. Moreover, with a relational database where inheritance is expressed as attribute value subset relationship, changing of some attribute values may lead to the change of the position of an object in the class inheritance hierarchy, which we call object migration. Considering all these aspects, algorithms are given mapping relational UPDATE, INSERT and DELETE operations to their OO correspondents. Our work emphasize in examining the differences in the representation of the source schema's semantics resulting from the translation process, as well as differences in the inherent semantics of the two models.

[1]  C. J. Date.  A Guide to the SQL Standard , 1987 .

[2]  Kazimierz Subieta.  Navigational facilities for relational data base , 1983, Inf. Syst..

[3]  Qing Li,et al.  A Framework for Object Migration in Object-Oriented Databases , 1994, Data Knowl. Eng..

[4]  Nicolas Spyratos,et al.  Update semantics of relational views , 1981, TODS.

[5]  Joseph Fong,et al.  Converting relational to object-oriented databases , 1997, SGMD.

[6]  Clement T. Yu,et al.  A Theory of Translation From Relational Queries to Hierarchical Queries , 1995, IEEE Trans. Knowl. Data Eng..

[7]  Arthur M. Keller,et al.  The Role of Semantics in Translating View Updates , 1986, Computer.

[8]  Sonia Bergamaschi,et al.  On taxonomic reasoning in conceptual design , 1992, TODS.

[9]  Clement T. Yu,et al.  Translation of object-oriented queries to relational queries , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[10]  Kazimierz Subieta.  High-Level Navigational Facilities for Network and Relational Databases , 1983, VLDB.

[11]  Arnon Rosenthal,et al.  Tools and transformations—rigorous and otherwise—for practical database design , 1994, TODS.

[12]  Louiqa Raschid,et al.  Query interoperation among object-oriented and relational databases , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[13]  Tok Wang Ling,et al.  Object Migration in ISA Hierarchies , 1995, DASFAA.

[14]  R. G. G. Cattell,et al.  The Object Database Standard: ODMG-93 , 1993 .

[15]  S. Dao,et al.  Construction of a relational front-end for object-oriented database systems , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[16]  Yahiko Kambayashi,et al.  Object migration mechanisms to support updates in object-oriented databases , 1990, Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications.

[17]  Arnon Rosenthal,et al.  Querying Relational Views of Networks , 1985, Query Processing in Database Systems.

[18]  Sudhir K. Arora,et al.  Schema Translation Using the Entity-Relationship Approach , 1981, ER.

[19]  Richard Hull.  Relative Information Capacity of Simple Relational Database Schemata , 1986, SIAM J. Comput..

[20]  Arie Shoshani,et al.  Representing extended entity-relationship structures in relational databases: a modular approach , 1992, TODS.

[21]  Naphtali Rishe,et al.  Databases: Theory, Design and Applications , 1991 .

[22]  David Jordan,et al.  The Object Database Standard: ODMG 2.0 , 1997 .

[23]  Jean-Luc Hainaut,et al.  Transformation-based Database Reverse Engineering , 1993 .

[24]  Umeshwar Dayal,et al.  On the correct translation of update operations on relational views , 1982, TODS.

[25]  Gerti Kappel,et al.  Object-Oriented Database , 1999, ECOOP Workshops.