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¶
Does it exist? Not checked yet. This entry carries no identifier to resolve. It was extracted from the citation as written in the article, normalized, and deduplicated against the rest of the registry.
Does it back the claim? Not recorded. Neither this nor any other of the 2 citations of this work carries a recorded support check.
Support is checked per citation rather than per work — the same source can be cited soundly in one article and wrongly in another. Per-citation recording began recently, so a citation with no recorded check is a gap in the record rather than evidence it went unchecked.
See how references were verified.
Registry ID ref:29bc6ee24277 · see in the full table