On An Algebra For Historical Relational Databases. Two Views

Summary: Proposes a relational algebra for historical data by timestamping attributes, not tuples, to support temporal views. Two non-1NF proposals: Clifford's time-to-value domains and Tansel's time-interval-to-value domains, unifying history in a single algebra. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2278
Venue: SIGMOD
Year: 1985
Pagerank: 0.00019786623
Overall Rank: 580 | 95.97%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. James Clifford
2. Abdullah Uz Tansel

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
187	Object and File Management in the EXODUS Extensible Database System	1986	VLDB	0.00036020812
614	Logical Modeling Of Temporal Data	1987	SIGMOD	0.00019177247
1,583	Temporal Logic & Historical Databases	1991	VLDB	0.00011259345
2,265	The Time Index: An Access Structure For Temporal Data	1990	VLDB	9.154915e-05
2,845	Temporal Data Management	1986	VLDB	8.024003e-05
3,746	Historical Multi-Media Databases	1986	VLDB	6.7924249e-05
3,998	Event-Join Optimization in Temporal Relational Databases	1989	VLDB	6.5472662e-05
4,327	Temporal Modules: An Approach Toward Federated Temporal Databases	1993	SIGMOD	6.2873894e-05
5,132	Temporal Query Processing and Optimization in Multiprocessor Database Machines	1992	VLDB	5.6740462e-05
5,238	On The Expressive Power Of The Extended Relational Algebra For The Unnormalized Relational Model	1987	PODS	5.6109061e-05
6,258	A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T	1991	VLDB	5.1357897e-05
7,299	Dealing with Temporal Schema Anomalies in History Databases	1987	VLDB	4.7701967e-05
9,166	Semantic Assumptions and Query Evaluation in Temporal Databases	1995	SIGMOD	4.3849295e-05
9,539	Weak Temporal Relations	1986	PODS	4.3265281e-05
12,901	A Uniform Approach to Processing Temporal Queries	1992	VLDB	4.1945683e-05
12,955	Meta-Functions and Contexts in an Object-Oriented Database Language	1988	SIGMOD	4.1945683e-05
12,966	Temporal Relationships in Databases	1988	VLDB	4.1945683e-05
12,987	Providing Time-Related Constraints For Conventional Database Systems.	1987	VLDB	4.1945683e-05
12,994	Some Classes of Multilevel Relational Structures (Extended Abstract)	1986	PODS	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
8	Extending the Data Base Relational Model to Capture More Meaning	1979	SIGMOD	0.0015385917
97	Remarks on the Algebra of Non First Normal Form Relations	1982	PODS	0.0005080702
348	The Semantic Data Model: A Modelling Mechanism for Data Base Applications	1978	SIGMOD	0.00026443996
504	Designing DBMS Support for the Temporal Dimension	1984	SIGMOD	0.0002151017
740	Integration of Time Versions into a Relational Database System	1984	VLDB	0.00017373475
1,225	Improving Semantic Specification in a Relational Database	1979	SIGMOD	0.00013190484
1,671	Modelling Information Preserving Databases: Consequences of the Concept of Time	1983	VLDB	0.00010951944
1,752	The Temporal Query Language TQuel	1984	PODS	0.00010679936

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
504	Designing DBMS Support for the Temporal Dimension	1984	SIGMOD	0.0002151017
12,901	A Uniform Approach to Processing Temporal Queries	1992	VLDB	4.1945683e-05
3,136	Handling Infinite Temporal Data	1990	PODS	7.4913222e-05
4,669	Incomplete information in relational temporal databases	1992	VLDB	6.0109659e-05
12,966	Temporal Relationships in Databases	1988	VLDB	4.1945683e-05
5,316	Nested Historical Relations	1989	SIGMOD	5.5720889e-05
1,996	A Temporal Relational Algebra as a Basis for Temporal Relational Completeness	1990	VLDB	9.8377097e-05
3,460	A Generalized Model For A Relational Temporal Database	1988	SIGMOD	7.07128e-05
1,583	Temporal Logic & Historical Databases	1991	VLDB	0.00011259345
5,138	Extending the Relational Algebra to Support Transaction Time	1987	SIGMOD	5.6694679e-05