• DocumentCode
    1100620
  • Title

    A formal characterization of epsilon serializability

  • Author

    Ramamritham, Krithi ; Pu, Calton

  • Author_Institution
    Dept. of Comput. Sci., Massachusetts Univ., Amherst, MA, USA
  • Volume
    7
  • Issue
    6
  • fYear
    1995
  • fDate
    12/1/1995 12:00:00 AM
  • Firstpage
    997
  • Lastpage
    1007
  • Abstract
    Epsilon serializability (ESR) is a generalization of classic serializability (SR). In this paper, we provide a precise characterization of ESR when queries that may view inconsistent data run concurrently with consistent update transactions. Our first goal is to understand the behavior of queries in the presence of conflicts and to show how ESR in fact is a generalization of SR. So, using the ACTA framework, we formally express the intertransaction conflicts that are recognized by ESR and through that define ESR, analogous to the manner in which conflict-based serializability is defined. Secondly, expressions are derived for the amount of inconsistency (in a data item) viewed by a query and its effects on the results of a query. These inconsistencies arise from concurrent updates allowed by ESR. Thirdly, in order to maintain the inconsistencies within bounds associated with each query, the expressions are used to determine the preconditions that operations have to satisfy. The results of a query, and the errors in it, depend on what a query does with the (possibly inconsistent) data viewed by it. One of the important byproducts of this work is the identification of different types of queries which lend themselves to an analysis of the effects of data inconsistency on the results of the query
  • Keywords
    concurrency control; data integrity; database theory; formal specification; query processing; transaction processing; ACTA framework; concurrency control; concurrent queries; concurrent updates; conflict-based serializability; consistent update transactions; data inconsistency; data operation preconditions; epsilon serializability; errors; formal techniques; intertransaction conflicts; Character recognition; Computer science; Concurrency control; Concurrent computing; Paramagnetic resonance; Strontium; Transaction databases;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/69.476504
  • Filename
    476504