Novel Approach for Reengineering Relational Databases into XML

In this paper, we present COCALEREX (converting relational to XML) which can address both catalog-based and legacy relational databases. It handles the latter category by first applying the reverse engineering approach described in [2] to extract the ER (Extended Entity Relationship) model from legacy relational databases. This reverse engineering approach is emplyed also not to extract from catalog-based databases meta-data not available in the catalog. Then, COCALEREX converts the ER to XML schema. Deriving the ER model empowers the proposed approach to smoothly consider many-to-many and nary relationships during the mapping into XML schema. COCALEREX provides a user-friendly interface that displays the result of each phase of the conversion process. Experimental results are encouraging, demonstrating the applicability and effectiveness of the proposed approach.

[1]  Jennifer Widom,et al.  The Lorel query language for semistructured data , 1997, International Journal on Digital Libraries.

[2]  Gerti Kappel,et al.  X-Ray - Towards Integrating XML and Relational Database Systems , 2000, ER.

[3]  Anthony Chiu Wa Lo,et al.  Flexible User Interface for Converting Relational Data into XML , 2004, FQAS.

[4]  Anthony Chiu Wa Lo,et al.  Converting Legacy Relational Database into XML Database through Reverse Engineering , 2004, ICEIS.

[5]  Dongwon Lee,et al.  Semantic Data Modeling Using XML Schemas , 2001, ER.

[6]  Minyi Guo,et al.  A Virtual XML Database Engine for Relational Databases , 2003, Xsym.

[7]  Joseph Fong,et al.  Converting relational database into XML document , 2001, 12th International Workshop on Database and Expert Systems Applications.

[8]  Paolo Atzeni,et al.  XML AND DATABASES , 2004 .

[9]  Hamid Pirahesh,et al.  Efficiently publishing relational data as XML documents , 2001, The VLDB Journal.

[10]  Reda Alhajj.  Extracting the extended entity-relationship model from a legacy relational database , 2003, Inf. Syst..

[11]  Dongwon Lee,et al.  NeT & CoT: translating relational schemas to XML schemas using semantic constraints , 2002, CIKM '02.

[12]  Carsten Kleiner,et al.  Automatic Generation of XML DTDs from Conceptual Database Schemas , 2001, GI Jahrestagung.

[13]  Dan Suciu,et al.  SilkRoute: trading between relations and XML , 2000, Comput. Networks.

[14]  Murali Mani,et al.  Taxonomy of XML schema languages using formal language theory , 2005, TOIT.

[15]  Dongwon Lee,et al.  Nesting-Based Relational-to-XML Schema Translation , 2001, International Workshop on the Web and Databases.

[16]  Christof Bornhövd,et al.  A generic load/extract utility for data transfer between XML documents and relational databases , 2000, Proceedings Second International Workshop on Advanced Issues of E-Commerce and Web-Based Information Systems. WECWIS 2000.