Integrity checking in data base systems

Abstract There is the problem, how to control data base integrity. For many types of integrity assertions it is an unsolved problem, how to prove them in justifiable time. This paper deals with methods for improving the testing of semantic integrity assertions. First a classification of integrity assertions is given and a proposal for the implementation of a subsystem for controlling semantic integrity is described. Special algorithms are presented for testing delayed integrity assertions after the end of transactions, for testing integrity assertions, which contain functions, and for testing integrity assertions, which define relationships between values of attributes of different tuples. Using these algorithms in many cases the integrity test can be performed without any access to secondary storage, so that the cost for the tests becomes justifiable.

[1]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[2]  Donald D. Chamberlin,et al.  Functional specifications of a subsystem for data base integrity , 1975, VLDB '75.

[3]  C. J. Date Referential Integrity , 1981, VLDB.

[4]  Jean-Marie Nicolas,et al.  Integrity Checking in Deductive Data Bases , 1977, Logic and Data Bases.

[5]  Dennis McLeod,et al.  Semantic integrity in a relational data base system , 1975, VLDB '75.

[6]  Michael Hammer,et al.  Efficient monitoring of database assertions , 1978, SIGMOD '78.

[7]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[8]  Dennis McLeod,et al.  Database description with SDM: a semantic database model , 1981, TODS.

[9]  Dennis McLeod,et al.  Abstraction in databases , 1980, Workshop on Data Abstraction, Databases and Conceptual Modelling.

[10]  Eckhard D. Falkenberg,et al.  CSL: A Language for Defining Conceptual Schemas , 1979, IFIP TC-2 Working Conference on Data Base Architecture.