Skip to main content
SpringerLink
Log in

The representation of a temporal data model in the relational environment

  • Invited Lectures
  • Chapter
  • First Online:
Statistical and Scientific Database Management (SSDBM 1988)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 339))

Abstract

In previous work, we introduced a data model and a query language for temporal data. The model was designed independently of any existing data model rather than an extension of one. This approach provided an insight into the special requirements for handling temporal data. In this paper, we discuss the implications of supporting such a model in the relational database environment. We show that the concept of a temporal relation needs to be introduced, and define a temporal normal form for it. We discuss several options for the representation of our model's constructs in the relational context, and explain why we chose a particular representation. We also suggest the concept of a temporal relation family as a virtual view to treat multiple temporal relations together.

An Invited Paper to the 4th International Conference on Statistical and Scientific Database Management

This research was supported by the U.S. Department of Energy Applied Mathematics Sciences Research Program of the Office of Energy Research under contract DE-AC03-76SF00098.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Adiba, M., Quang, N.B., Historical Multi-Media Databases, Proceedings of the International Conference on Very Large Data Bases (VLDB), 1986, pp. 63–70.

    Google Scholar 

  2. Ahn I., Towards An Implementation of Database Management Systems with Temporal Support, Proceedings of the Third International Conference on Data Engineering, pp. 374–381. February, 1986.

    Google Scholar 

  3. Ariav, G., Beller, A., Morgan, H., A Temporal Data Model, Technical Report, New York University, December, 1984.

    Google Scholar 

  4. Ariav, G., A Temporally Oriented Data Model, ACM Transactions on Database Systems, 11, 4(Dec. 1986), pp. 499–527.

    Google Scholar 

  5. Bolour, A., Anderson, T.L., Dekeyser, L.J., Wong, H.K.T., The Role of Time in Information Processing: A Survey, ACM-SIGMOD Record, 12, 3, 1982, pp. 27–50.

    Google Scholar 

  6. Clifford, J., Tansel, A., On an Algebra for Historical Relational Databases: Two Views, Proceedings of the ACM SIGMOD International Conference on Management of Data, May 1985, pp. 247–265.

    Google Scholar 

  7. Clifford, J., Croker, A., The Historical Relational Data Model (HRDM) and Algebra Based on Life Spans, Proceedings of the Third International Conference on Data Engineering, pp. 528–537. February, 1987.

    Google Scholar 

  8. Gadia, S.K., Toward a Multihomogeneous Model for a Temporal Database, Proceedings of the International Conference on Data Engineering, 1986, pp. 390–397.

    Google Scholar 

  9. Gadia, S.K., Yeung C-S., A Generalized Model for A Relational Temporal Database, Proceedings of the ACM SIGMOD International Conference on Management of Data, June 1988, pp. 251–259. 1986, pp. 390–397.

    Google Scholar 

  10. Gunadhi H., Segev A., Physical Design of Temporal Databases, Lawrence Berkeley Lab Technical Report LBL-24578, 1988.

    Google Scholar 

  11. Klopproge, M.R., TERM: An Approach to Include the Time Dimension in the Entity-Relationship Model, Proceedings of the Second International Conference on E-R Approach, 1981, pp. 477–512.

    Google Scholar 

  12. Lum, V., Dadam, P., Erbe, R., Guenauer, J., Pistor, P., Walch, G., Werner, H., Woodfill, J., Designing Dbms Support for the Temporal Dimension, Proceedings of the ACM SIGMOD International Conference on Management of Data, June 1984, pp. 115–130. March, 1986.

    Google Scholar 

  13. McKenzie, E., Snodgrass R., Extending the Relational Algebra to Support Transaction Time, Proceedings of the ACM SIGMOD International Conference on Management of Data, May 1987, pp. 467–478.

    Google Scholar 

  14. Navathe, S.B., Ahmed, R., A Temporal Relational Model and a Query Language, UF-CIS Tech. Report TR-85-16, Univ of Florida, April 1986.

    Google Scholar 

  15. Navathe, S.B., Ahmed, R., TSQL-A Language Interface for History Data Bases, Proceedings of Temporal Aspects of Information Systems, North-Holland, May 1987, pp. 113–128.

    Google Scholar 

  16. Rotem, D., Segev, A., Physical Organization of Temporal Data, Proceedings of the Third International Conference on Data Engineering, pp. 547–553. February, 1987.

    Google Scholar 

  17. Segev, A., Shoshani, A., Logical Modeling of Temporal Databases, Proceedings of the ACM SIGMOD International Conference on Management of Data, May 1987, pp. 454–466.

    Google Scholar 

  18. Segev, A., Shoshani, A., Modeling Temporal Semantics, in Temporal Aspects in Information Systems, Edited by C. Rolland, F. Bodart, and M. Leonard, North-Holland, 1988, pp. 47–58.

    Google Scholar 

  19. Shoshani, A., Kawagoe, K., Temporal Data Management, Proceedings of the International Conference on Very Large Databases, August 1986, pp. 79–88.

    Google Scholar 

  20. Smith, J. M., and Smith, D. C. P., Database Abstractions: Aggregation and Generalization, ACM TODS 2, 2, June 1977.

    Google Scholar 

  21. Snodgrass, R., The Temporal Query Language TQuel, Proceedings of the Third ACM SIGMOD Symposium on Principles of Database Systems (PODS), Waterloo, Canada, April 1984, pp. 204–213.

    Google Scholar 

  22. Snodgrass, R., Ahn, I., A Taxonomy of Time in Databases, Proceedings of the ACM SIGMOD International Conference on Management of Data, May 1985, pp. 236–246.

    Google Scholar 

  23. Snodgrass, R., The Temporal Query Language TQuel ACM Transactions on Database Systems, 12, 2, June 1987, pp. 247–298.

    Google Scholar 

  24. Studer, R., Modeling Time Aspects of Information Systems, Proceedings of the International Conference on Data Engineering, 1986, pp. 364–373.

    Google Scholar 

  25. Tansel, A.U., Adding Time Dimension to Relational Model and Extending Relational Algebra, Information Systems, 11, 4 (1986), pp. 343–355. ACM Transactions on Database Systems, 12, 2, June 1987, pp. 247–298.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. School of Business Administration and Computer Science Research Dept, Lawrence Berkeley Lab, The University of California, 94720, Berkeley, California

    Arie Segev

  2. Computer Science Research Dept. Lawrence Berkeley Laboratory, University of California, 94720, Berkeley, California

    Arie Shoshani

Authors
  1. Arie Segev
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Arie Shoshani
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Maurizio Rafanelli John C. Klensin Per Svensson

Rights and permissions

Reprints and permissions

Copyright information

© 1989 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Segev, A., Shoshani, A. (1989). The representation of a temporal data model in the relational environment. In: Rafanelli, M., Klensin, J.C., Svensson, P. (eds) Statistical and Scientific Database Management. SSDBM 1988. Lecture Notes in Computer Science, vol 339. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0027504

Download citation

  • DOI: https://doi.org/10.1007/BFb0027504

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-50575-4

  • Online ISBN: 978-3-540-46045-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation