July 2010
Intermediate to advanced
976 pages
30h 19m
English
Content preview from Information Modeling and Relational Databases, 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
11.1. Implementing a Conceptual Schema
Most database modeling tools allow you to enter a data model in one or more high level notations (e.g., ER, IDEF1X, ORM, or UML), as well as a logical level notation (e.g., relational). Typically a high level (conceptual or semiconceptual) schema must be mapped down to a logical and then physical schema in order for the database to be populated and queried. Assuming you do the right thing and model first at the conceptual level, the main steps in implementing your data model are as follows.
Design the conceptual schema
Annotate the conceptual schema with mapping choices as needed
Map the design to a logical schema (e.g., relational or object-relational)
Finesse the logical schema as needed (e.g., rename or ...