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.00010857402
Overall Rank
1,377 | 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.00023146423
739 Set-Oriented Production Rules in Relational Database Systems 1990 SIGMOD 0.0001430589
1,522 Constraint Checking with Partial Information 1994 PODS 0.00010341308
1,634 Implementing Set-Oriented Production Rules as an Extension to Starburst 1991 VLDB 0.00010001512
2,236 Promises and Realities of Active Database Systems 1995 VLDB 8.777981e-05
2,394 Managing Semantic Heterogeneity with Production Rules and Persistent Queues 1993 VLDB 8.5155561e-05
2,552 A Model for Active Object Oriented Database 1991 VLDB 8.2863926e-05
2,858 On Maintaining Priorities in a Production Rule System 1991 VLDB 7.9141449e-05
3,198 Language Constructs for Programming Active Databases 1991 VLDB 7.5282913e-05
3,527 Integrating Triggers and Declarative Constraints in SQL Database Systems 1996 VLDB 7.214911e-05
3,608 Practical Applications of Triggers and Constraints: Successes and Lingering Issues 2000 VLDB 7.1494e-05
3,875 On Implementing a Language for Specifying Active Database Execution Models 1993 VLDB 6.9365895e-05
3,908 Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism 1992 SIGMOD 6.913498e-05
5,226 An Algebraic Approach to Rule Analysis in Expert Database Systems 1994 VLDB 6.2089519e-05
5,417 Semantics and Expressiveness Issues in Active Databases 1995 PODS 6.1264606e-05
5,871 Implementing High Level Active Rules on top of a Relational DBMS 1992 VLDB 5.9471111e-05
6,999 Real-Time Integrity Constraints (extended abstract) 1992 PODS 5.6087771e-05
8,418 Data Management for Large Rule Systems 1991 VLDB 5.3200866e-05
8,629 Integrity Maintenance in an Object-Oriented Database 1992 VLDB 5.2847278e-05
13,249 Unrolling Cycle to Decide Trigger Termination 1999 VLDB 4.9605343e-05
13,352 Database De-Centralization - A Practical Approach 1995 VLDB 4.9605343e-05
13,410 Combining Theory and Practice in Integrity Control: A Declarative Approach to the Specification of a Transaction Modification Subsystem 1993 VLDB 4.9605343e-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.00035589793
148 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00028920518
205 The Architecture Of An Active Data Base Management System* 1989 SIGMOD 0.00025137529
275 Extensible Query Processing in Starburst 1989 SIGMOD 0.000224395
614 Active Databases as a Paradigm for Enhanced Computing Environments 1983 VLDB 0.00015527367
739 Set-Oriented Production Rules in Relational Database Systems 1990 SIGMOD 0.0001430589
2,855 Making Deductive Database a Practical Technology: a step forward 1990 SIGMOD 7.9175265e-05
2,956 Constraint Equations: Declarative Expression of Constraints With Automatic Enforcement 1984 VLDB 7.8031737e-05
3,642 PRISM: A Knowledge Based System for Semantic Integrity Specification and Enforcement in Database Systems 1984 SIGMOD 7.1236523e-05
3,973 Enforcing Inclusion Dependencies and Referential Integrity 1988 VLDB 6.8743322e-05
5,068 On the Modes and Meaning of Feedback to Transaction Designers 1987 SIGMOD 6.2764805e-05
6,282 Integrity Constraint Reformulation for Efficient Validation 1987 VLDB 5.8077724e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,105 Transactions And Integrity Constraints 1985 PODS
2 6,385 Integrity Constraints Checking In Deductive Databases 1991 VLDB
3 8,629 Integrity Maintenance in an Object-Oriented Database 1992 VLDB
4 9,456 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,651 Knowledge-based Integrity Constraint Validation 1986 VLDB
8 8,702 Checking Consistency of Database Constraints: a Logical Basis 1986 VLDB
9 739 Set-Oriented Production Rules in Relational Database Systems 1990 SIGMOD
10 4,194 Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints 1987 PODS