Stage 6: Design the physical data model
Knobit of Data modelling · K-658 · Knowledge
Explains history strategies and validity-period conventions
What it means
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
Builds on
- Explains current value, history and point-in-time reproducibilityK-155 · Knowledge
Needed by
- Recognises an overwrite where history is requiredK-622 · Skill
- Recognises inconsistent validity periods in a versioned tableK-623 · Skill
- Recognises a reference to a versioned table by business key aloneK-624 · Skill
- Recognises history kept without its constraints checkedK-705 · Skill
- Recognises a past event judged against present dataK-715 · Skill