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.00014701559
Overall Rank
692 | 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
297 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.0002187415
730 Logical Modeling Of Temporal Data 1987 SIGMOD 0.00014371825
2,034 The Time Index: An Access Structure for Temporal Data 1990 VLDB 9.1378213e-05
2,357 Temporal Logic & Historical Databases 1991 VLDB 8.571376e-05
2,867 Temporal Data Management 1986 VLDB 7.9050856e-05
4,067 Event-Join Optimization in Temporal Relational Databases 1989 VLDB 6.8086897e-05
4,433 Historical Multi-Media Databases 1986 VLDB 6.5869097e-05
4,937 Temporal Modules: An Approach Toward Federated Temporal Databases 1993 SIGMOD 6.3338054e-05
5,523 Temporal Query Processing and Optimization in Multiprocessor Database Machines 1992 VLDB 6.0818572e-05
5,693 On The Expressive Power Of The Extended Relational Algebra For The Unnormalized Relational Model 1987 PODS 6.0176113e-05
6,462 A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T 1991 VLDB 5.760456e-05
8,146 Dealing with Temporal Schema Anomalies in History Databases 1987 VLDB 5.3739121e-05
9,543 Semantic Assumptions and Query Evaluation in Temporal Databases 1995 SIGMOD 5.151324e-05
10,132 Weak Temporal Relations 1986 PODS 5.0614501e-05
10,506 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 4.9605343e-05
13,432 A Uniform Approach to Processing Temporal Queries 1992 VLDB 4.9605343e-05
13,487 Meta-Functions and Contexts in an Object-Oriented Database Language 1988 SIGMOD 4.9605343e-05
13,499 Temporal Relationships in Databases 1988 VLDB 4.9605343e-05
13,522 Providing Time-Related Constraints for Conventional Database Systems 1987 VLDB 4.9605343e-05
13,529 Some Classes of Multilevel Relational Structures (Extended Abstract) 1986 PODS 4.9605343e-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.00075677079
140 Remarks on the Algebra of Non First Normal Form Relations 1982 PODS 0.00029239337
684 Designing DBMS Support for the Temporal Dimension 1984 SIGMOD 0.00014781093
849 The Semantic Data Model: A Modelling Mechanism for Data Base Applications 1978 SIGMOD 0.00013458102
1,011 Integration of Time Versions into a Relational Database System 1984 VLDB 0.00012495389
2,094 The Temporal Query Language TQuel 1984 PODS 9.0409588e-05
2,413 Modelling Information Preserving Databases: Consequences of the Concept of Time 1983 VLDB 8.4862727e-05
2,778 Improving Semantic Specification in a Relational Database 1979 SIGMOD 8.0093076e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 684 Designing DBMS Support for the Temporal Dimension 1984 SIGMOD
2 13,432 A Uniform Approach to Processing Temporal Queries 1992 VLDB
3 4,463 Handling Infinite Temporal Data 1990 PODS
4 5,422 Incomplete information in relational temporal databases 1992 VLDB
5 13,499 Temporal Relationships in Databases 1988 VLDB
6 6,069 Nested Historical Relations 1989 SIGMOD
7 3,067 A Temporal Relational Algebra as a Basis for Temporal Relational Completeness 1990 VLDB
8 3,382 A Generalized Model For A Relational Temporal Database 1988 SIGMOD
9 2,357 Temporal Logic & Historical Databases 1991 VLDB
10 5,763 Extending the Relational Algebra to Support Transaction Time 1987 SIGMOD