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

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.

Authors:

• Alae El Alami
• Mohamed Bahaj

Keywords:

• RDB
• XML
• DTD
• semantic enrichment.

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.