2004Unpublished venueRequires access

Improving the SCC protocol for real-time transaction concurrency control

J. Haubert, Bruno Sadeg, Laurent Amanton

Open publisher page 3 citations

Abstract

For real-time DBMSs (RTDBMSs), both the integrity constraints of the database and the temporal constraints of the transactions must be respected. In this paper, we focus on the SCC real-time concurrency control protocol proposed by Bestavros et al. (1992, 1995, 1993). It is based on the duplication of the transactions and the use of the transaction timestamps to resolve the transaction conflicts. Despite its great performances in real-time distributed DBMSs (Bestavros A et al., 1993), we propose an extension of the protocol to improve this performances in two ways: (1) the write-write conflicts are resolved with a particular method that is, to our mind, not applicable in real-time context and (2) for other conflicts, we propose an extended deadline-driven method combined with the transaction duplication. In this way, more transactions respect their deadlines.

About this research paper

What this paper is about

For real-time DBMSs (RTDBMSs), both the integrity constraints of the database and the temporal constraints of the transactions must be respected. In this paper, we focus on the SCC real-time concurrency control protocol proposed by Bestavros et al. (1992, 1995, 1993). It is based on the duplication of the transactions and the use of the transaction timestamps to resolve the transaction conflicts. Despite its great performances in real-time distributed DBMSs (Bestavros A et al., 1993), we propose an extension of the protocol to improve this performances in two ways: (1) the write-write conflicts are resolved with a particular method that is, to our mind, not applicable in real-time context and (2) for other conflicts, we propose an extended deadline-driven method combined with the transaction duplication. In this way, more transactions respect their deadlines.

Why it matters

OpenAlex reports 3 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

For real-time DBMSs (RTDBMSs), both the integrity constraints of the database and the temporal constraints of the transactions must be respected. In this paper, we focus on the SCC real-time concurrency control protocol proposed by Bestavros et al. (1992, 1995, 1993). It is based on the duplication of the transactions and the use of the transaction timestamps to resolve the transaction conflicts. Despite its great performances in real-time distributed DBMSs (Bestavros A et al., 1993), we propose an extension of the protocol to improve this performances in two ways: (1) the write-write conflicts are resolved with a particular method that is, to our mind, not applicable in real-time context and (2) for other conflicts, we propose an extended deadline-driven method combined with the transaction duplication. In this way, more transactions respect their deadlines.

Key concepts: Computer science, Concurrency control, Serializability, Optimistic concurrency control, Distributed transaction, Database transaction, Timestamp-based concurrency control, Distributed computing

Related papers

Back to paper searchBrowse research topicsOriginal source
Improving the SCC protocol for real-time transaction concurrency control — Research Paper | ScholarLens