Abstract
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.
- Date, C. J. (1995) An Introduction to Database Systems (6th edition) Addison-Wesley Systems Programming Series, pp. 669-685. Google ScholarDigital Library
- Elmasri, R. A., & Navathe, S., (1989). Fundamentals of Database Systems. The Bensamin/Cummings Publishing Company, Inc. Google ScholarDigital Library
- Fong, J., & Ho, M., (1993). Knowledge-Based Approach for abstracting Hierarchical and Network Semantics, Lecture notes in Computer Science 823, Springer-Verlag, pp. 509-519. Google ScholarDigital Library
- Fong, J., & Bloor, C., (1994). Data Conversion Rules from Network to Relational Databases, Information and Software Technology, vol. 36, 1994, no. 3, pp. 141-153.Google ScholarCross Ref
- Fong, J., (1995). Mapping Extended Entity Relationship Model to Object Modeling Technique, September 1995 ACM SIGMOD RECORD, pp. 76- 82. Google ScholarDigital Library
- Getta, J. R., (1993). Translation of Extended Entity-Relationship Database Model into Object-Oriented Database Model, in (IFIP A-25) Interoperable Database Systems (DS-5), (edited by Hsiao et al) Elsevier Science Publishers B.V. (North-Holland), pp. 87-100. Google ScholarDigital Library
- Hainant, J.-L., et al (1993) Transformation-Based Database Reverse Engineering, Lecture notes in Computer Science 823, Springer-Verlag, pp. 364- 375. Google ScholarDigital Library
- Hughes, J. (1991) Object-Oriented Databases, Prentice Hall International Series in Computer Science. Google ScholarDigital Library
- Hull, R., (1986). Relative Information Capacity of Simple Relational Schemata, SIAM Journal of Computing, vol. 15, no. 3, pp. 856-886. Google ScholarDigital Library
- Hull, R., & Su, S., (1989). On Accessing Object-Oriented Databases: Expressive Power, Complexity, and Restrictions, Proceedings of SIGMOD International Conference, pp. 147-158. Google ScholarDigital Library
- Lien, E., (1982) On the Equivalence of Database Models, JACM, v. 29, n. 2, pp. 333-362. Google ScholarDigital Library
- Liu, C. T., et al (1993). An Entity-Relationship Approach to Schema Evolution, IEEE ICCI'93, pp. 575-578. Google ScholarDigital Library
- Marinos, L., & Smit, R. A., (1991). From Relations to Objects: A Translation Methodology for an Object Oriented Front-End to RDBMSs, in (Papazoglou & Zeleznikow, 1991), pp. 148-167. Google ScholarDigital Library
- Markowitz, V. M., & Shoshani, A., (1992). Representing Extended Entity-Relationship Structures in Relational Databases: A Modular Approach, ACM TODS, v. 17, n. 3, pp. 423-464. Google ScholarDigital Library
- UniSQL (1993). UniSQL Database Management System User Manual, UniSQL inc.Google Scholar
Index Terms
- Converting relational to object-oriented databases
Recommendations
An object-oriented prototype for a geophysical database
SSST '95: Proceedings of the 27th Southeastern Symposium on System Theory (SSST'95)Database management systems (DBMSs) are being used in a wide variety of domains to handle many types of data. Scientific data pose a special challenge to DBMSs due to their volume and complex nature. The object-oriented model has many additional ...
An Interpreter Approach for Exporting Relational Data into XML Documents with Structured Export Markup Language
Almost all enterprises use relational databases to handle real time business operations and most need to generate various XML documents for data exchanges internally among various departments and externally with business partners. Exporting data in a ...
VIREX: visual relational to XML conversion tool
Developing user-friendly transformation tools for converting all or part of a given relational database into XML has not received enough consideration. This paper presents a flexible user interface called VIREX (VIsual RElational to XML), which ...
Comments