The Align > Refine > Design Series
The Align > Refine > Design series covers conceptual, logical, and physical data modeling (schema design and patterns) for leading technologies, combining proven data modeling practices with database-specific features to produce better applications.
The book’s introduction and three chapters cover the Align, Refine, and Design approach. We include what the level does in the name by rebranding Conceptual, Logical, and Physical into Align, Refine, and Design. The introduction covers the three modeling characteristics of precise, minimal, and visual; the three model components of entities, relationships, and attributes (including keys); the three model levels of conceptual (align), logical (refine), and physical (design); and the three modeling perspectives of relational, dimensional, and query. Chapter 1, Align, is about agreeing on the common business vocabulary so everyone is aligned on terminology and general initiative scope. Chapter 2, Refine, is about capturing the business requirements. That is, refining our knowledge of the initiative to focus on what is essential. Chapter 3, Design, is about the technical requirements. That is, designing to accommodate our model’s unique software and hardware needs.
Align, Refine, and Design—that’s the approach followed in this book and reinforced through an animal shelter case study.
If you are interested in learning how to build multiple database solutions, read all the books in the Align > Refine > Design series. Since each book uses the same template, you can quickly skill up on additional database technologies.
MongoDB
About the Authors
Daniel Coupal is a Staff Engineer at MongoDB. He built the Data Modeling class for MongoDB University. Pascal Desmarets is the founder and CEO of Hackolade, a data modeling tool for NoSQL databases, storage formats, REST APIs, and JSON in RDBMS. He is a pioneer in Polyglot Data Modeling. Steve Hoberman has been a data modeler for over 30 years, and thousands have completed his Data Modeling Master Class. He is the author of nine books on data modeling, including Data Modeling Made Simple.
Neo4j
About the Authors
Steve Hoberman has been a data modeler for over 30 years, and thousands have completed his Data Modeling Master Class. He is the author of nine books on data modeling, including Data Modeling Made Simple. David Fauth is a Senior Field Engineer at Neo4j. He has expertise in Neo4j scalability, system architecture, geospatial, streaming data and security. He is currently focusing on solving large data volume challenges using Neo4j.
Elasticsearch
To be released September 2023 – Preorder on Amazon now!
About the Authors
Steve Hoberman has been a data modeler for over 30 years, and thousands have completed his Data Modeling Master Class. He is the author of nine books on data modeling, including Data Modeling Made Simple. Rafid has experience creating and expanding standardized financial data models and data delivery mechanisms using various modeling techniques. He also has experience in the data analytics space, performing in-depth analysis of Capital Markets, Retail Banking, and Insurance data.
TerminusDB
To be released September 2023 – Preorder on Amazon now!
About the Authors
Steve Hoberman has been a data modeler for over 30 years, and thousands have completed his Data Modeling Master Class. He is the author of nine books on data modeling, including Data Modeling Made Simple. Donny Winston is a consulting engineer who helps research data stewards design and deploy FAIR digital objects and services.
MarkLogic
To be released November 2023 – Preorder on Amazon now!
About the Authors
Steve Hoberman has been a data modeler for over 30 years, and thousands have completed his Data Modeling Master Class. He is the author of nine books on data modeling, including Data Modeling Made Simple. David Cassel is the founder of 4V Services, where he works with clients to implement Big Data solutions using MarkLogic and related technologies. David has more than 20 years’ experience as a developer, working with MarkLogic since 2009.
SQL Server
To be released January 2024 – Preorder on Amazon now!
About the Authors
Steve Hoberman has been a data modeler for over 30 years, and thousands have completed his Data Modeling Master Class. He is the author of nine books on data modeling, including Data Modeling Made Simple. Anthony Virgil is a seasoned data architecture and management leader with over 25 years of experience in commercial, government, and non-profit organizations. He has designed relational databases, operational data stores, data marts, data vaults, and data warehouses.