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 type 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