Data modeling · Keys & Relationships

Data Vault vs star schema

Harddata vaultstar schemaarchitecturemarts

Interview question

How does Data Vault compare to a star schema? When would you use each?

How to answer

The short answer

optimizes for analytics consumption: simple joins, clear grain, BI-friendly facts and dimensions.

Data Vault optimizes for enterprise integration and audit: many sources, insert-heavy history, resilient to source change.

Data VaultStar
Primary audienceIntegration / EDW teamsAnalysts, BI tools
ShapeHubs, links, satellitesFacts + dimensions
Change handlingSatellite history by designSCD on dimensions
Query simplicityHarder (many joins)Easier
Agility to add sourcesHighMedium (remodel marts)

Practical pattern

Use Vault (or a raw/silver integration model) as the system of record for integrated history; publish conformed stars for reporting. Freshers should not force Vault into every take-home if the interviewer only asked for a sales mart.

Interview tip

> "Vault for multi-source integration and audit; star for BI. Many platforms do both in layers."