Embarking on conceptual design
Out of all the modeling types, conceptual captures and displays the least amount of detail. This makes conceptual modeling ideal for getting acquainted with a database landscape at a high level and for designing one from scratch. Designing data models is an art honed over many iterations, but where do you begin if you are new to modeling?
Dimensional modeling
In the early 2000s, Ralph Kimball and Margy Ross published the groundbreaking book The Data Warehouse Toolkit, which has persisted for decades as the authoritative blueprint for constructing database designs. Many of the terms, concepts, and techniques described in later chapters of this book trace their origins to The Data Warehouse Toolkit—whose latest edition fittingly carries the subtitle, The definitive guide to dimensional modeling.
To be clear, Kimball’s approach is not the only way to go about creating a conceptual model. The agile-based Business Event Analysis and...
