Implementing a temporal data management system within oracle

Authors:
Ramon Mata-Toledo;Morgan Monger
Affiliations:
James Madison University, Harrisonburg, VA;Datatel, Inc., Fairfax, VA
Venue:
Journal of Computing Sciences in Colleges
Year:
2008

Citing 6
Cited 2

Temporal database system implementations

ACM SIGMOD Record
Developing time-oriented database applications in SQL

Developing time-oriented database applications in SQL
Maintaining knowledge about temporal intervals

Communications of the ACM
Oracle PL/SQL Developer's Workbook

Oracle PL/SQL Developer's Workbook
A comparative study of temporal DBMS architectures

DEXA '96 Proceedings of the 7th International Workshop on Database and Expert Systems Applications
Temporal Data and the Relational Model

Temporal Data and the Relational Model

A temporal object relational SQL language with attribute timestamping in a temporal transparency environment

Data & Knowledge Engineering
Temporal query processing in Teradata

Proceedings of the 16th International Conference on Extending Database Technology

Quantified Score

Hi-index	0.00

Visualization

Abstract

A temporal data management system (TDMS) manages data that is tracked over time. In this paper, the authors present an implementation of a TDMS that provides a common temporal interface for application developers. The design, architectural objectives, and implementation constraints are also considered. The TDMS is designed to be transparent to the end-user and implemented as a subsystem in Oracle. The defining feature of this implementation is the emphasis on reference intervals and temporal relationships. An implementation based on native features provides automated temporal data management functions without complex application development, while providing acceptable performance. The benefits of the TDMS are that it provides a semiportable solution and maximizes on native features. The paper also considers an evaluation of the TDMS implementation comparison and benchmarking.