Abstract
As the main interface for the interaction between user and temporal database, temporal query language determines temporal database’s functionality and its implementation details. Thus, the choice of query language is a decisive step for the design of a temporal database. Current theoretical results of temporal database include various types of temporal data models and query languages. Typical query languages include TempSQL, Tquel, TSQL2 and ATSQL2. The query language chosen by the processing component of the temporal data TempDB is the improved ATSQL2. To explain ATSQL2 language accurately, it is necessary to study its syntax and semantics. As ATSQL2 has its limitations, a detailed description of the improved ATSQL2 is proposed in this chapter.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Allen JF (1983) Maintaining knowledge about temporal intervals. Communications of the ACM 26(11): 832–843
Böhlen MH (1994) Managing temporal knowledge in deductive databases. Ph.D. dissertation, Switzerland: Departement Informatik, ETH Zurich
Böhlen MH, Jensen CS, Snodgrass RT (1995) Evaluating and enhancing the completeness of TSQL2. Technical Report TR 95-5, Computer Science Department, University of Arizona
Böhlen MH, Jensen CS, Snodgrass RT (1995) Evaluating the completeness of TSQL2. In: Clifford J, Tuzhilin A (eds) Recent Advances in Temporal Databases, pp 153–172
Böhlen MH, Marti R (1994) On the completeness of temporal database query languages. In: Proceedings of the First International Conference on Temporal Logic, pp 283–300
Date CJ (1989) A guide to the SQL standard. Addison-Wesley Publishing Company
Melton J, Simon AR (1993) Understanding the new SQL: a complete guide. Morgan Kaufmann Publishers
Pulfer D (1995) Optimierung von temporalen Queries. Master D dissertation, Switzerland: Institute for Information Systems, ETH Zurich
(1993) SQL: American National Standards Institute. ANSI X3H2-93-091/YOK-003, ISO-ANSI (WorkingDraft) Database Language SQL3
Snodgrass RT (1995) The TSQL2 temporal query language. Kluwer Academic Publishers, Norwell, MA
Snodgrass RT, Böhlen MH, Jensen CS, Steiner A (1996a) Adding valid time to SQL/Temporal. SQL/Temporal Change Proposal, ANSI X3H2-96-501r2, ISO/IEC JTC1/SC21/WG3 DBLMAD-146r2
Snodgrass RT, Böhlen MH, Jensen CS, Steiner A (1996b) Adding transaction time to SQL/Temporal. Change Proposal. ANSI X3H2-96-502r2, ISO/IEC JTC1/SC21/WG3 DBL-MAD-147r2
Steiner A (1998) A generalisation approach to temporal data models and their implementations. Ph.D. dissertation, Switzerland: Federal Institute of Technology
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Tsinghua University Press, Beijing and Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Guo, H., Tang, Y., Yang, X., Ye, X. (2010). Improvement and Extension to ATSQL2. In: Tang, Y., Ye, X., Tang, N. (eds) Temporal Information Processing Technology and Its Application. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-14959-7_12
Download citation
DOI: https://doi.org/10.1007/978-3-642-14959-7_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-14958-0
Online ISBN: 978-3-642-14959-7
eBook Packages: Computer ScienceComputer Science (R0)