6. etapp: Füüsilise andmemudeli kujundamine
Kompetentsi Andmete modelleerimine knobit · K-658 · Teadmine
Explains history strategies and validity-period conventions
Mida see tähendab
Effective dating, SCD type 2, history tables and bi-temporal designs, with half-open validity periods.
Kuidas seda hinnatakse
Chooses a history strategy for sample needs and checks sample periods for overlap and gaps
Tugineb
Vajalik
- Recognises an overwrite where history is requiredK-622 · Oskus
- Recognises inconsistent validity periods in a versioned tableK-623 · Oskus
- Recognises a reference to a versioned table by business key aloneK-624 · Oskus
- Recognises history kept without its constraints checkedK-705 · Oskus
- Recognises a past event judged against present dataK-715 · Oskus