This Article 
 Bibliographic References 
 Add to: 
Differential Relational Calculus for Integrity Maintenance
March/April 1998 (vol. 10 no. 2)
pp. 328-341

Abstract—A differential calculus for first-order logic is developed to enforce database integrity. Formal differentiation of first-order sentences is useful in maintaining database integrity, since once a database constraint is expressed as a first-order sentence, its derivative with respect to a transaction provides the necessary and sufficient condition for maintaining integrity. The derivative is often much simpler to test than the original constraint since it maintains integrity differentially by assuming integrity before the transaction, and testing only for new violations. The formal differentiation requires no resolution search, but only substitution. It is more efficient than resolution-based approaches; and it provides a considerably more general solution than previous substitution-based methods since it is valid for all first-order sentences and with all transactions involving arbitrary collections of atomic changes to the database. It also produces a large number of sufficient conditions that are often less strict than those of the previous approaches; and it can be extended to accommodate many dynamic constraints.

[1] P.A. Bernstein and B. Blaustein, "A Simplification Algorithm for Integrity Assertions and Concrete Views," Proc. COMPSAC, pp. 90-99, 1981.
[2] P.A. Bernstein, "A Second Order Logic for Database Transaction Semantics," ACM Trans. Programming Languages and Systems, vol. 8, no. 2, 1983.
[3] C.L. Chang and R.C.T. Lee,Symbolic Logic and Mechanical Theorem Proving.New York: Academic Press, 1973.
[4] H. Gallaire,J. Minker,, and J. Nicolas,“Logic and databases: A deductive approach,” ACM Computing Surveys, vol. 16, no. 2, pp. 153-185, June 1984.
[5] A. Gupta, Y. Sagiv, J.D. Ullman, and J. Widom, "Constraint Checking with Partial Information," Proc. PODS, pp. 45-55, 1994.
[6] I. Kobayashi, "Validating Database Updates," Information Systems, vol. 9, no. 1, pp. 1-17, 1986.
[7] A.Y. Levy and Y. Sagiv, “Queries Independent of Updates,” Proc. Very Large Data Bases Conf., pp. 171-181, 1993.
[8] W. McCune and L. Henschen, “Maintaining State Constraints in Relational Databases,” J. ACM, vol. 36, no. 1, 1989.
[9] A. Motro, “Integrity=Validity+Completeness,” ACM Trans. Database Systems, vol. 14, no. 4, pp. 480-502, 1989.
[10] J.M. Nicolas, "Logic for Improving Integrity Checking in Relational Databases," Acta Informatica, vol. 18, pp. 227-253, 1982.
[11] G. Moerkotte and P.C. Lockemann, “Reactive Consistency Control in Deductive Databases,” ACM Trans. Database Systems, vol. 16, no. 4, pp. 670-702, 1991.
[12] L.V. Orman, "Queries = Examples + Counterexamples," Information Systems, vol. 21, no. 8, pp. 615-635, 1996.
[13] L.V. Orman, "Relational Database Constraints as Counterexamples," Acta Informatica, vol. 34, pp. 167-189, 1997.
[14] R. Paige and S. Koenig, "Finite Differencing of Computable Expressions," ACM Trans. Programming Languages and Systems, vol. 4, no. 3, pp. 403-454, July 1982.
[15] X. Qian and G. Wiederhold, Incremental Recomputation of Active Relational Expressions IEEE Trans. Knowledge and Data Eng. (TKDE), vol. 3, no. 3, pp. 337-341, Sept. 1991.
[16] R. Kowalski and F. Sadri, “A Theorem-Proving Approach to Database Integrity,” Foundations of Deductive Databases and Logic Programming, J. Minker, ed., pp. 313–362, Morgan Kaufman, 1988.
[17] M. Stonebraker et al., "The Postgres Rules System," IEEE Trans. Software Eng., vol. 14, no. 7, 1988.
[18] A. Shephard and L. Kerschberg, "PRISM: A Knowledge Based System for Semantic Integrity Specification and Enforcement in Database Systems," Proc. SIGMOD Conf., pp. 307-315, 1984.
[19] S.D. Urban and L.M. Delcambre, “Constraint Analysis: A Design Process for Specifying Operations on Objects,” IEEE Trans. Knowledge and Data Eng., vol. 2, no. 4, pp. 391-400, Apr. 1990.

Index Terms:
Database integrity, integrity maintenance, relational database, first-order logic, formal differentiation.
Levent V. Orman, "Differential Relational Calculus for Integrity Maintenance," IEEE Transactions on Knowledge and Data Engineering, vol. 10, no. 2, pp. 328-341, March-April 1998, doi:10.1109/69.683760
Usage of this product signifies your acceptance of the Terms of Use.