Here follows a collection of books and articles that you may find to be of interest in pursuing knowledge and wisdom about data modeling.
You may order any book from Amazon.com by simply clicking on the title.
Barker, R. CASE Method*Entity Relationship Modelling, Addison-Wesley Publishing Company:Wokingham, England, 1989.
The definitive book on data modeling using the Oracle notation.
Bruce, T.
Designing Quality Databases with IDEF1X Information Models, Dorset House Publishing:New York,
1992.
IDEF1X is the data modeling approach championed by the folks
who brought you the Post Office, the Immigration and Naturalization Service, and the twelve dollar
hammer. 'Nough said. Still, if you have to learn it, this is the best book on the subject.
Carlis, J. and Joseph Maguire
Mastering Data Modeling, Addison-Wesley: Boston,
2002.
An excellent introduction to data modeling, which takes the extraordinary
position that data models are primarily for communication with non-technical people. This means
that the notation should be as simple and concise as possible. They have created a stripped down
notation that nicely achieves the objectives they set out.
Chen, P.,
"The Entity-Relationship Approach to Logical Data Base Design", The QED Monograph Series:
Data Base Management, Q.E.D. Information Sciences:Wellesley, MA, 1977.
This was the original article describing entity/relationship
modeling.
Fowler, M,
Analysis Patterns: Reusable Object Models, Addison Wesley:Reading, MA, 1997.
A book on data model patterns with an object-oriented flair.
____________,
UML Distilled - Second Edition: Applying the Standard Object Modeling Language, Addison-Wesley:Reading,
MA, 1997.
The Unified Modeling Language, created by Grady Booch, Ivar
Jacobson, and James Rumbaugh, is being positioned as the notation to replace the dozen or so
data/object model notations currently in use. This book is a useful introduction to the topic.
Halpin, T.
Conceptual Schema & Relational Database Design, Second Edition, Prentice-Hall of
Australia Pty Ltd:Sydney, 1995.
Object Role Modeling (ORM, formerly known as NIAM) is a modeling technique that is significantly different from data modeling, but with some decided advantages. Terry Halpin is ORM's most articulate exponent.
Hay, D., Data Model Patterns: Conventions of Thought, Dorset House Publishing:New York, 1996.
David Hay is President of Essential Strategies, Inc. What else needs to be said?
McComb, D., Semantics in Business Systems: The Savvy Manager's Guide, Morgan Kaufman Publishers: San Francisco, 2004.
Behind every data model is (or should be) the language of the business. Mr McComb recasts the modeler's task as one of capturing and understanding the semantics used by people in an organization. This requires a complete understanding of the meaning behind the organization's language.
Rogers, U. Oracle: A Database Developer's Guide, Yourdon Press:Englewood Cliffs, NJ, 1991.
How to model, design, and implement systems using Oracle's relational database management system and tools. The tools portion is out of date, but the princples are valid, and a new version is expected soon.
Ross, R.G. The Business Rule Book, Database Research Group, Inc.:Boston, 1994.
The definitive book on business rules, describing the atomic components of all business rules, and a method for representing them.
Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F., and Lorensen, W. Object-oriented Modeling and Design, Prentice-Hall, Inc.:Englewood Cliffs, NJ, 1991.
Rumbaugh & Co. were the original proponents of "object-oriented systems analysis". For all they claim to be new, their notation is essentially entities with behavior. Their notation is being replaced by the Unified Modeling Language (UML).
Schmidt, Bob
Data Modeling For Information Professionals, Prentice-Hall, Inc.:Englewood Cliffs, NJ, 1998.
This innovative tutorial provides an excellent grounding in
the underlying principles of modeling data and objects. It begins by describing the
the basic concepts of domains and names, then moves to predicates (attributes and relationships),
and only then moves to entity occurrences. Unlike other data modeling books, it finally gets to
classes
(entities) in Chapter Six. And this turns out to be just the right order. It includes
case studies. Highly recommended.
Shlaer, S., and Mellor, S. Object-oriented Systems Analysis: Modeling the World in Data. Yourdon Press:Englewood Cliffs, NJ, 1988.
This was one of the first "object modeling" books, and it uses a particularly attractive notation. It effectively presents entity/relationship modeling under the guise of object modeling.
_______, Object-oriented Systems Analysis: Modeling the World in States, Yourdon Press:Englewood Cliffs, NJ, 1992.
These two books describe a series of techniques for bringing together data-oriented object models and behavior models.
Simsion, G.
Data Modeling Essentials: Analysis, Design, and Innovation, International Thompson Computer
Press:Melbourne, 1994.
A tutorial on data modeling that includes an excellent
section on converting models to database designs.
________ and Graham C. Witt,
Data Modeling Essentials: Analysis, Design, and Innovation (2d Edition), Coriolis Group,
LLC:Scottsdale, AZ, 2001.
A significant revision of their earlier book, adding discussions
of business rules and data warehousing, and expanding on their description of the data modeling task.
von Halle, B, & Fleming, C. Handbook of Relational Database Design, Addison-Wesley Publishing Co:Reading, PA,1988.
A guide to the various problems and aspects of designing relational databases. It describes the entire process from modeling through table design, including an approach to capturing business rules.