Abstract
Transactions are a significant concept in database systems, facilitating functions both at user and system level. However transaction support in temporal DBMSs has not yet received enough research attention. In this paper, we present techniques for incorporating transaction support in a temporal DBMS, which is implemented as an additional layer to a commercial RDBMS. These techniques overcome certain limitations imposed by the underlying RDBMS, and avoid excessive increment of the log size.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Date C. J. An introduction to database systems, Vol. II. Addison-Wesley Publishing Company, 1985.
Tanenbaum A. S. Modern operating systems. Prentice Hall Inc. 1992.
Pliroforiki, University of Athens, Agricultural University of Athens, Information Dynamics. ESPRIT III Project 7224 (ORES) Deliverable D4. 1. Implementation of valid time SQL, April 1994.
Lorentzos N. The interval extended relational model and its application to valid time databases. In: Temporal databases: theory, design and implementation. Clifford J, Snodgrass R. et al ( Ed. ). Benjamin Cummings, 1993, pp. 67 - 91.
Pliroforiki. ESPRIT III Project 7224 (ORES) Deliverable D2. Specification of valid time SQL, April 1993.
ORACLE Corporation. SQL language reference manual (for version 6. 0 ), 1990.
Sybase Inc. Transact SQL user’s guide (for release 4. 2 ), 1990.
Codd E. F. A relational model of data for large shared data banks. Communications of the ACM, 1990; 13 (6): 377 - 387.
Pliroforiki, UMIST. ESPRIT III Project 7224 (ORES) Deliverable C3. Specification of valid time formalism. April 1993.
Ingres Corporation. Ingres SQL and ESQL reference manual (for release 6. 4 ), 1991.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1995 British Computer Society
About this paper
Cite this paper
Vassilakis, C., Lorentzos, N., Georgiadis, P. (1995). Transaction Support in a Temporal DBMS. In: Clifford, J., Tuzhilin, A. (eds) Recent Advances in Temporal Databases. Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3033-8_14
Download citation
DOI: https://doi.org/10.1007/978-1-4471-3033-8_14
Publisher Name: Springer, London
Print ISBN: 978-3-540-19945-8
Online ISBN: 978-1-4471-3033-8
eBook Packages: Springer Book Archive