Review by David Haertzen
As a great fan of David Hay’s earlier book, Data Model Patterns: Conventions of Thought, I was pleased to see his newest work. That earlier work helped me to think like a data modeler and to produce data models that flexibly adapt to the changing needs of business. The new book does not disappoint.
The author explains how data modeling can be applied to understanding an organization and its functions. He uses the Zachman Framework which explains multiple perspectives on systems development: planner, owner, architect, designer, builder and functioning system user. Be ready to think like an architect who is modeling the business rather than as a database designer who is concerned with designing tables and columns.
David Hay has organized data models into multiple levels and explains the purpose and structure of each level. Level 0 is the most abstract – it provides a Metamodel and pattern for the other levels. Level 1 describes the basic enterprise data model which includes: parties, geographic locations, assets, activities and timing. Level 2 specifies functionally specific areas: facilities, human resources, marketing, contracts, manufacturing and laboratory. Finally, level 3 is industry specific and includes examples: criminal justice, microbiology, banking, oil field production and highway maintenance. Upon reflection, I see that these levels correspond to the levels in the TOGAF Enterprise Continuum.
See review at Amazon.