Importing XML documents to Relational Databases
using Java

Introduction
These days, most companies across all industries use relational databases or RDBMS (Relational Databases Management Systems) to store and manage their critical business information. In fact, the three most important relational databases vendors happen to be the three most important software companies of the world: Oracle, IBM (DB2), and Microsoft (SQL Server). In parallel, over the last four years, XML has become the undisputable standard both for data exchange and content management. As a consequence, many thousands of database and application developers are now facing the development challenge of converting XML data to a relational format.

After first describing the underlying reasons for unmarshalling (or importing) XML documents to relational databases, we will describe conceptually how to map any XML document to any relational database using clear and simple examples. In the last section, reserved for Java developers, we will provide and comment on Java code to unmarshal an XML document to a relational database as JDBC and the SAX API provide to the programmer a universal way to unmarshal any XML document to any relational database.

Next: Conclusion

Back: White Papers