Abstract
Computerised information systems tend to become more sophisticated and complicated. In many application domains, information systems must manage data that change over time, or data that reflect the use of temporal attributes. For these reasons the domain of temporal databases is an active research field. In this paper we present TGDB, a framework for developing temporal database systems that manage both valid and transaction time as well as any kind of user defined time. TGDB offers to the user a relational-like view of the tables and fields, but it is not based on the relational model. Instead it is based on the TGS graph system for time management. TGS combines a very good performance with temporal data management independent from application or domain. The query language of TGDB is an extension of SQL.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Ahn I. “Towards an Implementation of Database Management Systems with Temporal Support”, Proceedings of the 2nd International Conference on Data Engineering, IEEE, pp.374–381, 1986.
Ahn I., Snodgrass R. “Partitioned Storage for Temporal Databases”, Information Systems, Vol.13, No.4, pp.369–391, 1988.
Allen J.F. “Maintaining Knowledge about Temporal Intervals”, Communications of the ACM, Vol.26, No.11, pp.832–843, 1983.
Ariav G. “A Temporally Oriented Data Model”, ACM Transactions on Database Systems, Vol.11, No.4, pp.499–527, 1986.
Ariav G. “Design Requirements for Temporally Oriented Information Systems”, Proceedings of the IFIP Working Conference on Temporal Aspects in Information Systems, France, pp.3–16, May 1987.
Gunadhi H., Segev A. “Efficient Indexing Methods for Temporal Relations”, IEEE Trans. on Knowledge and Data Engineering, Vol.5, No.2, pp.496–509, June 1993.
Ioannidis E.V., Kokkotos S., Spyropoulos C.D. “A Temporal Framework for Managing Retroactive and Delayed Updates: An Application to the Payroll Information System of the Greek Public Sector”, European Journal of Information Systems, Vol.2, No.2, pp.149–154, Apr. 1993.
Ioannidis E.V., Spyropoulos C.D., Panayiotopoulos T., Skordalakis E. “TIMERx, a Kernel for Managing Temporal References on a RDBMS”, Working Paper, N.C.S.R. “Demokritos”.
Kokkotos S., Spyropoulos C.D. “TGS: A Kernel Graph System for Time Management”, Technical Report DEMO 90/6, N.C.S.R. “Demokritos”, June 1990.
Kokkotos S., Spyropoulos C.D. “RASS: A ReActive Scheduling System Based on the TGS Kernel”, Proceedings of the AIENG-90 Conference, Boston, MA, pp.523–533, July 1990.
Kokkotos S. “Independent Temporal Data Management for Information Systems”, Ph.D. Thesis, Dept. of Electrical Engineering and Computer Engineering, National Technical Univ. of Athens, 1992, (in greek).
Lorentzos N., Johnson R.G. “Extending Relational Algebra to Manipulate Temporal Data”, Information Systems,Vol.13, No.3, pp.289–296, 1988.
McKenzie E. “Bibliography: Temporal Databases”, ACM SIGMOD RECORD, Vol.15, No.4, pp.40–52, 1986.
McKenzie E., Snodgrass R, “Extending the Relational Algebra to Support Transaction Time”, Proceedings of the ACM SIGMOD International Conference on Management of Data, San Fransisco CA, pp.467–479, May 1987.
McKenzie E., Snodgrass R. “Supporting Valid Time in a Historical Relational Algebra: Proofs and Extensions, Technical Report TR 91-15, Dept. of Computer Science, Univ. of Arizona, 1991.
McKenzie E., Snodgrass R. “Evaluation of Relational Algebras Incorporating the Time Dimension in Databases”, ACM Computing Surveys, Vol.23, No.4, pp.501–543, Dec. 1991.
Navathe S.B., Ahmed R. “A Temporal Relational Model and a Query Language”, Information Science, Vol.49, pp.147–175, 1989.
Ola A., Ozsoyoglu G. “Incomplete Relational Database Models Based on Intervals”, IEEE Trans. on Knowledge and Data Engineering, Vol.5, No.2, pp.293–308, Apr. 1993.
Snodgrass R., Ahn I., “Temporal Databases”, IEEE Computer, Vol.19, No.9, pp.35–42, 1986.
Snodgrass R. “The Temporal Query Language TQuel”, ACM Transactions on Database Systems, Vol.12, No.2, pp.247–298, 1987.
Soo M.D. “Bibliography on Temporal Databases”, ACM SIGMOD RECORD, Vol.20, No.1, pp.14–23, Mar. 1991.
Spyropoulos C.D., Kokkotos S. “Interactive Fuzzy Scheduling Using the Time Graph System TGS”, Proceedings of the AAAI SIGMAN Workshop on Manufacturing Scheduling, IJCAI-89 Conference, Detroit IL, Aug. 1989.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kokkotos, S., Spyropoulos, C.D. (1994). A framework for developing temporal databases. In: Karagiannis, D. (eds) Database and Expert Systems Applications. DEXA 1994. Lecture Notes in Computer Science, vol 856. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58435-8_188
Download citation
DOI: https://doi.org/10.1007/3-540-58435-8_188
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58435-3
Online ISBN: 978-3-540-48796-8
eBook Packages: Springer Book Archive