A data model decides which tables exist, what one row means, and how tables relate. The same BookNest orders can be modeled three ways, each tuned for a different job: normalized for the application that takes orders, dimensional for the analysts who study them, and Data Vault for the integration layer that must keep every version of every record. Analytical SQL and Data Warehouses builds the dimensional model for real; this section shows how the paradigms differ and when each one fits.
MENU
Data Modeling Paradigms
Data Modeling Paradigms at a Glance