Decision time

Uses your system voice; voice and rate in settings.

Snapshot

≈ 2 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

In temporal databases, decision time is the time when a decision was made about a fact stored in a database. It is used to keep a history of decisions about valid times. In a database table, the start and end time of the decision time interval can be represented by adding two table columns. This interval is closed [ in the lower bound, and open at the upper bound ). When a decision has not been replaced, the end time of the decision is unknown, and it can thus be considered valid "until changed" or infinite (∞). Valid time and decision time are ways of modeling data, and is not applicable for all types of data, and transaction time is hence the most used temporal functionality. The concept of decision time can for example be used in bitemporal databases (together with valid time instead of transaction time), or in tritemporal databases.

In temporal databases, decision time is the time when a decision was made about a fact stored in a database. It is used to keep a history of decisions about valid times. In a database table, the start and end time of the decision time interval can be represented by adding two table columns. This interval is closed [ in the lower bound, and open at the upper bound ). When a decision has not been replaced, the end time of the decision is unknown, and it can thus be considered valid "until changed" or infinite (∞). Valid time and decision time are ways of modeling data, and is not applicable for all types of data, and transaction time is hence the most used temporal functionality. The concept of decision time can for example be used in bitemporal databases (together with valid time instead of transaction time), or in tritemporal databases.

Text derived from https://en.wikipedia.org/w/index.php?oldid=1235764922 under CC BY-SA 4.0; modifications have been made.

Sources cited in this revision

Extracted from the cited revision's reference blocks; absent citations are not invented.