Relational Database Migration: A Perspective
Pages 676 - 683
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.
References
[1]
Alhajj, R.: Extracting the Extended Entity-Relationship Model from a Legacy Relationals Database. Info. Syst. 28, 597-618 (2003)
[2]
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)
[3]
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)
[4]
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)
[5]
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)
[6]
Du, W., Lee, M., Ling, T.W.: XML Structures for Relational Data. In: WISE (1), pp. 151-160 (2001)
[7]
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)
[8]
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)
[9]
Fong, J.: Converting Relational to Object-Oriented Databases. SIGMOD Record 26, 53-58 (1997)
[10]
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)
[11]
Fong, J., Wong, H.K., Cheng, Z.: Converting Relational Database into XML Documents with DOM. Info. & Soft. Tech. 45, 335-355 (2003)
[12]
Kleiner, C., Lipeck, U.W.: Automatic Generation of XML DTDs from Conceptual Database Schemas. GI Jahrestagung (1), 396-405 (2001)
[13]
Maatuk, A., Ali, A., Rossiter, N.: A Framework for Relational Database Migration. TR (2008), http://computing.unn.ac.uk/staff/cgma2/papers/RDBM.pdf
[14]
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)
[15]
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)
[16]
Premerlani, W.J., Blaha, M.R.: An Approach for Reverse Engineering of Relational Databases. Communications of the ACM 37, 42-49 (1994)
[17]
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)
[18]
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)
[19]
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)
[20]
Vela, B., Marcos, E.: Extending UML to Represent XML Schemas. In: CAiSE Short Paper Proceedings (2003)
[21]
Zhang, X., Zhang, Y., Fong, J., Jia, X.: Transforming RDB Schema to Wellstructured OODB Schema. Info. & Soft. Tech. 41, 275-281 (1999)
- Relational Database Migration: A Perspective
Recommendations
Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation
CICSYN '15: Proceedings of the 2015 7th International Conference on Computational Intelligence, Communication Systems and NetworksRelational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, ...
Hierarchical to Relational Database Migration
Although database migration has not yet been extensively researched, three predominant software solutions have evolved: language interfaces, source-code conversion, and data propagation. The authors consider how Swiss Bank and IBM designed and developed ...
Migration of data from relational database to graph database
ICIST '18: Proceedings of the 8th International Conference on Information Systems and TechnologiesRelational databases have been widely used in many applications until today and they have met needs for data-intensive domains and transactions, but today data is growing faster than ever and extracting information from this huge data is becoming more ...
Comments
Information & Contributors
Information
Published In
Publisher
Springer-Verlag
Berlin, Heidelberg
Publication History
Published: 01 September 2008
Qualifiers
- Article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 0Total Downloads
- Downloads (Last 12 months)0
- Downloads (Last 6 weeks)0
Reflects downloads up to 25 Dec 2024