Designs views hiding physical structure from consumers
Views giving consumers a stable business-shaped interface
Can AI do this?
People still lead Few or none of the tested AI models showed they master this. 0 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 88% | Not shown |
| gemini-3.5-flash-lite | Low cost | 10% | Not shown |
| gpt-6-luna | Low cost | 10% | Not shown |
| claude-haiku-5-5 | Low cost | 10% | Not 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: Views giving consumers a stable business-shaped interface
How it is assessed: A view presents current account balances with business names over the partitioned history tables, so that reports survive a change of partitioning
Related knobits
Builds on
All 47 knobits of Design the physical data model.
Source: DAMA-DMBOK2 chapter 5, element(s) DM-19: a performance at CDMP Practitioner level