Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Date CJ, Darwen H, Lorentzos NA. Time and relational theory, temporal databases in the relational model and SQL. Morgan Kaufmann Publishers; 2013.
International Organization for Standardization (ISO). Database language SQL. Document ISO/IEC 9075:2011. 2011.
Jones S, Mason PS. Handling the time dimension in a database. In: Proceedings of the International Conference Data Bases; 1980. p. 65–83.
Kulkarni K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Rec. 2012;41(3):34–43.
Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.
Lorentzos NA, Johnson RG. TRA a model for a temporal relational algebra. In: Rolland C, Bodart F, Leonard M, editors. Temporal aspects in information systems. North-Holland; 1988. p. 203–15.
Lorentzos NA, Mitsopoulos YG. SQL extension for interval data. IEEE Trans Knowl Data Eng. 1997;9(3):480–99.
Navathe SB, Ahmed R. TSQL: a language interface for history databases. In: Rolland C, Bodart F, Leonard M, editors. Temporal aspects in information systems. North-Holland; 1988. p. 109–22.
Navathe SB, Ahmed R. A temporal relational model and a query language. Inf Sci Int J. 1989;47(2):147–75.
Sarda NL. Algebra and query language for a historical data model. Comput J. 1990;33(1):11–8.
Sarda NL. Extensions to SQL for historical databases. IEEE Trans Knowl Data Eng. 1990;2(2):220–30.
Snodgrass S. The temporal query language TQUEL. ACM Trans Database Syst. 1987;12(2): 247–98.
Tansel AU. Adding time dimension to relational model and extending relational algebra. Inf Syst. 1986;11(4):343–55.
Tansel AU. A historical query language. Inf Sci. 1991;53(1–2):101–33.
Tansel AU. Temporal relational data model. IEEE Trans Knowl Data Eng. 1997;9(3):464–79.
Tansel AU, Canan EA. Nested bitemporal relational algebra. In: Proceedings of the 21st International Symposium on Computer and Information Sciences; 2006. p. 622–33.
Tansel A, Clifford J, Gadia J, Segev A, Snodgrass R, editors. Temporal databases: theory, design and implementation. Benjamin/Cummings; 1993.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Lorentzos, N.A. (2018). Period-Stamped Temporal Models. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_266
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_266
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering