Integrating Triggers and Declarative Constraints in SQL Database Systems
Summary: Integrates triggers with declarative constraint evaluation in SQL DBMS, enabling procedural logic while preserving set semantics for constraints. Implemented in DB2, it achieves SQL92 compatibility and is proposed as the SQL3 standard model. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Roberta Cochrane
- 2. Hamid Pirahesh
- 3. Nelson Mattos
Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,224 | Practical Applications of Triggers and Constraints: Successes and Lingering Issues | 2000 | VLDB | 7.3496543e-05 |
| 5,849 | Eliminating Costly Redundant Computations from SQL Trigger Executions | 1997 | SIGMOD | 5.3018732e-05 |
| 9,410 | Leveraging Application Data Constraints to Optimize Database-Backed Web Applications | 2023 | VLDB | 4.3441378e-05 |
| 12,212 | Business Policy Modeling and Enforcement in Databases | 2011 | VLDB | 4.1945683e-05 |
| 12,596 | Returning Modified Rows – SELECT Statements with Side Effects | 2004 | VLDB | 4.1945683e-05 |
| 12,759 | Referential Actions as Logical Rules | 1997 | PODS | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 133 | On Rules, Procedures, Caching And Views In Data Base Systems | 1990 | SIGMOD | 0.00042757638 |
| 462 | Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS | 1991 | VLDB | 0.00022481092 |
| 1,218 | Deriving Production Rules for Constraint Maintenance | 1990 | VLDB | 0.00013226899 |
| 1,518 | Implementing Set-Oriented Production Rules as an Extension to Starburst | 1991 | VLDB | 0.00011566842 |
| 1,890 | Promises and Realities of Active Database Systems | 1995 | VLDB | 0.00010199924 |
| 2,148 | On Maintaining Priorities in a Production Rule System | 1991 | VLDB | 9.4295586e-05 |
| 2,557 | Making Deductive Database a Practical Technology: a step forward | 1990 | SIGMOD | 8.5462449e-05 |
| 5,148 | Commit_LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems | 1990 | VLDB | 5.6631051e-05 |
| 7,147 | Safe Referential Integrity Structures In Relational Databases | 1991 | VLDB | 4.81755e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,813 | Temporal Conditions and Integrity Constraints in Active Database Systems | 1995 | SIGMOD | 6.735525e-05 |
| 12,337 | Declarative Management in Microsoft SQL Server | 2009 | VLDB | 4.1945683e-05 |
| 1,890 | Promises and Realities of Active Database Systems | 1995 | VLDB | 0.00010199924 |
| 8,332 | Triggered Real-Time Databases with Consistency Constraints | 1990 | VLDB | 4.5435639e-05 |
| 14,066 | An Overview of the Emerging Third-Generation SQL Standard | 1995 | SIGMOD | - |
| 4,747 | Semantics and Expressiveness Issues in Active Databases | 1995 | PODS | 5.9545121e-05 |
| 5,816 | Implementing High Level Active Rules on top of a Relational DBMS | 1992 | VLDB | 5.3161831e-05 |
| 2,075 | Compiling complex database transition triggers | 1989 | SIGMOD | 9.6076188e-05 |
| 5,849 | Eliminating Costly Redundant Computations from SQL Trigger Executions | 1997 | SIGMOD | 5.3018732e-05 |
| 3,224 | Practical Applications of Triggers and Constraints: Successes and Lingering Issues | 2000 | VLDB | 7.3496543e-05 |