Database schema analysis

All or part of an XML document may consist of data extracted from a relational database. If the database schema has been created professionally, there should be documentation that describes the design. Database analysis frequently involves the production of entity relationship diagrams (E-R diagrams), which may be of use in helping to determine the XML data model. The reverse is also true; an existing XML document model may be used to help design the database schema, including the E-R diagrams describing it. In either case, it is interesting to compare DTD definitions with entity relationship diagrams. Note that an 'entity' in this case may actually be equivalent to an XML element.

In a one-to-one relationship, one entity ...

Get XML Companion, The, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.