Decision time


In temporal databases, decision time is the time at which the decision was made about a fact stored in a database. It is used to keep a history of decisions about valid times.
Decision time was coined by Mario Nascimento and Margaret Eich.
In a database table, the start and end times of the decision time interval may be represented by two additional table columns. This interval is closed at its lower bound and open at its upper bound. When a decision has not been superseded, the ending decision time is unknown and it may be considered as "until changed" or infinity.

Comparison to valid times and transaction times

In a tri-temporal database, valid times are a history of valid time ranges for facts stored in the database. Decision times are a history of decisions about valid times, and transaction times are a history of decision times. Hence transaction times are a history of histories of histories.
While ISO/IEC 9075 has included support for "application-time period tables" and "system-versioned tables" since, it does not include specific clauses for decision time.
Decision time is unconstrained in relationship to valid time, but it must be earlier than transaction time. e.g. decision time can't be assigned a date in the future.

Example

The following is a list of real-world events that occurred between the United States presidential elections of 1964 and 1976:
DateDecision MakerReal world event
November 3, 1964 Electoral College Election of 1964
November 5, 1968Electoral College Election of 1968
November 7, 1972Electoral College Election of 1972
October 10, 1973Spiro Agnew Agnew resigns
October 12, 1973Richard Nixon Nixon nominates Ford
December 6, 1973 CongressCongress confirms Ford
August 9, 1974Richard Nixon Nixon resigns
August 20, 1974Gerald Ford Ford nominates Rockefeller
December 19, 1974CongressCongress confirms Rockefeller
November 2, 1976Electoral College Election of 1976

Suppose there is a constant 7-day delay between the decision time and the transaction time committed to the database. Then following the election of 1976 the database contents would be:
President, Vice President, Valid From, Valid Till, Decision From, Decision To, Transaction From, Transaction To
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Administration
Consider the question of who would be President and Vice President for a valid time of 1-Jan-1977: