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.6255214e-05
Overall Rank: 2,333 | 84.32%
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
737	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.00014359198
1,003	ILOG: Declarative Creation and Manipulation of Object Identifiers	1990	VLDB	0.00012597028
1,627	Implementing Set-Oriented Production Rules as an Extension to Starburst	1991	VLDB	0.00010038961
2,848	On Maintaining Priorities in a Production Rule System	1991	VLDB	7.9429561e-05
3,185	Language Constructs for Programming Active Databases	1991	VLDB	7.556677e-05
8,604	Integrity Maintenance in an Object-Oriented Database	1992	VLDB	5.3047716e-05
13,402	Effects of Database Size on Rule System Performance: Five Case Studies	1991	VLDB	4.9793485e-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.00035719146
554	Efficient Monitoring of Database Assertions	1978	SIGMOD	0.00016521437
2,640	Knowledge-based Integrity Constraint Validation	1986	VLDB	8.1805168e-05

Semantically Similar Papers

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