Importing XML documents to Relational Databases
using Java

Conclusions
This article introduced the basics of importing XML data to relational databases. With XML being quickly adopted as a data format, more and more XML documents are being decomposed and stored in scalable and high-performance relational databases. We explained the mechanisms of going from an XML schema to a database schema with clear and simple examples. We concluded by providing the user with some sample Java for the simplest import: a table-based mapping. The purpose of the code presented here was more to outline the complexity of unmarshalling than to give an exhaustive and maintainable solution to be used in production systems. As a consequence, we recommend the use of third-party tools from companies that have invested some years of development to provide a general and easy approach to mapping any type of XML document to a relational database. In database development projects that require support for multiple and complex XML or SOAP interfaces, a tool like jAllora can generate the maximum value as each mapping interface is abstracted to an user interface easily maintainable.

Register: Download entire white paper

Back: Introduction