Abstract:
XML has become the important standard for data denotation and exchange in the web. One of the most popular used of XML is as a data storage facility. The initial purpose is to store XML data into relational database without using DTD information. In order to store XML data into relational database, there are two major components: schema mapping and data mapping. In particular, we have developed an efficient algorithm which takes an XML DTD as input and produces a relational schema as output for storing and querying XML documents conforming to the input DTD. This paper proposed schema generation approach that generates relational schema depend on input XML document which need to store in relational database. By using this, DTD information is not needed to use to generate relational schema. Experimental results are presented to show this schema generation approach is efficient and scalable.