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.
Preview
Unable to display preview. Download preview PDF.
References
Adiba, M., Quang, N.B., Historical Multi-Media Databases, Proceedings of the International Conference on Very Large Data Bases (VLDB), 1986, pp. 63–70.
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.
Ariav, G., Beller, A., Morgan, H., A Temporal Data Model, Technical Report, New York University, December, 1984.
Ariav, G., A Temporally Oriented Data Model, ACM Transactions on Database Systems, 11, 4(Dec. 1986), pp. 499–527.
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.
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.
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.
Gadia, S.K., Toward a Multihomogeneous Model for a Temporal Database, Proceedings of the International Conference on Data Engineering, 1986, pp. 390–397.
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.
Gunadhi H., Segev A., Physical Design of Temporal Databases, Lawrence Berkeley Lab Technical Report LBL-24578, 1988.
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.
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.
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.
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.
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.
Rotem, D., Segev, A., Physical Organization of Temporal Data, Proceedings of the Third International Conference on Data Engineering, pp. 547–553. February, 1987.
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.
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.
Shoshani, A., Kawagoe, K., Temporal Data Management, Proceedings of the International Conference on Very Large Databases, August 1986, pp. 79–88.
Smith, J. M., and Smith, D. C. P., Database Abstractions: Aggregation and Generalization, ACM TODS 2, 2, June 1977.
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.
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.
Snodgrass, R., The Temporal Query Language TQuel ACM Transactions on Database Systems, 12, 2, June 1987, pp. 247–298.
Studer, R., Modeling Time Aspects of Information Systems, Proceedings of the International Conference on Data Engineering, 1986, pp. 364–373.
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.
Author information
Authors and Affiliations
Editor information
Rights 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