DBXML - Connecting XML with relational databases

In this paper, we introduce a software system, called DBXML that provides a transformation utility to connect XML with relational databases. The transformation utility can convert data both ways from XML-Schema to relational database schema and from relational database schema to XML-Schema. In the meantime it performs conversions between the data in the XML documents and the relational database. XML-Schema as defined by the World Wide Web Consortium is used to enforce data tape constraints and primary/foreign key relationships in the generated XML document. Most similar systems support conversion between relational databases and the Document Type Definitions (DTD). The XML-Schema is preferred over DTD for several reasons, such as customizable data types, stricter XML structures, and ability to enforce referential constraints. The system has a simple GUI (Graphical User Interface) that currently works on all versions of Windows. It can be extended to support other platforms, operating systems, and RDBMS.