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: h9650b11740c41ee1
Venue: SIGMOD
Year: 1989
Pagerank: 8.5933699e-05
Overall Rank: 2,346 | 84.28%
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
739	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.0001430589
1,004	ILOG: Declarative Creation and Manipulation of Object Identifiers	1990	VLDB	0.00012557552
1,634	Implementing Set-Oriented Production Rules as an Extension to Starburst	1991	VLDB	0.00010001512
2,858	On Maintaining Priorities in a Production Rule System	1991	VLDB	7.9141449e-05
3,198	Language Constructs for Programming Active Databases	1991	VLDB	7.5282913e-05
8,629	Integrity Maintenance in an Object-Oriented Database	1992	VLDB	5.2847278e-05
13,449	Effects of Database Size on Rule System Performance: Five Case Studies	1991	VLDB	4.9605343e-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
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035589793
557	Efficient Monitoring of Database Assertions	1978	SIGMOD	0.0001646127
2,651	Knowledge-based Integrity Constraint Validation	1986	VLDB	8.1497183e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,249	Unrolling Cycle to Decide Trigger Termination	1999	VLDB
2	1,781	A Transaction Language Complete for Database Update and Specification	1987	PODS
3	3,527	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB
4	3,608	Practical Applications of Triggers and Constraints: Successes and Lingering Issues	2000	VLDB
5	2,236	Promises and Realities of Active Database Systems	1995	VLDB
6	739	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD
7	615	Composite Event Specification in Active Databases: Model & Implementation	1992	VLDB
8	1,494	Event Specification in an Active Object-Oriented Database	1992	SIGMOD
9	5,871	Implementing High Level Active Rules on top of a Relational DBMS	1992	VLDB
10	6,268	Eliminating Costly Redundant Computations from SQL Trigger Executions	1997	SIGMOD