Converting relational database into XML documents with DOM

Abstract The revolution of XML is recognized as the trend of technology on the Internet to researchers as well as practitioners. Companies need to adopt XML technology. With investment in the current relational database systems, they want to develop new XML documents while running existing relational databases on production. They need to reengineer the relational databases into XML documents with constraints preservation. In the process, schema translation must be done before data conversion. Since the existing relational databases are usually normalized, they have to be reconstructed into XML document tree structures. This can be accomplished through denormalization by joining the normalized relations into tables according to their data dependencies constraints. The joined tables are mapped into DOMs, which are then integrated into XML document trees. The user specifies an XML document root with its relevant nodes to form a partitioned XML document tree to meet their requirements. The selected XML document tree is mapped into an XML schema in the form of DTD. We then load joined tables into DOMs, integrate them into a DOM, and transform it into an XML document.

[1]  Iraklis Varlamis,et al.  Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents , 2001, DocEng '01.

[2]  Qing Li,et al.  WebReader: a mechanism for automating the search and collecting information from the World Wide Web , 2000, Proceedings of the First International Conference on Web Information Systems Engineering.

[3]  Hongjun Lu,et al.  VXMLR: A Visual XML-Relational Database System , 2001, VLDB.

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

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

[6]  Tharam S. Dillon,et al.  Towards Query Translation from XQL to SQL , 2001 .

[7]  J. S. P. Fong,et al.  Methodology for schema translation from hierarchical or network into relational , 1992, Inf. Softw. Technol..

[8]  Michael J. Carey,et al.  XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents , 2000, VLDB.

[9]  Dan Suciu,et al.  Data on the Web: From Relations to Semistructured Data and XML , 1999 .

[10]  Joseph Fong,et al.  Converting relational to object-oriented databases , 1997, SGMD.

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

[12]  Latifur Khan,et al.  A performance evaluation of storing XML data in relational database management systems , 2001, WIDM '01.

[13]  Toshiyuki Amagasa,et al.  XRel: a path-based approach to storage and retrieval of XML documents using relational databases , 2001, ACM Trans. Internet Techn..

[14]  David J. DeWitt,et al.  Relational Databases for Querying XML Documents: Limitations and Opportunities , 1999, VLDB.

[15]  Joseph Fong,et al.  Data conversion rules from network to relational databases , 1994, Inf. Softw. Technol..