XML and Relational Databases

When constructing the logical data design of the actual data you're using, there is a number of items to consider. SQL databases and XML documents have a set of similarities that can be used to associate specific data with the XML representation of that data.

As you construct your logical data model, the first step is to identify the entities that are going to be modeled. Entities can be any person, place, thing, or concept. These entities are analogous to structural elements in an XML database.

The next step would be to identify individual data points that are used to describe the entities we defined earlier. These are normally referred to as attributes, in which they are associated “adjectives” that describe elements. ...

Get Special Edition Using XML, Second 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.