Shekar Ramanathan
Abstract
Due to the wide use of object-oriented technology in software development and the existence of many relational databases, reverse engineering of relational schemas to object-oriented schemas is gaining in interest. One of the major problems with existing approaches for this schema mapping is that they fail to take into consideration many modern relational database design alternatives (e.g., use of binary data to store multiple-valued attributes). This paper presents a schema mapping procedure that can be applied on existing relational databases without changing their schema. The procedure maps a relational schema that is at least in 2NF into an object-oriented schema by taking into consideration various types of relational database design optimizations.
- {1} Rick Catell, editor. The Object Database Standard: ODMG-93 Release 1.2. Morgan-Kaufmann, 1995. Google Scholar
Digital Library
- {2} Roger H. L. Chiang, Terence M. Barron, and Veda C. Storey. Reverse engineering of relational databases: Extraction of an EER model from a relational database. Data & Knowledge Engineering, (12):107-142, 1994. Google ScholarDigital Library
- {3} Christian Fahrner and Gottfied Vossen. Transforming relational database schemas into object oriented schemas according to ODMG-93. In Proceedings of the 4th International Conference on Deductive and Object-Oriented Databases, Singapore, 1995. National University of Singapore. to appear. Google ScholarDigital Library
- {4} Christian Fahrner and Gottfried Vossen. A survey of database design transformations based on the entity-relationship model. Data & Knowledge Engineering, (15):213-250, 1995. Google ScholarDigital Library
- {5} Ontos Inc. Ontos object integration server. World-Wide-Web Homepage, 1996. http://www.ontos.com/.Google Scholar
- {6} Persistence Software Inc. Persistence software: Technical overview. World-Wide-Web Home Page, 1996. http://www.persistence.com.Google Scholar
- {7} Subtle Software Inc. Subtleware C++ class generator. World-Wide-Web Home Page, 1996. http://world.std.com/ subtle/.Google Scholar
- {8} Paul Johannesson and Katalin Kalman. A method for translating relational schemas into conceptual schemas. In Frederick H. Lochovsky, editor, Proceedings of the Eighth International Conference on Entity Relationship Approach, pages 271-285, Toronto, Canada, October 1989. North-Holland. Google ScholarDigital Library
- {9} Gregory Piatetsky-Shapiro and William Frawley, editors. Knowledge Discovery in Databases. AAAI Press/The MIT Press, California, 1991. Google ScholarDigital Library
- {10} James Rumbaugh, Michael Blaha, William Premerlani, Frederick Eddy, and William Lorensen. Object-oriented Modelling and Design. Prentice-Hall, Inc., Eaglewood Cliffs, New Jersey, 1991. Google ScholarDigital Library
Index Terms
- Extraction of object-oriented structures from existing relational databases
Recommendations
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 ...
Federating Object-Oriented and Relational Databases: The IRO-DB Experience
COOPIS '97: Proceedings of the Second IFCIS International Conference on Cooperative Information SystemsFrom the beginning of 1994 to the end of 1996, the IRO-DB (Interoperable Relational and Object-Oriented Databases) ESPRIT project has developed tools for accessing relational and object-oriented databases in an integrated way, and for designing and ...
Comments