Halpin T., Morgan T. Information Modeling and Relational Databases

Elsevier Inc., 2008. — 970 p. — 2nd ed. — ISBN: 9780123735683Information Modeling and Relational Databases, second edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and programmers.
Terry Halpin, a pioneer in the development of ORM, blends conceptual information with practical instruction that will let you begin using ORM effectively as soon as possible. Supported by examples, exercises, and useful background information, his step-by-step approach teaches you to develop a natural-language-based ORM model, and then, where needed, abstract ER and UML models from it. This book will quickly make you proficient in the modeling technique that is proving vital to the development of accurate and efficient databases that best meet real business objectives.Industrial foreword
Academic forewordInformation levels and frameworks
Conceptual modeling: first steps
Uniqueness constraints
Mandatory roles
Value, set comparison and subtype constraints
Other constraints and final checks
Entity relationship modeling
Data modeling in UML
Relational mapping
Relational languages
Schema transformations
Other modeling aspects and trends
AnswersORM glossary
ER glossary
UML glossary