ACM Transactions on Database Systems · 1993 · 56 citations · 33 references
ComputingComputer ScienceData ManagementDatabasesFormal MethodsConcurrency ControlConsistency ModelsData IntegrityDatabase ManagementTransaction ManagementConflict SerializabilityConsistencyDatabase Integrity ConstraintsDatabase Management SystemsIntegrityIntegrity ConstraintsSerializabilityView Serializability
The semantics of objects and transactions in database systems are investigated. The authors propose three new correctness criteria for database consistency. User‑defined consistency assertions define three criteria—consistency, orderability, and strong order‑ability—that generalize serializability concepts while preserving integrity constraints. Orderability criteria allow users to operate with isolation while the database system maintains integrity constraints, unlike consistency.
The semantics of objects and transactions in database systems are investigated. User-defined predicates called consistency assertions are used to specify user programs. Three new correctness criteria are proposed. The first correctness criterion consistency is based solely on the users' specifications and admit nonserializable executions that are acceptable to the users. Integrity constraints of the database are maintained through consistency assertions. The second correctness criterion orderability is a generalization of view serializability and represents a weak notion of equivalence to a serial schedule. Finally, the third correctness criterion strong order-ability is introduced as a generalization of conflict serializability. Unlike consistency, the notions of orderability allow users to operate an isolation as maintenance of the integrity constrainst now becomes the responsibility of the database system.
33
An axiomatic basis for computer programming
C. A. R. Hoare · Communications of the ACM · 1969 · 3.9K citations · Full text
The notions of consistency and predicate locks in a database system
Kapali P. Eswaran, Jim Gray, Raymond A. Lorie et al. · Communications of the ACM · 1976 · 2K citations · Full text
C. Mohan, Don Haderle, Bruce G. Lindsay et al. · ACM Transactions on Database Systems · 1992 · 1K citations · Full text