Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
ORACLE performance tuning
Inside ODBC
ORACLE PL/SQL programming
Mediation in information systems
ACM Computing Surveys (CSUR)
Database management: principles and products
Database management: principles and products
On the semantics of “now” in databases
ACM Transactions on Database Systems (TODS)
PDIS '94 Proceedings of the third international conference on on Parallel and distributed information systems
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Benchmark Handbook: For Database and Transaction Processing Systems
Benchmark Handbook: For Database and Transaction Processing Systems
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
The Implementation of POSTGRES
IEEE Transactions on Knowledge and Data Engineering
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
The Design of the POSTGRES Storage System
VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
Layered Temporal DBMS: Concepts and Techniques
Proceedings of the Fifth International Conference on Database Systems for Advanced Applications (DASFAA)
Stratum Approaches to Temporal DBMS Implementation
IDEAS '98 Proceedings of the 1998 International Symposium on Database Engineering & Applications
Adaptable query optimization and evaluation in temporal middleware
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Capturing Delays and Valid Times in Data Warehouses—Towards Timely Consistent Analyses
Journal of Intelligent Information Systems - Special issue on data warehousing and knowledge discovery
Transaction Timestamping in (Temporal) Databases
Proceedings of the 27th International Conference on Very Large Data Bases
Managing Time Consistency for Active Data Warehouse Environments
DaWaK '01 Proceedings of the Third International Conference on Data Warehousing and Knowledge Discovery
ACM Transactions on Database Systems (TODS)
Modification semantics in now-relative databases
Information Systems
An efficient method for temporal aggregation with range-condition attributes
Information Sciences—Informatics and Computer Science: An International Journal
A Fuzzy Set-Based Approach to Temporal Databases
SUM '07 Proceedings of the 1st international conference on Scalable Uncertainty Management
Transaction time indexing with version compression
Proceedings of the VLDB Endowment
Concurrency control and recovery for multiversion database structures
Proceedings of the 2nd PhD workshop on Information and knowledge management
A query processor for prediction-based monitoring of data streams
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Extraction of timeER model from a relational database
ACIIDS'11 Proceedings of the Third international conference on Intelligent information and database systems - Volume Part I
Journal of Intelligent Information Systems
Hi-index | 0.00 |
Many existing database applications place various timestamps on their data, rendering temporal values such as dates and times prevalent in database tables. During the past two decades, several dozen temporal data models have appeared, all with timestamps being integral components. The models have used timestamps for encoding two specific temporal aspects of database facts, namely transaction time, when the facts are current in the database, and valid time, when the facts are true in the modeled reality. However, with few exceptions, the assignment of timestamp values has been considered only in the context of individual modification statements.This paper takes the next logical step: It considers the use of timestamping for capturing transaction and valid time in the context of transactions. The paper initially identifies and analyzes several problems with straightforward timestamping, then proceeds to propose a variety of techniques aimed at solving these problems. Timestamping the results of a transaction with the commit time of the transaction is a promising approach. The paper studies how this timestamping may be done using a spectrum of techniques. While many database facts are valid until now, the current time, this value is absent from the existing temporal types. Techniques that address this problem using different substitute values are presented. Using a stratum architecture, the performance of the different proposed techniques are studied. Although querying and modifying time-varying data is accompanied by a number of subtle problems, we present a comprehensive approach that provides application programmers with simple, consistent, and efficient support for modifying bitemporal databases in the context of user transactions.