Extending the Relational Algebra to Support Transaction Time

Summary: Extends relational algebra with transaction-time to form a temporal algebra for historical valid-time. Denotational semantics formalize extension, preserving relational properties; derived state remains ethereal, for display or storage, not materialized. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h95fdbfa1a924b91a
Venue: SIGMOD
Year: 1987
Pagerank: 6.0053627e-05
Overall Rank: 5,757 | 61.30%
DOI: 10.1145/38713.38761

Incoming Non-self Citations Over Time

Authors

1. Edwin McKenzie (University of North Carolina)
2. Richard Snodgrass (University of North Carolina)

BibTeX Citation

@inproceedings{mckenzie_sigmod87,
        title = {{Extending the Relational Algebra to Support Transaction Time}},
        author = {McKenzie, Edwin and Snodgrass, Richard},
        series = {{SIGMOD} '87},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/38713.38761},
        url = {https://dl.acm.org/doi/10.1145/38713.38761},
        year = {1987}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,381	A Generalized Model For A Relational Temporal Database	1988	SIGMOD	7.3563641e-05
3,857	Multi-Version Range Concurrency Control in Deuteronomy	2015	VLDB	6.9690685e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
34	The Design Of Postgres	1986	SIGMOD	0.00049142315
339	A Taxonomy of Time in Databases	1985	SIGMOD	0.00020570509
535	Optimizing the Performance of a Relational Algebra Database Interface	1975	SIGMOD	0.00016789841
1,767	A Transaction Language Complete for Database Update and Specification	1987	PODS	9.6939822e-05
5,082	Transactions And Integrity Constraints	1985	PODS	6.2847136e-05
6,214	Dynamic Constraints And Database Evolution	1983	PODS	5.8479403e-05
7,766	Deciding Properties of Transactional Schemas	1986	PODS	5.4559822e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,961	Relations with Relation Names as Arguments: Algebra and Calculus	1992	PODS
2	13,452	Temporal Relationships in Databases	1988	VLDB
3	3,223	Temporal versus First-Order Logic to Query Temporal Databases	1996	PODS
4	729	Logical Modeling Of Temporal Data	1987	SIGMOD
5	7,337	Typed Query Languages for Databases Containing Queries	1998	PODS
6	13,453	A logical framework for temporal deductive databases	1988	VLDB
7	3,381	A Generalized Model For A Relational Temporal Database	1988	SIGMOD
8	3,054	A Temporal Relational Algebra as a Basis for Temporal Relational Completeness	1990	VLDB
9	691	On An Algebra For Historical Relational Databases. Two Views	1985	SIGMOD
10	2,344	Temporal Logic & Historical Databases	1991	VLDB