Designs a Data Vault model for auditable history
Hubs for business keys, links for relationships and satellites for changing descriptive data with load dates and sources
Can AI do this?
AI does this well Most of the tested AI models master this. 3 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 90% | Mastered |
| gemini-3.5-flash-lite | Low cost | 91% | Mastered |
| gpt-6-luna | Low cost | 90% | Not shown |
| claude-haiku-5-5 | Low cost | 90% | Mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: Hubs for business keys, links for relationships and satellites for changing descriptive data with load dates and sources
How it is assessed: For customers and accounts from two source systems: hubs on the customer and account business keys, a link for holding, satellites per source with load date and record source; nothing overwritten
Related knobits
Builds on
All 47 knobits of Design the physical data model.
Source: DAMA-DMBOK2 chapter 5, element(s) DM-13: a performance at CDMP Practitioner level