Design of Automatic Database Schema Generator Based on XML Schema

Abstract

With the recent expansion of e-commerce, B2B has surfaced as an area of substantial interest to the corporate world. B2B refers to economic transactions created among businesses through various networks, including the Internet. Currently, XML documents are partially used in e-commerce for exchanging information among businesses, and the core corporate systems are expected to be based on XML as web service becomes more prevalent. In turn, many companies are becoming competitively involved in developing XML DBMS. Conventional XML DBMS studies use XML DTD to express the XML document structure. Since XML DTD defines simple format expressions, there are numerous difficulties in defining the XML document structure. In order to overcome such issues, this paper proposes an automatic conversion mechanism and algorithm for the relational database schema using the XML schema, which as been selected as the W3C standard, in order to store XML data in the relational database generally used in data content storage based on the XML schema. Furthermore, a module will be develop for converting the XML schema design based on this approach into a relational database schema. This should allow efficient management of the XML data through the relational database.