Transaction time

Transaction time

Transaction time (TT) is a concept used in temporal databases. It denotes the time period during which a database fact is/was stored in the database.

In a database table transaction time is often represented by two extra table-columns "StartTT" and "EndTT". The time interval is closed at its lower bound and open at its upper bound.

When the ending transaction time is unknown, it may be considered as "Until Closed". Academic researchers and some RDBMS have represented "Until Closed" with the largest timestamp supported or the keyword "forever". This convention is not technically precise.

* See also Valid time


Wikimedia Foundation. 2010.

Игры ⚽ Нужен реферат?

Look at other dictionaries:

  • Local transaction time —   An ISO term. The local time at which the transaction takes place at the card acceptor location. 6n …   International financial encyclopaedia

  • Time, local transaction —   An ISO term. See preferred term Local transaction time …   International financial encyclopaedia

  • Time protocol — (TP), est un protocole réseau visant à synchroniser les horloges de plusieurs systèmes informatiques sur un même réseau informatique. Sommaire 1 Histoire 2 Principe 2.1 Transaction en TCP …   Wikipédia en Français

  • Time Protocol — Fonction Synchronisation des horloges Sigle TP Port 37 RFC …   Wikipédia en Français

  • Transaction verification — is the generic term to describe the Internet based security method of verifying that the actual content of a transaction has not been altered by the fraudulent techniques known as Man in the Middle (MitM) and Man in the Browser (MitB). This form… …   Wikipedia

  • Transaction-level modeling — (TLM) is a high level approach to modeling digital systems where details of communication among modules are separated from the details of the implementation of functional units or of the communication architecture. Communication mechanisms such… …   Wikipedia

  • Transaction data — is data describing an event (the change as a result of a transaction) and is usually described with verbs. Transaction data always has a time dimension, a numerical value and refers to one or more objects (i.e. the reference data). Typical… …   Wikipedia

  • Transaction Workflow Innovation Standards Team — (Twist) is a not for profit industry standards group. It does not charge anything for involvement. The main goal of Twist is to create non proprietary XML message standards for the financial services industry. To this end it provides a message… …   Wikipedia

  • transaction processing — noun (computing) The use of an online computer to interrogate or update files in real time • • • Main Entry: ↑transact …   Useful english dictionary

  • Transaction processing system — A Transaction Processing System To be considered a transaction processing system the computer must pass the ACID test.From a technical perspective, a Transaction Processing System (or Transaction Processing Monitor) monitors transaction programs …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”