Storing DTD-independent XML data in relational database

Abstract

XML is playing an increasingly important role in the exchange of a wide variety of data on the Web. The volume of XML data exchange is explosively increasing, and the need for efficient mechanisms of XML data management is vital. One of the most popular used of XML is as a data storage facility. Many XML storage models have been proposed for storing XML data in relational database systems. In this paper, we present how to create dynamic relational schema and store XML data only depend on input XML document. For this process, we propose DTD-independent schema mapping algorithm and data mapping algorithm. Our DTD-independent schema mapping algorithm uses data extraction approach that extracts table names and attributes of the input XML document to create a document schema, and data mapping algorithm stores all extracted XML information into relational tables by mapping outputs of DTD-independent schema mapping algorithm. Our proposed system reduce the step of creating relational schema depend on DTD information. So we do not need DTD information , can solve the problem of missing elements and attributes of inputs DTD and XML document, and will get similar result of DTD-dependent approach.