Schema and Data Migration of a Relational Database RDB to the Extensible Markup Language XML

Authors: Alae El Alami, Mohamed Bahaj

Abstract:

This article discusses the passage of RDB to XML documents (schema and data) based on metadata and semantic enrichment, which makes the RDB under flattened shape and is enriched by the object concept. The integration and exploitation of the object concept in the XML uses a syntax allowing for the verification of the conformity of the document XML during the creation. The information extracted from the RDB is therefore analyzed and filtered in order to adjust according to the structure of the XML files and the associated object model. Those implemented in the XML document through a SQL query are built dynamically. A prototype was implemented to realize automatic migration, and so proves the effectiveness of this particular approach.

Keywords: RDB, XML, DTD, semantic enrichment.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1110594

References:

[1] Jinhyung Kim, Dongwon Jeong, Doo-Kwon Baik. A translation algorithm for effective rdb-to-xml schema conversion considering referential integrity information. Journal of information science and engineering 25, 137-166 (2009).
[2] Kanagaraj S, Dr Sunitha Abburu. Converting Relational Database Into Xml Document. IJCSI International Journal of Computer Science Issues, Vol. 9, Issue 2, No 1, March 2012 ISSN (Online): 1694-0814.
[3] J. Fong, H.K. Wong, Z. Cheng. Converting relational database into XML documents with DOM. information and Software Technology 45 (2003) 335–355.
[4] C. Wang, A. Lo, R. Alhajj, and K. Barker. “Converting Legacy Relational Database into XML Database through Reverse Engineering”. Proc. of ICEIS,2004.
[5] R. Alhajj, “Extracting the Extended Entity-Relationship Model from a legacy Relational Database, ”Information Systems, Vol.28, No.6,pp.597- 618, 2003.
[6] Orsini, R., Pagotto, M. (2001). Visual sql-x: A graphical tool for producing xml documents from relational databases. In Poster proceedings of the international world wide web conference. Hong Kong.
[7] R. Orsini, “A preliminary proposal for SQL-X: A Language to Extract XML Documents from Relational Databases”, SEBD 2000, L’Aquila, June 2000.
[8] Mihai Stancu. From relational databases to xml documents: efficient alternatives for publishing. International Journal of Digital Information and Wireless Communications (IJDIWC) 1(2): 545-553The Society of Digital Information and Wireless Communications, 2011(ISSN 2225- 658X).
[9] Gordana Pavlovic Lazetic. Native Xml Databases Vs. Relational Databases In Dealing With Xml Documents. Kragujevac J. Math. 30(2007) 181-199.
[10] Alae El Alami, Mohamed Bahaj; Migration of the Relational Data Base (RDB) to the Object Relational Data Base (ORDB); World Academy of Science, Engineering and Technology International Journal of Computer, Information Science and Engineering Vol:8 No:1, 2014.
[11] Mohamed Bahaj, Alae El Alami, The Migration Of Data From A Relational Database (Rdb) To An Object Relational (Ordb) Database. Journal of Theoretical and Applied Information Technology 20th December 2013. Vol. 58 No.2
[12] Alae El Alami, Mohamed Bahaj; The Road to a Full Migration of Relational Database (RDB) to Object Relational Database (ORDB): Semantic Enrichment, Target Schema, Data Mapping; International Journal of Advanced Information Science and Technology (IJAIST) ISSN: 2319:2682 Vol.30, No.30, October 2014.
[13] Alae El Alami, Mohamed Bahaj; The Migration of a Conceptual Object Model COM (Conceptual Data Model CDM, Unified Modeling Language UML class diagram ...) to the Object Relational Database ORDB; MAGNT Research Report (ISSN. 1444-8939) Vol.2 (4). PP: 318-32.
[14] Van der Vlist, Eric. Schematron. " O'Reilly Media, Inc.", 2007.