Compiling complex database transition triggers

Summary: Unified language for updates, queries, transition triggers; rule constructs cover state and transition constraints, general. Triggers compile into a mechanism; rules and updates compile independently, trigger changes avoid recompiling updates. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2505
Venue: SIGMOD
Year: 1989
Pagerank: 8.817902e-05
Overall Rank: 2,277 | 84.38%
DOI: 10.1145/67544.66947

Incoming Non-self Citations Over Time

Authors

1. Donald Cohen (Information Sciences Institute; University of Southern California)

BibTeX Citation

@inproceedings{cohen_sigmod89,
        title = {{Compiling complex database transition triggers}},
        author = {Cohen, Donald},
        series = {{SIGMOD} '89},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/67544.66947},
        url = {https://dl.acm.org/doi/10.1145/67544.66947},
        year = {1989}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
716	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.00014652696
971	ILOG: Declarative Creation and Manipulation of Object Identifiers	1990	VLDB	0.00012875736
1,590	Implementing Set-Oriented Production Rules as an Extension to Starburst	1991	VLDB	0.00010257581
2,820	On Maintaining Priorities in a Production Rule System	1991	VLDB	8.0911708e-05
3,130	Language Constructs for Programming Active Databases	1991	VLDB	7.7250012e-05
8,427	Integrity Maintenance in an Object-Oriented Database	1992	VLDB	5.4265283e-05
13,112	Effects of Database Size on Rule System Performance: Five Case Studies	1991	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 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
541	Efficient Monitoring of Database Assertions	1978	SIGMOD	0.00016860824
2,591	Knowledge-based Integrity Constraint Validation	1986	VLDB	8.366058e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,912	Unrolling Cycle to Decide Trigger Termination	1999	VLDB
2	1,726	A Transaction Language Complete for Database Update and Specification	1987	PODS
3	3,475	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB
4	3,528	Practical Applications of Triggers and Constraints: Successes and Lingering Issues	2000	VLDB
5	2,188	Promises and Realities of Active Database Systems	1995	VLDB
6	716	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD
7	597	Composite Event Specification in Active Databases: Model & Implementation	1992	VLDB
8	1,451	Event Specification in an Active Object-Oriented Database	1992	SIGMOD
9	5,762	Implementing High Level Active Rules on top of a Relational DBMS	1992	VLDB
10	6,136	Eliminating Costly Redundant Computations from SQL Trigger Executions	1997	SIGMOD