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
h63d80bef52c80d67
Venue
SIGMOD
Year
1985
Pagerank
0.00014743297
Overall Rank
691 | 95.36%
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
291 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.00021951101
729 Logical Modeling Of Temporal Data 1987 SIGMOD 0.00014410979
2,149 The Time Index: An Access Structure for Temporal Data 1990 VLDB 8.9552337e-05
2,344 Temporal Logic & Historical Databases 1991 VLDB 8.603615e-05
2,859 Temporal Data Management 1986 VLDB 7.9338914e-05
4,063 Event-Join Optimization in Temporal Relational Databases 1989 VLDB 6.823605e-05
4,413 Historical Multi-Media Databases 1986 VLDB 6.6101893e-05
4,913 Temporal Modules: An Approach Toward Federated Temporal Databases 1993 SIGMOD 6.3577273e-05
5,538 Temporal Query Processing and Optimization in Multiprocessor Database Machines 1992 VLDB 6.0918672e-05
5,681 On The Expressive Power Of The Extended Relational Algebra For The Unnormalized Relational Model 1987 PODS 6.0401867e-05
6,448 A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T 1991 VLDB 5.7822982e-05
8,121 Dealing with Temporal Schema Anomalies in History Databases 1987 VLDB 5.3942942e-05
9,504 Semantic Assumptions and Query Evaluation in Temporal Databases 1995 SIGMOD 5.1708619e-05
10,094 Weak Temporal Relations 1986 PODS 5.0806471e-05
10,428 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 4.9793485e-05
13,385 A Uniform Approach to Processing Temporal Queries 1992 VLDB 4.9793485e-05
13,440 Meta-Functions and Contexts in an Object-Oriented Database Language 1988 SIGMOD 4.9793485e-05
13,452 Temporal Relationships in Databases 1988 VLDB 4.9793485e-05
13,475 Providing Time-Related Constraints for Conventional Database Systems 1987 VLDB 4.9793485e-05
13,482 Some Classes of Multilevel Relational Structures (Extended Abstract) 1986 PODS 4.9793485e-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.00075944947
140 Remarks on the Algebra of Non First Normal Form Relations 1982 PODS 0.00029346895
681 Designing DBMS Support for the Temporal Dimension 1984 SIGMOD 0.00014821572
847 The Semantic Data Model: A Modelling Mechanism for Data Base Applications 1978 SIGMOD 0.00013507676
1,010 Integration of Time Versions into a Relational Database System 1984 VLDB 0.00012539712
2,083 The Temporal Query Language TQuel 1984 PODS 9.0722247e-05
2,407 Modelling Information Preserving Databases: Consequences of the Concept of Time 1983 VLDB 8.5160078e-05
2,769 Improving Semantic Specification in a Relational Database 1979 SIGMOD 8.0387502e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 681 Designing DBMS Support for the Temporal Dimension 1984 SIGMOD
2 13,385 A Uniform Approach to Processing Temporal Queries 1992 VLDB
3 4,438 Handling Infinite Temporal Data 1990 PODS
4 5,400 Incomplete information in relational temporal databases 1992 VLDB
5 13,452 Temporal Relationships in Databases 1988 VLDB
6 6,054 Nested Historical Relations 1989 SIGMOD
7 3,054 A Temporal Relational Algebra as a Basis for Temporal Relational Completeness 1990 VLDB
8 3,381 A Generalized Model For A Relational Temporal Database 1988 SIGMOD
9 2,344 Temporal Logic & Historical Databases 1991 VLDB
10 5,757 Extending the Relational Algebra to Support Transaction Time 1987 SIGMOD