Skip to main content

Serializability

  • Reference work entry

Synonyms

Correctness criterion for concurrent executions

Definition

A database is a collection of data items operated on concurrently by several programs. A set of values for the data items is called a database state. It is consistent if the values satisfy the integrity constraints specified for the database. Arbitrary interleaving of the executions of the programs may affect the consistency of the database. The executions that preserve the consistency are called correct executions. The notion of serializability helps to identify correct executions. It is based on the transaction concept: a transactionis a partially ordered set of atomic steps that constitute an execution of a program, with the property that, when executed alone, it transforms a consistent database state into another consistent one. Examples of atomic steps are read and write of a data item, increment and decrement on a counter object, enqueue and dequeue on a queue object, etc. The sequence of steps in an execution...

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   2,500.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Recommended Reading

  1. Bernstein P.A., Shipman D.W., and Wong W.S. Formal aspects of serializability in database concurrency control. IEEE Trans. Software Eng., SE-5:203–215, 1979.

    MathSciNet  Google Scholar 

  2. Eswaran K.P., Gray J.N., Lorie R.A., and Traiger I.L. The notion of consistency and predicate locks in a database system. Commun. ACM, 19:624–633, 1976.

    MATH  MathSciNet  Google Scholar 

  3. Farrag A.A. and Özsu M.T. Using semantic knowledge of transactions to increase concurrency. ACM Trans. Database Syst., 14(4):503–525, 1989.

    Google Scholar 

  4. Garcia-Molina H. Using semantic knowledge for transactions processing in a distributed database. ACM Trans. Database Syst., 8(2):186–213, 1983.

    Google Scholar 

  5. Garcia-Molina H. and Salem K. Sagas. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1987, pp. 249–259.

    Google Scholar 

  6. Ibaraki T., Kameda T., and Minoura T. Serializability with constraints. ACM Trans. Database Syst., 12(3):429–452, 1987.

    MathSciNet  Google Scholar 

  7. Lynch N.A. Multilevel atomicity – a new correctness criterion for database concurrency control. ACM Trans. Database Syst., 8(4):485–502, 1983.

    MathSciNet  Google Scholar 

  8. Moss T.E.B. 1981.Nested Transactions: An Approach to Reliable Distributed Computing. MIT Laboratory for Computer Science, Cambridge, Massachusetts, Ph.D. Thesis, Technical Report MIT/LCS/TR-260,

    Google Scholar 

  9. Papadimitriou C.H. The serializability of concurrent database updates. J. ACM, 26:631–653, 1979.

    MATH  MathSciNet  Google Scholar 

  10. Papadimitriou C.H. and Kanellakis P. On concurrency control by multiple versions. ACM Trans. Database Syst., 9:(1):89–99, 1984.

    MATH  MathSciNet  Google Scholar 

  11. Vidyasankar K. Generalized theory of serializability. Acta Inf., 24:105–119, 1987.

    MATH  MathSciNet  Google Scholar 

  12. Vidyasankar K. Unified theory of database serializability. Fundamenta Inf., 14(2):147–183, 1991.

    MATH  MathSciNet  Google Scholar 

  13. Vidyasankar K. Generalized relative serializability. In Proc. of 9th Int. Conf. on Management of Data, 1998, pp. 313–327.

    Google Scholar 

  14. Vidyasankar K. and Dampney C.N.G. Version consistency and serializability in design databases. In Proc. 2nd Int. Conf. on Database Theory, 1988, pp. 368–382.

    Google Scholar 

  15. Weikum G. and Vossen G. Transactional information systems – theory, algorithms, and the practice of concurrency control and recovery. Morgan Kaufmann, 2002.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer Science+Business Media, LLC

About this entry

Cite this entry

Vidyasankar, K. (2009). Serializability. In: LIU, L., ÖZSU, M.T. (eds) Encyclopedia of Database Systems. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-39940-9_344

Download citation

Publish with us

Policies and ethics