LOIS: The ``Lights Out'' Integrity Subsystem

  • Authors:
  • Nicholas J. Caine;Suzanne M. Embury

  • Affiliations:
  • -;-

  • Venue:
  • BNCOD 18 Proceedings of the 18th British National Conference on Databases: Advances in Databases
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

Despite many years of research into mechanisms for checking integrity in databases, current commercial systems provide support for checking only the simplest forms of integrity constraints. However, both the users and developers of database applications are increasingly aware of the problems that can arise when poor quality data is allowed to enter, and remain within, large scale databases. Clearly, some form of integrity checking is required for such applications, but it must be packaged in a way that respects the business context in which the application is to operate. In particular, this means acknowledging that mission critical transaction processing cannot be delayed while integrity checks are made. In this paper, we propose an approach which makes use of periods of low database activity for integrity checking.We present a range of algorithms for scheduling integrity checks during these periods, and describe the results of our initial experiments with the system.