All relevant facts, constraints and derivation rules are expressed in controlled natural language sentences that are intelligible to users in the business domain being modelled. This allows ORM data models to be validated by business domain experts who are unfamiliar with ORM’s graphical notation. For the data modeler, ORM’s graphical notation covers a much wider range of constraints than can be expressed in industrial ER or UML class diagrams, and thus allows rich visualization of the underlying semantics.
Written as a sequel to the author’s previous book Object-Role Modeling Fundamentals, this book briefly reviews the fundamentals of ORM, and then discusses additional topics such as model reports generation, vocabulary glossaries, relational mapping options, annotated relational schemas, schema optimization, and data modeling patterns. Written in easy-to-understand language, it illustrates each topic with simple examples, and explains how to use the freeware NORMA tool to implement the ideas discussed. The book also includes many practical exercises to promote expertise in the techniques covered, with answers provided to all the exercise questions.
1 Review of ORM Basics
1.1 Introduction
1.2 ORM’s Conceptual Schema Design Procedure
1.3 A Worked Example
1.4 Review Exercises
2 Documenting Models
2.1 Generating Model Reports
2.2 Vocabulary Glossaries
3 Relational Mapping
3.1 Overview of ORM’s Relational Mapping Procedure
3.2 Downloading and Viewing a Sample NORMA Model
3.3 Controlling Table and Column Names in NORMA
3.4 Subtype Mapping Options
3.5 Annotating Relational Schemas
4 Modeling Exercises
4.1 Academic Conference
4.2 Course Prerequisites
4.3 Concert Bookings
4.4 British Monarchy
4.5 Malaysia Database
4.6 Nobel Prize Awards
4.7 Academy Awards
5 Transforming and Optimizing Schemas
5.1 Conceptual Schema Transformations
5.2 Conceptual Schema Optimization
5.3 Database Reengineering
5.4 Solar System Exercise
6 Some Data Model Patterns
6.1 Temporal Aspects
6.2 Collection Types
Appendix A: ORM Symbol Glossary
Appendix B: Further Resources
Answers
Index
No comments:
Post a Comment