DBScholar

Back to papers

Deriving Production Rules for Constraint Maintenance

Summary: Introduces production-rule-based maintenance of integrity constraints via an SQL-like language and a translation framework from constraints to rule-driven repairs. Guarantees end-of-transaction consistency under set-oriented rules, with automatic and user-guided translation, demonstrated on a sizable example. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h858f3f6ce5113913
Venue
VLDB
Year
1990
Pagerank
0.00010898439
Overall Rank
1,372 | 90.78%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{ceri_vldb90,
        title = {{Deriving Production Rules for Constraint Maintenance}},
        author = {Ceri, Stefano and Widom, Jennifer},
        journal = {PVLDB},
        series = {{VLDB} '90},
        pages = {566--577},
        year = {1990}
}

Incoming Citations (Sorted by Pagerank)

Showing 22 of 22 citing papers.

Rank Citing Paper Year Venue Pagerank
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023212582
737 Set-Oriented Production Rules in Relational Database Systems 1990 SIGMOD 0.00014359198
1,521 Constraint Checking with Partial Information 1994 PODS 0.00010379636
1,627 Implementing Set-Oriented Production Rules as an Extension to Starburst 1991 VLDB 0.00010038961
2,221 Promises and Realities of Active Database Systems 1995 VLDB 8.8109062e-05
2,380 Managing Semantic Heterogeneity with Production Rules and Persistent Queues 1993 VLDB 8.5469443e-05
2,546 A Model for Active Object Oriented Database 1991 VLDB 8.3177548e-05
2,848 On Maintaining Priorities in a Production Rule System 1991 VLDB 7.9429561e-05
3,185 Language Constructs for Programming Active Databases 1991 VLDB 7.556677e-05
3,517 Integrating Triggers and Declarative Constraints in SQL Database Systems 1996 VLDB 7.2422477e-05
3,600 Practical Applications of Triggers and Constraints: Successes and Lingering Issues 2000 VLDB 7.1765044e-05
3,864 On Implementing a Language for Specifying Active Database Execution Models 1993 VLDB 6.9626898e-05
3,894 Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism 1992 SIGMOD 6.9395397e-05
5,201 An Algebraic Approach to Rule Analysis in Expert Database Systems 1994 VLDB 6.2324243e-05
5,395 Semantics and Expressiveness Issues in Active Databases 1995 PODS 6.1496965e-05
5,856 Implementing High Level Active Rules on top of a Relational DBMS 1992 VLDB 5.9696592e-05
6,976 Real-Time Integrity Constraints (extended abstract) 1992 PODS 5.6299711e-05
8,397 Data Management for Large Rule Systems 1991 VLDB 5.3402439e-05
8,604 Integrity Maintenance in an Object-Oriented Database 1992 VLDB 5.3047716e-05
13,202 Unrolling Cycle to Decide Trigger Termination 1999 VLDB 4.9793485e-05
13,305 Database De-Centralization - A Practical Approach 1995 VLDB 4.9793485e-05
13,363 Combining Theory and Practice in Integrity Control: A Declarative Approach to the Specification of a Transaction Modification Subsystem 1993 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
87 Implementation of Integrity Constraints and Views by Query Modification 1975 SIGMOD 0.00035719146
147 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00029019485
203 The Architecture Of An Active Data Base Management System* 1989 SIGMOD 0.00025229522
273 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022504729
610 Active Databases as a Paradigm for Enhanced Computing Environments 1983 VLDB 0.0001558453
737 Set-Oriented Production Rules in Relational Database Systems 1990 SIGMOD 0.00014359198
2,844 Making Deductive Database a Practical Technology: a step forward 1990 SIGMOD 7.9475065e-05
2,941 Constraint Equations: Declarative Expression of Constraints With Automatic Enforcement 1984 VLDB 7.8321091e-05
3,628 PRISM: A Knowledge Based System for Semantic Integrity Specification and Enforcement in Database Systems 1984 SIGMOD 7.1506476e-05
3,956 Enforcing Inclusion Dependencies and Referential Integrity 1988 VLDB 6.9003868e-05
5,042 On the Modes and Meaning of Feedback to Transaction Designers 1987 SIGMOD 6.3002599e-05
6,267 Integrity Constraint Reformulation for Efficient Validation 1987 VLDB 5.8297934e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,082 Transactions And Integrity Constraints 1985 PODS
2 6,371 Integrity Constraints Checking In Deductive Databases 1991 VLDB
3 8,604 Integrity Maintenance in an Object-Oriented Database 1992 VLDB
4 9,420 The Role of Integrity Constraints in Database Interoperation 1996 VLDB
5 33 Consistent Query Answers in Inconsistent Databases 1999 PODS
6 246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB
7 2,640 Knowledge-based Integrity Constraint Validation 1986 VLDB
8 8,674 Checking Consistency of Database Constraints: a Logical Basis 1986 VLDB
9 737 Set-Oriented Production Rules in Relational Database Systems 1990 SIGMOD
10 4,179 Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints 1987 PODS