DBScholar

Back to papers

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
2340
Venue
SIGMOD
Year
1985
Pagerank
0.00015072586
Overall Rank
676 | 95.37%
DOI
10.1145/318898.318922

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{clifford_sigmod85,
        title = {{On An Algebra For Historical Relational Databases. Two Views}},
        author = {Clifford, James and Tansel, Abdullah Uz},
        series = {{SIGMOD} '85},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/318898.318922},
        url = {https://dl.acm.org/doi/10.1145/318898.318922},
        year = {1985}
}

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank Citing Paper Year Venue Pagerank
283 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.00022377907
709 Logical Modeling Of Temporal Data 1987 SIGMOD 0.00014726781
2,115 The Time Index: An Access Structure for Temporal Data 1990 VLDB 9.1449719e-05
2,304 Temporal Logic & Historical Databases 1991 VLDB 8.7769303e-05
2,796 Temporal Data Management 1986 VLDB 8.1136567e-05
3,977 Event-Join Optimization in Temporal Relational Databases 1989 VLDB 6.9776413e-05
4,324 Historical Multi-Media Databases 1986 VLDB 6.7606936e-05
4,797 Temporal Modules: An Approach Toward Federated Temporal Databases 1993 SIGMOD 6.5025868e-05
5,402 Temporal Query Processing and Optimization in Multiprocessor Database Machines 1992 VLDB 6.2310833e-05
5,569 On The Expressive Power Of The Extended Relational Algebra For The Unnormalized Relational Model 1987 PODS 6.1702169e-05
6,321 A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T 1991 VLDB 5.9149483e-05
7,953 Dealing with Temporal Schema Anomalies in History Databases 1987 VLDB 5.5181056e-05
9,325 Semantic Assumptions and Query Evaluation in Temporal Databases 1995 SIGMOD 5.289545e-05
9,907 Weak Temporal Relations 1986 PODS 5.1972596e-05
10,212 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 5.093636e-05
13,095 A Uniform Approach to Processing Temporal Queries 1992 VLDB 5.093636e-05
13,150 Meta-Functions and Contexts in an Object-Oriented Database Language 1988 SIGMOD 5.093636e-05
13,162 Temporal Relationships in Databases 1988 VLDB 5.093636e-05
13,185 Providing Time-Related Constraints for Conventional Database Systems 1987 VLDB 5.093636e-05
13,192 Some Classes of Multilevel Relational Structures (Extended Abstract) 1986 PODS 5.093636e-05
Previous Page 1 / 1 Next

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
10 Extending the Data Base Relational Model to Capture More Meaning 1979 SIGMOD 0.0007727299
140 Remarks on the Algebra of Non First Normal Form Relations 1982 PODS 0.00029686538
672 Designing DBMS Support for the Temporal Dimension 1984 SIGMOD 0.00015143745
824 The Semantic Data Model: A Modelling Mechanism for Data Base Applications 1978 SIGMOD 0.00013791986
988 Integration of Time Versions into a Relational Database System 1984 VLDB 0.00012809318
2,037 The Temporal Query Language TQuel 1984 PODS 9.2777184e-05
2,353 Modelling Information Preserving Databases: Consequences of the Concept of Time 1983 VLDB 8.7080724e-05
2,712 Improving Semantic Specification in a Relational Database 1979 SIGMOD 8.2127746e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 672 Designing DBMS Support for the Temporal Dimension 1984 SIGMOD
2 13,095 A Uniform Approach to Processing Temporal Queries 1992 VLDB
3 4,348 Handling Infinite Temporal Data 1990 PODS
4 5,276 Incomplete information in relational temporal databases 1992 VLDB
5 13,162 Temporal Relationships in Databases 1988 VLDB
6 5,929 Nested Historical Relations 1989 SIGMOD
7 2,999 A Temporal Relational Algebra as a Basis for Temporal Relational Completeness 1990 VLDB
8 3,329 A Generalized Model For A Relational Temporal Database 1988 SIGMOD
9 2,304 Temporal Logic & Historical Databases 1991 VLDB
10 5,632 Extending the Relational Algebra to Support Transaction Time 1987 SIGMOD