Stratum approaches to temporal DBMS implementation

Previous approaches to implementing temporal DBMSs have assumed that a temporal DBMS must be built from scratch, employing an integrated architecture and using new temporal implementation techniques such as temporal indexes and join algorithms. However, this is a very large and time-consuming task. The paper explores approaches to implementing a temporal DBMS as a stratum on top of an existing non-temporal DBMS, rendering implementation more feasible by reusing much of the functionality of the underlying conventional DBMS. More specifically, the paper introduces three stratum meta-architectures, each with several specific architectures. Based on a new set of evaluation criteria, advantages and disadvantages of the specific architectures are identified. The paper also classifies all existing temporal DBMS implementations according to the specific architectures they, employ. It is concluded that a stratum architecture is the best short, medium, and perhaps even long-term, approach to implementing a temporal DBMS.

[1]  Alan R. Simon.  Strategic Database Technology: Management for the Year 2000 , 1995 .

[2]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[3]  Ralph Johnson,et al.  design patterns elements of reusable object oriented software , 2019 .

[4]  Michael H. Böhlen,et al.  Temporal database system implementations , 1995, SGMD.

[5]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1987, TODS.

[6]  Michael Stonebraker,et al.  The Design of the POSTGRES Storage System , 1988, VLDB.

[7]  Guido Schmutz,et al.  Die zeitbezogene Datenhaltung bei den Schweizer Regionalbanken , 1997, Wirtsch..

[8]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[9]  David B. Lomet,et al.  Access methods for multiversion data , 1989, SIGMOD '89.

[10]  Christian S. Jensen,et al.  Adding Valid Time to SQL/Temporal , 1996 .

[11]  Richard T. Snodgrass,et al.  Partitioned storage for temporal databases , 1988, Inf. Syst..

[12]  Keun Ho Ryu,et al.  A temporal database management main memory prototype , 1994, Proceedings of TENCON'94 - 1994 IEEE Region 10's 9th Annual International Conference on: 'Frontiers of Computer Technology'.

[13]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[14]  Andreas Reuter,et al.  Transaction Processing: Concepts and Techniques , 1992 .

[15]  Christian S. Jensen,et al.  Seamless integration of time into sql , 1996 .

[16]  Panagiotis Georgiadis,et al.  A comparative study of temporal DBMS architectures , 1996, Proceedings of 7th International Conference and Workshop on Database and Expert Systems Applications: DEXA 96.

[17]  Michael Stonebraker,et al.  The Implementation of Postgres , 1990, IEEE Trans. Knowl. Data Eng..

[18]  Richard T. Snodgrass,et al.  Coalescing in Temporal Databases , 1996, VLDB.

[19]  Panagiotis Georgiadis,et al.  Transaction Support in a Temporal DBMS , 1995, Temporal Databases.

[20]  Christian S. Jensen,et al.  Efficient evaluation of the valid-time natural join , 1994, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.