A System for Interactive Error Detection.

Gerald A. Wilson, Sandra B. Salazar: A System for Interactive Error Detection. VLDB 1979: 32-51
  author    = {Gerald A. Wilson and
               Sandra B. Salazar},
  editor    = {Antonio L. Furtado and
               Howard L. Morgan},
  title     = {A System for Interactive Error Detection},
  booktitle = {Fifth International Conference on Very Large Data Bases, October
               3-5, 1979, Rio de Janeiro, Brazil, Proceedings},
  publisher = {IEEE Computer Society},
  year      = {1979},
  pages     = {32-51},
  ee        = {db/conf/vldb/WilsonS79.html},
  crossref  = {DBLP:conf/vldb/79},
  bibsource = {DBLP,}


The system described in part in this paper is one of the ongoing research efforts to provide powerful automated tools for coping with data base error detection. Intended as a "filter" between the users and their DBMS, the Cooperative Overt Passive Error-Detection (COPE) system is designed to be easily interfaced to virtually any DBMS. COPE makes a clear distinction between the knowledge required to detect data base errors, and the procedures needed to apply that knowledge. The knowledge is represented in a DBMS independent Conceptual Model in the form of a special purpose language. This paper describes the mechanisms employed in COPE to apply the error detection knowledge of the Conceptual Model. The concept of dynamic transactions, transactions constructed on- the-fly, is introduced. Dynamic transactions permit the system to create independent "user contexts", which are single user views of a data base in the process of being updated. In addition to checking for errors within each user's actions, the system avoids having errors introduced in the data base due to undesirable interactions between users. The use of these techniques enables COPE to be applied to both pre-existing data bases, and proposed data base updates. The system can operate interactively, so that users may request explanations for the errors reported to them, and obtain some forms of assistance in determining appropriate corrections.

Copyright © 1979 by The Institute of Electrical and Electronic Engineers, Inc. (IEEE). Abstract used with permission.

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Antonio L. Furtado, Howard L. Morgan (Eds.): Fifth International Conference on Very Large Data Bases, October 3-5, 1979, Rio de Janeiro, Brazil, Proceedings. IEEE Computer Society 1979
Contents BibTeX


Kapali P. Eswaran, Donald D. Chamberlin: Functional Specifications of Subsystem for Database Integrity. VLDB 1975: 48-68 BibTeX
J. J. Florentin: Consistency Auditing of Databases. Comput. J. 17(1): 52-58(1974) BibTeX
Robert W. Graves: Integrity Control in a Relational Data Description Language. ACM Pacific 1975: 108-113 BibTeX
Michael Hammer, Dennis McLeod: Semantic Integrity in a Relational Data Base System. VLDB 1975: 25-47 BibTeX
Michael Stonebraker: Implementation of Integrity Constraints and Views by Query Modification. SIGMOD Conference 1975: 65-78 BibTeX

Referenced by

  1. Gerald A. Wilson: A Conceptual Model for Semantic Integrity Checking. VLDB 1980: 111-125
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings (1977-1981): Copyright © by IEEE,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:45:05 2009