Implementation of transaction and concurrency control support in a temporal DBMS

TitleImplementation of transaction and concurrency control support in a temporal DBMS
Publication TypeJournal Article
Year of Publication1998
AuthorsVassilakis C, Lorentzos N., Georgiadis P.
JournalInformation Systems
Volume23
Pagination335–350
KeywordsConcurrency control, Data structures, Database systems, Temporal databases
AbstractTransactions and concurrency control are significant features in database systems, facilitating functions both at user and system level. However, the support of these features in a temporal DBMS has not yet received adequate research attention. In this paper, we describe the techniques developed in order to support transaction and concurrency control in a temporal DBMS that was implemented as an additional layer to a commercial DBMS. The proposed techniques make direct use of the transaction mechanisms of the DBMS. In addition, they overcome a number of limitations such as automatic commit points, lock release and log size increment, which are imposed by the underlying DBMS. Our measurements have shown that the overhead introduced by these techniques is negligible, less than 1% in all cases. The approach undertaken is of general interest, it can also be applied to non-temporal DBMS extensions. Copyright Β© 1998 Elsevier Science Ltd. All rights reserved.
URLhttps://doi.org/10.1016/S0306-4379(98)00015-5
DOI10.1016/S0306-4379(98)00015-5