Developing Time-Oriented Database Applications in SQL¶
Snodgrass, R. T. (2000). Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann.
Cited by¶
2 citations across 2 artifacts.
Each citation links to the sentence it supports in the citing article.
Primes¶
- Event-Centered Modeling
- The result is that entities, places, periods, and roles are all re-derivable as projections of the event log, and contradictions surface when two events claim incompatible facts about the same participant at the same time — a property a property-on-entity model cannot detect.
This sourceFoundational treatment of temporal/bitemporal tables in which time-stamped facts (valid-time, transaction-time) are recorded so that contradictory or superseded assertions about the same entity at the same time are detectable rather than overwritten — supports the claim that inverting the wiring to events lets contradictions surface at a participant-time slice.
- The result is that entities, places, periods, and roles are all re-derivable as projections of the event log, and contradictions surface when two events claim incompatible facts about the same participant at the same time — a property a property-on-entity model cannot detect.
- Past-State Contamination
- Across all of them the load-bearing pair is identical: an index naming a moment, and an input whose reach began later.
This sourceEstablishes the bitemporal separation of valid time from transaction time, why overwrite-in-place storage makes prior belief states unrecoverable, and why a content date is not an availability time.
- Across all of them the load-bearing pair is identical: an index naming a moment, and an input whose reach began later.
Verification¶
This reference passed the adversarial substantiation pipeline: it was checked to exist and to support the claim it is attached to. See how references were verified.
Registry ID ref:29bc6ee24277 · see in the full table