Live briefing
Everything about Transaction time
In temporal databases, transaction time is the time when some data has been loaded into a database. The time when a transaction is valid can be called the transaction time-period. It is a technical timeline controlled by a integration layer. More formally, it is the point-in-time during which a fact stored in the database is considered to be true. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Transaction timeA 5-minute orientation
- Skim a recent paper: TxT: Real-Time Transaction Encapsulation for Ethereum Smart ContractsInfluential work since 2022
- Pick up a classic book: Multilevel secure transaction processingThe most-reprinted book on the subject
- Read the landmark paper: Transaction-cost Economics in Real TimeCited 475 times
- Go sideways: Valid timeA closely related topic
- Go sideways: Temporal databaseA closely related topic
📖 Definitions
Noun The time during which a fact stored in the database, represented by all the information in a row, is considered to be true and in effect.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Transaction-cost Economics in Real Time
Option Replication in Discrete Time with Transaction Costs
Continuous-Time Markowitz's Model with Transaction Costs
Sampling Returns for Realized Variance Calculations: Tick Time or Transaction Time?
Incremental implementation model for relational databases with transaction time
Transaction time indexing with version compression
Real-time transaction scheduling in database systems
Managing and querying transaction-time databases under schema evolution
🆕 Influential since 2022
TxT: Real-Time Transaction Encapsulation for Ethereum Smart Contracts
Analysis of inter-transaction time fluctuations in the cryptocurrency market
Optimized User-Friendly Transaction Time Management in the Blockchain Distributed Energy Market
A Time-Aware Generative Network for Enhancing Transaction Security in Consumer Electronics
Time-adjusted transaction costs for energy renovations for single-family house-owners
📚 Books worth reading
Multilevel secure transaction processingVijay Atluri, Vijay Atluri · 1999- 📕Concurrency control for transactions with prioritiesKeith Marzullo · 1990
Performance analysis of data sharing environmentsAsit Dan · 1992
Transaction managementChorafas, Dimitris N. · 1998
VisualAge and transaction processing in a client/server environmentAndreas Bitterer · 1996- 📕On-line transaction processingCaroline Daniels · 1992
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Valid time In temporal databases, valid-time is the time period when an event happened or something was true in the real world, or more formally when a fact was valid…
- Temporal database A temporal database stores data relating to time instances. It offers temporal data types and stores information relating to past, present and future time…
- SQL:2011 SQL:2011 or ISO/IEC 9075:2011 (under the general title "Information technology – Database languages – SQL") is the seventh revision of the ISO (1987) and…
- Richard T. Snodgrass Richard Thomas Snodgrass (born April 19, 1955) is an American computer scientist and writer and is professor emeritus at the University of Arizona. He…
- Decision time In temporal databases, decision time is the time when a decision was made about a fact stored in a database.[citation needed] It is used to keep a history…
- Bitemporal modeling Bitemporal modeling is a specific case of temporal database information modeling technique designed to handle historical data along two different timelines…
- Change data capture In databases, change data capture (CDC) is a set of software design patterns used to determine and track the data that has changed (the "deltas") so that…
- Sixth normal form Sixth normal form (6NF) is a normal form used in relational database normalization which extends the relational algebra and generalizes relational operators…