Metadata model to support the mapping of concepts

Figure E.4 shows how the two separate metadata models may be combined to provide the capability of recording how two or more conceptual data models relate to each other or how physical SQL implementations match the conceptual data models from which they are derived.

The mapping structure allows one or more elements of one conceptual data model to be mapped to one or more elements in another conceptual data model (for example, a many-to-many relationship in the first model is equivalent to two one-to-many relationships and an entity in the second model). One or more elements of an SQL schema can be mapped to one or more elements in its conceptual data model (for example, a supertype entity and ...

Get Principles of Data Management 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.