Abstract
This research takes the view that the modelling of temporal data is a fundamental step towards the solution of capturing semantics of time. The problems inherent in the modelling of time are not unique to database processing. The representation of temporal knowledge and temporal reasoning arises in a wide range of other disciplines. In this paper an account is given of a technique for modelling the semantics of temporal data and its associated normalization method. It discusses the techniques of processing temporal data by employing a Time Sequence (TS) data model. It shows a number of different strategies which are used to classify different data properties of temporal data, and it goes on to develop the model of temporal data and addresses issues of temporal data application design by introducing the concept of temporal data normalisation.
Similar content being viewed by others
References
Kim J, Yoo H, Lee Y. Implementation of a temporal query language with abstract time. InProceeding of the International Computer Sumposium, 1988, pp. 64–70.
Mckenzie E, Snodgrass R. Schema evolution and the relational algebra.Information Systems, 1990, 15(2): 207–232.
Date C J. Correspondence.ACM SIGMOD Record, 1990, 19(1): 41–42.
Snodgrass R. Temporal databases: Status and research directions.ACM SIGMOD Record, 1990, 19(4): 83–89.
Segev A, Shoshani A. Logical modelling of temporal data. InProceedings of the ACM SIGMOD Annual Conference on Management of Data, San Francisco, CA, May 1987, pp. 454–466.
Shoshani A, Kawagoe K. Temporal data management. InVLDB, Kyoto, Japan, August 1986, pp. 79–88.
Sun Y, Stockman A G, Deen S M. Processing temporal data in relational database. InPRoceedings of the 3rd Int'l Conf. on Data and Knowledge Systems for Manufacturing and Engineering, Lyon, France, March 17–20, 1992, pp. 237–246.
Sun Y, Stockman A G. A user-defined integrated temporal environment in relational database. InProceedings of the 3rd Int'l Conf. for Young Computer Scientitists, Beijing, China, July 1993, pp. 5.31–5.34.
Sun Y. Extending RDBMS to support temporal data. InProceedings of the 1994 IEEE International Workshop on Information Technology, Toulouse, France, February 10–12, 1994, pp. 351–370.
Author information
Authors and Affiliations
Corresponding author
Additional information
Supported by a research associateship (Jan. 1990–Jan. 1993) from Staffordshire University, UK.
Sun Yuan received his Ph.D. degree in computer science from Staffordshire University, UK, in 1993, and his M.S. degree in computer science from Keele University, UK.
At present, he is a Lecturer at the School of Computing, Information Systems and Mathematics. His research interests are database systems and its applications. His principal activities for the past five years have been in temporal databases, where he has studied the temporal semantics, temporal modelling and the design/implementation of temporal databases. He also is the Co-ordinator for the Centre of Information System and Office Studies.
Rights and permissions
About this article
Cite this article
Sun, Y. The modelling of temporal data in the relational database environment. J. of Comput. Sci. & Technol. 10, 163–174 (1995). https://doi.org/10.1007/BF02948425
Received:
Revised:
Issue Date:
DOI: https://doi.org/10.1007/BF02948425