Practical Applications of Triggers and Constraints: Successes and Lingering Issues

Summary: Historical survey of constraints and triggers, distinguishing handcrafted versus generated logic and kernel, service, or application deployment. Recasts many trigger uses as integrity-constraint maintenance and identifies persistent gaps in standards, expressiveness, and system support. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 8843
Venue: VLDB
Year: 2000
Pagerank: 7.3411417e-05
Overall Rank: 3,528 | 75.80%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Stefano Ceri (Polytechnic University of Milan)
2. Roberta J. Cochrane (IBM)
3. Jennifer Widom (Stanford University)

BibTeX Citation

@article{ceri_vldb00,
        title = {{Practical Applications of Triggers and Constraints: Successes and Lingering Issues}},
        author = {Ceri, Stefano and Cochrane, Roberta J. and Widom, Jennifer},
        journal = {PVLDB},
        series = {{VLDB} '00},
        pages = {254},
        year = {2000}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,634	DBToaster: Agile Views in a Dynamic Data Management System	2011	CIDR	5.5770904e-05
8,577	A-Tree: A Dynamic Data Structure for Efficiently Indexing Arbitrary Boolean Expressions	2021	SIGMOD	5.409313e-05
9,400	PS-Tree-Based Efficient Boolean Expression Matching for High-Dimensional and Dense Workloads	2019	VLDB	5.2755515e-05
10,116	Please Don't Kill My Vibe: Empowering Agents with Data Flow Control	2026	CIDR	5.093636e-05
12,407	Business Policy Modeling and Enforcement in Databases	2011	VLDB	5.093636e-05
12,735	Event Processing with an Oracle Database	2005	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
81	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00036443459
258	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023131981
643	Materialized Views In Oracle	1998	VLDB	0.00015372449
1,276	Organizing Long-Running Activities with Triggers and Transactions	1990	SIGMOD	0.0001136991
1,329	Deriving Production Rules for Constraint Maintenance	1990	VLDB	0.00011140837
2,009	Rule Condition Testing and Action Execution in Ariel	1992	SIGMOD	9.3096289e-05
2,188	Promises and Realities of Active Database Systems	1995	VLDB	8.9886936e-05
2,334	Managing Semantic Heterogeneity with Production Rules and Persistent Queues	1993	VLDB	8.7336402e-05
2,820	On Maintaining Priorities in a Production Rule System	1991	VLDB	8.0911708e-05
3,475	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.3816996e-05
8,460	Maintenance of Cube Automatic Summary Tables	2000	SIGMOD	5.4216109e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,094	Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints	1987	PODS
2	1,329	Deriving Production Rules for Constraint Maintenance	1990	VLDB
3	1,489	Constraint Checking with Partial Information	1994	PODS
4	3,561	Ode as an Active Database: Constraints and Triggers	1991	VLDB
5	2,591	Knowledge-based Integrity Constraint Validation	1986	VLDB
6	5,270	Semantics and Expressiveness Issues in Active Databases	1995	PODS
7	2,277	Compiling complex database transition triggers	1989	SIGMOD
8	2,188	Promises and Realities of Active Database Systems	1995	VLDB
9	6,136	Eliminating Costly Redundant Computations from SQL Trigger Executions	1997	SIGMOD
10	3,475	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB