Explains history strategies and validity-period conventions
Effective dating, SCD type 2, history tables and bi-temporal designs, with half-open validity periods.
Can AI do this?
AI does this well Most of the tested AI models master this. 9 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 100% | Mastered |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | Mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 76% | Not shown |
| gpt-6-luna | Low cost | 100% | Mastered |
| claude-haiku-5-5 | Low cost | 100% | 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: Effective dating, SCD type 2, history tables and bi-temporal designs, with half-open validity periods
How it is assessed: Chooses a history strategy for sample needs and checks sample periods for overlap and gaps
Related knobits
Builds on
Needed for
- K-622 Recognises an overwrite where history is required
- K-623 Recognises inconsistent validity periods in a versioned table
- K-624 Recognises a reference to a versioned table by business key alone
- K-705 Recognises history kept without its constraints checked
- K-715 Recognises a past event judged against present data
All 40 knobits of Design the physical data model.
Source: Data-management practice used by the stage 6 reference and review checklist