ABSTRACT

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

Introduction

part 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 Part II|1 pages

Antipatterns

chapter 8|14 pages

Universal Antipatterns

chapter 9|8 pages

Non-Data-Warehouse Antipatterns

part Part III|1 pages

Archetypes

chapter 10|26 pages

Archetypes

part Part IV|1 pages

Identity

chapter 11|8 pages

Identity

part 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 Part VI|2 pages

Relational Database Design

chapter 16|18 pages

Relational Database Design