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: hc9ba02b27d2d7617
Venue: VLDB
Year: 2000
Pagerank: 7.1765044e-05
Overall Rank: 3,600 | 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,771	DBToaster: Agile Views in a Dynamic Data Management System	2011	CIDR	5.4553987e-05
8,745	A-Tree: A Dynamic Data Structure for Efficiently Indexing Arbitrary Boolean Expressions	2021	SIGMOD	5.2879425e-05
9,582	PS-Tree-Based Efficient Boolean Expression Matching for High-Dimensional and Dense Workloads	2019	VLDB	5.1571823e-05
10,343	Please Don't Kill My Vibe: Empowering Agents with Data Flow Control	2026	CIDR	4.9793485e-05
12,698	Business Policy Modeling and Enforcement in Databases	2011	VLDB	4.9793485e-05
13,025	Event Processing with an Oracle Database	2005	SIGMOD	4.9793485e-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
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035719146
246	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023212582
648	Materialized Views In Oracle	1998	VLDB	0.00015151422
1,300	Organizing Long-Running Activities with Triggers and Transactions	1990	SIGMOD	0.00011118207
1,372	Deriving Production Rules for Constraint Maintenance	1990	VLDB	0.00010898439
2,057	Rule Condition Testing and Action Execution in Ariel	1992	SIGMOD	9.1102693e-05
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,848	On Maintaining Priorities in a Production Rule System	1991	VLDB	7.9429561e-05
3,517	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.2422477e-05
8,621	Maintenance of Cube Automatic Summary Tables	2000	SIGMOD	5.3012918e-05

Semantically Similar Papers

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