Enterprise Application Integration With XML and Java™

6.10. Mapping XML into Existing Schemas

So far, we've seen how to store and retrieve XML documents using text and BLOB fields in relational databases. We've also seen one method for modeling relational data in XML that captures the relationships defined by the original schema. This leads us to a discussion on mapping XML documents into existing database schemas assuming the aforementioned modeling technique, or one like it, was not used.

For example, translating an XML invoice from another company into an existing accounting system's schema would require a mapping process. Like modeling, there is no standard method for mapping XML documents into schemas, but there are few techniques that can simplify the problem.

1. Visual Mapping Tools. There ...