Abstract
This paper presents an investigation into approaches and techniques used for database conversion. Constructing object views on top of a Relational DataBase (RDB), simple database integration and database migration are among these approaches. We present a categorisation of selected works proposed in the literature and translation techniques used for the problem of database conversion, concentrating on migrating an RDB as source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed in detail including semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, we conclude that an existing RDB can be migrated into object-based/XML databases according to available database standards. We propose an integrated method for migrating an RDB into object-based/XML databases using an intermediate Canonical Data Model (CDM), which enriches the source database’s semantics and captures characteristics of the target databases. A prototype has been implemented, which successfully translates CDM into object-oriented (ODMG 3.0 ODL), object-relational (Oracle 10g) and XML schemas.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Alhajj, R.: Extracting the Extended Entity-Relationship Model from a Legacy Relationals Database. Info. Syst. 28, 597–618 (2003)
Alhajj, R., Polat, F.: Reengineering Relational Databases to Object-Oriented: Constructing the Class Hierarchy and Migrating the Data. In: WCRE 2001, pp. 335–344 (2001)
Andersson, M.: Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering. In: 13th Int. Conf. on the ER Approach, pp. 403–419 (1994)
Castellanos, M., Saltor, F., García-Solaco, M.: Semantically Enriching Relational Databases into an Object Oriented Semantic Model. In: Karagiannis, D. (ed.) DEXA 1994. LNCS, vol. 856, pp. 125–134. Springer, Heidelberg (1994)
Chiang, R.H., Barron, T.M., Storey, V.C.: Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database. Data Knowl. Eng. 12, 107–142 (1994)
Du, W., Lee, M., Ling, T.W.: XML Structures for Relational Data. In: WISE (1), pp. 151–160 (2001)
Lee, D., Mani, M., Chiu, F., Chu, W.W.: NeT and CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints. In: CIKM, pp. 282–291 (2002)
Fahrner, C., Vossen, G.: Transforming Relational Database Schemas into Object-Oriented Schemas according to ODMG 1993. In: Ling, T.-W., Vieille, L., Mendelzon, A.O. (eds.) DOOD 1995. LNCS, vol. 1013, pp. 429–446. Springer, Heidelberg (1995)
Fong, J.: Converting Relational to Object-Oriented Databases. SIGMOD Record 26, 53–58 (1997)
Fong, J., Cheung, S.K.: Translating Relational Schema into XML Schema Definition with Data Semantic Preservation and XSD Graph. Info. & Soft. Tech. 47, 437–462 (2005)
Fong, J., Wong, H.K., Cheng, Z.: Converting Relational Database into XML Documents with DOM. Info. & Soft. Tech. 45, 335–355 (2003)
Kleiner, C., Lipeck, U.W.: Automatic Generation of XML DTDs from Conceptual Database Schemas. GI Jahrestagung (1), 396–405 (2001)
Maatuk, A., Ali, A., Rossiter, N.: A Framework for Relational Database Migration. TR (2008), http://computing.unn.ac.uk/staff/cgma2/papers/RDBM.pdf
Marcos, E., Vela, B., Cavero, J.M.: A Methodological Approach for Object-Relational Database Design using UML. Soft. and Syst. Modeling 2, 59–75 (2003)
Narasimhan, B., Navathe, S.B., Jayaraman, S.: On Mapping ER Models into OO Schemas. In: 12th int. Conf. on the Entity-Relationship Approach, vol. 823, pp. 402–413 (1993)
Premerlani, W.J., Blaha, M.R.: An Approach for Reverse Engineering of Relational Databases. Communications of the ACM 37, 42–49 (1994)
Soutou, C.: Inference of Aggregate Relationships through Database Reverse Engineering. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 135–149. Springer, Heidelberg (1998)
Urban, S.D., Dietrich, S.W., Tapia, P.: Succeeding with Object Databases: Mapping UML Diagrams to Object-Relational Schemas in Oracle 8, pp. 29–51. John Wiley and Sons, Ltd, Chichester (2001)
Yan, L., Ling, T.W.: Translating Relational Schema with Constraints into OODB Schema. In: The IFIP WG 2.6 Database Semantics Conf. on Interoperable Database Systems, vol. A-25, pp. 69–85 (1993)
Vela, B., Marcos, E.: Extending UML to Represent XML Schemas. In: CAiSE Short Paper Proceedings (2003)
Zhang, X., Zhang, Y., Fong, J., Jia, X.: Transforming RDB Schema to Well-structured OODB Schema. Info. & Soft. Tech. 41, 275–281 (1999)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Maatuk, A., Ali, A., Rossiter, N. (2008). Relational Database Migration: A Perspective. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds) Database and Expert Systems Applications. DEXA 2008. Lecture Notes in Computer Science, vol 5181. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85654-2_58
Download citation
DOI: https://doi.org/10.1007/978-3-540-85654-2_58
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-85653-5
Online ISBN: 978-3-540-85654-2
eBook Packages: Computer ScienceComputer Science (R0)