Practical Applications of Triggers and Constraints: Successes and Lingering Issues
Summary: Traces the rise of SQL constraints (SQL-92) and triggers (SQL-99) and surveys their practical deployment across kernel DBMS, DBMS services, and external apps. Frames trigger use as constraint maintenance; contrasts handcrafted vs generated and flags remaining gaps. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,880 | DBToaster: Agile Views in a Dynamic Data Management System | 2011 | CIDR | 4.6250755e-05 |
| 8,583 | A-Tree: A Dynamic Data Structure for Efficiently Indexing Arbitrary Boolean Expressions | 2021 | SIGMOD | 4.4859208e-05 |
| 9,261 | PS-Tree-Based Efficient Boolean Expression Matching for High-Dimensional and Dense Workloads | 2019 | VLDB | 4.3648789e-05 |
| 9,967 | Please Don't Kill My Vibe: Empowering Agents with Data Flow Control | 2026 | CIDR | 4.1905499e-05 |
| 12,220 | Business Policy Modeling and Enforcement in Databases | 2011 | VLDB | 4.1905499e-05 |
| 12,551 | Event Processing with an Oracle Database | 2005 | SIGMOD | 4.1905499e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 69 | Implementation of Integrity Constraints and Views by Query Modification | 1975 | SIGMOD | 0.00060388875 |
| 267 | Deriving Production Rules for Incremental View Maintenance | 1991 | VLDB | 0.00029818774 |
| 470 | Materialized Views In Oracle | 1998 | VLDB | 0.00022386815 |
| 1,076 | Organizing Long-Running Activities with Triggers and Transactions | 1990 | SIGMOD | 0.00014229211 |
| 1,206 | Deriving Production Rules for Constraint Maintenance | 1990 | VLDB | 0.00013297347 |
| 1,429 | Managing Semantic Heterogeneity with Production Rules and Persistent Queues | 1993 | VLDB | 0.00012029869 |
| 1,889 | Promises and Realities of Active Database Systems | 1995 | VLDB | 0.00010192436 |
| 2,106 | Rule Condition Testing and Action Execution in Ariel | 1992 | SIGMOD | 9.5297652e-05 |
| 2,152 | On Maintaining Priorities in a Production Rule System | 1991 | VLDB | 9.4201789e-05 |
| 3,140 | Integrating Triggers and Declarative Constraints in SQL Database Systems | 1996 | VLDB | 7.4912441e-05 |
| 8,169 | Maintenance of Cube Automatic Summary Tables | 2000 | SIGMOD | 4.5662628e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,353 | Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints | 1987 | PODS | 0.00012431009 |
| 1,206 | Deriving Production Rules for Constraint Maintenance | 1990 | VLDB | 0.00013297347 |
| 1,579 | Constraint Checking with Partial Information | 1994 | PODS | 0.00011273105 |
| 3,558 | Ode as an Active Database: Constraints and Triggers | 1991 | VLDB | 6.9709415e-05 |
| 2,284 | Knowledge-based Integrity Constraint Validation | 1986 | VLDB | 9.1118342e-05 |
| 4,744 | Semantics and Expressiveness Issues in Active Databases | 1995 | PODS | 5.9487921e-05 |
| 2,049 | Compiling complex database transition triggers | 1989 | SIGMOD | 9.6888574e-05 |
| 1,889 | Promises and Realities of Active Database Systems | 1995 | VLDB | 0.00010192436 |
| 5,858 | Eliminating Costly Redundant Computations from SQL Trigger Executions | 1997 | SIGMOD | 5.296947e-05 |
| 3,140 | Integrating Triggers and Declarative Constraints in SQL Database Systems | 1996 | VLDB | 7.4912441e-05 |