Converting relational to object-oriented databases

As object-oriented model becomes the trend of database technology, there is a need to convert relational to object-oriented database system to improve productivity and flexibility. The changeover includes schema translation, data conversion and program conversion. This paper describes a methodology for integrating schema translation and data conversion. Schema translation involves semantic reconstruction and the mapping of relational schema into object-oriented schema. Data conversion involves unloading tuples of relations into sequential files and reloading them into object-oriented classes files. The methodology preserves the constraints of the relational database by mapping the equivalent data dependencies.

[1]  C. J. Date An Introduction to Database Systems, 6th Edition , 1995 .

[2]  Joseph Fong,et al.  Knowledge-Based Approach for Abstracting Hierarchical and Network Schema Semantics , 1993, ER.

[3]  Panos K. Chrysanthis,et al.  An entity-relationship approach to schema evolution , 1993, Proceedings of ICCI'93: 5th International Conference on Computing and Information.

[4]  Joseph Fong,et al.  Data conversion rules from network to relational databases , 1994, Inf. Softw. Technol..

[5]  Janusz R. Getta Translation of Extended Entity-Relationship Database Model into Object-Oriented Database Model , 1992, DS-5.

[6]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

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

[8]  Jean-Luc Hainaut,et al.  Schema Transformation Techniques for Database Reverse Engineering , 1993, ER.

[9]  Jianwen Su,et al.  On accessing object-oriented databases: expressive power, complexity, and restrictions , 1989, SIGMOD '89.

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

[11]  Joseph Fong Mapping extended entity relationship model to object modeling technique , 1995, SGMD.

[12]  John G. Hughes,et al.  Object-oriented databases , 1991, Prentice Hall International series in computer science.

[13]  Louis Marinos,et al.  From Relations to Objects: A Translation Methodology for an Object-Oriented Front-End to RDBMSs , 1991, The Next Generation of Information Systems.

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

[15]  Y. Edmund Lien,et al.  On the Equivalence of Database Models , 1982, JACM.