Towards a Tailored Theory of Consistency Enforcement in Databases

  • Authors:
  • Sebastian Link

  • Affiliations:
  • -

  • Venue:
  • FoIKS '02 Proceedings of the Second International Symposium on Foundations of Information and Knowledge Systems
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

The idea to enforce consistency in databases tries to overcome widely known weaknesses for consistency checking and verification techniques. In general terms, a database transition S is systematically modified to a new transition SI (greatest consistent specialization, GCS) that is provably consistent with respect to a given static constraint I, preserves the effects of S and is maximal with these properties.Effect preservation has been formalized by the operational specialization order 驴 on (semantic equivalence classes of) database transitions. Its simplicity makes it possible to establish a well-founded theory for reasonably large classes of database programs and static constraints. However, the specialization order may be criticized in some aspects, in particular in its coarseness.We characterize specialization of a database transition S by the preservation of all transition constraints that S satisfies (驴-constraints). This enables us to weaken the original order 驴 leading to the central definition of maximal consistent effect preservers (MCEs). We proof a normal form result for MCEs that relates them to GCSs and implies existence and uniqueness. This close relationship suggests the conjecture that there is a theory for MCEs similar to the GCS theory. We support this statement by showing that an MCE with respect to a set of static constraints can be enforced sequentially, and independently from the given order.