Best-selling author and database expert with more than 25 years of experience modeling application and enterprise data, Dr. Michael Blaha provides tried and tested data model patterns, to help readers avoid common modeling mistakes and unnecessary frustration on their way to building effective data models. Unlike the typical methodology book, Patterns of Data Modeling provides advanced techniques for those who have mastered the basics.

Recognizing that database representation sets the path for software, determines its flexibility, affects its quality, and influences whether it succeeds or fails, the text focuses on databases rather than programming. It is one of the first books to apply the popular patterns perspective to database systems and data models. It offers practical advice on the core aspects of applications and provides authoritative coverage of mathematical templates, antipatterns, archetypes, identity, canonical models, and relational database design.

chapter 1|8 pages


part I|2 pages

Mathematical Templates

chapter 2|25 pages

Tree Template

chapter 3|27 pages

Directed Graph Template

chapter 4|11 pages

Undirected Graph Template

chapter 5|10 pages

Item Description Template

chapter 6|7 pages

Star Schema Template

chapter 7|3 pages

Summary of Templates

part II|1 pages


chapter 8|14 pages

Universal Antipatterns

chapter 9|8 pages

Non-Data-Warehouse Antipatterns

part III|1 pages


chapter 10|26 pages


part IV|1 pages


chapter 11|8 pages


part V|1 pages

Canonical Models

chapter 12|9 pages

Language Translation

chapter 13|18 pages

Softcoded Values

chapter 14|12 pages

Generic Diagrams

chapter 15|5 pages

State Diagrams

part VI|2 pages

Relational Database Design

chapter 16|18 pages

Relational Database Design