The Concurrency Control Mechanism of SDD-1: A System for Distributed Databases (The Fully Redundant Case).

SDD-1, A System for Distributed Databases, is a distributed database system being developed by Computer Corporation of America (CCA), Cambridge, MA. SDD-1 permits data to be stored redundantly at several database sites in order to enhance the reliability and responsiveness of the system and to facilitate upward scaling of system capacity. This paper describes the method used by SDD-1 for updating data that are stored redundantly. Redundant updating can be costly because it may potentially involve extensive intercomputer communication overhead in order to lock all copies of data being updated. The method described here avoids this overhead by identifying cases in which it is not necessary to perform this global database locking. The identification of transactions that do not require global locking is based on a predefinition of transaction classes performed by the database administrator using an analysis technique described herein. The classes defined are used at run time to decide what level of synchronization is needed for a given transaction. It is important to note that this predefinition activity in no way limits the transactions that the system can accept; it merely permits more efficient execution of those types of transactions that were anticipated. [ABSTRACT FROM AUTHOR]