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 |8 pages

Introduction

part |2 pages

Mathematical Templates

chapter |25 pages

Tree Template

chapter |27 pages

Directed Graph Template

chapter |11 pages

Undirected Graph Template

chapter |10 pages

Item Description Template

chapter |7 pages

Star Schema Template

chapter |3 pages

Summary of Templates

part |1 pages

Antipatterns

part |1 pages

Archetypes

chapter |26 pages

Archetypes

part |1 pages

Identity

chapter |8 pages

Identity

part |1 pages

Canonical Models

chapter |9 pages

Language Translation

chapter |18 pages

Softcoded Values

chapter |12 pages

Generic Diagrams

chapter |5 pages

State Diagrams

part |2 pages

Relational Database Design

chapter |18 pages

Relational Database Design