Skip to main content
SpringerLink
Log in
Book cover
  • Book
  • © 1995

The TSQL2 Temporal Query Language

Editors:

  1. Richard T. Snodgrass

    1. Department of Computer Science, University of Arizona, Tucson, USA

    View editor publications

    You can also search for this editor in PubMed   Google Scholar

Part of the book series: The Springer International Series in Engineering and Computer Science (SECS, volume 330)

Sections

Buy it now

eBook USD 259.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 329.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (38 chapters)

  1. Front Matter

    Pages i-xxvi
    PDF

  2. Overview

    1. Front Matter

      Pages 1-1
      PDF

    2. Rationale for a Temporal Extension to Sql

      • Richard T. Snodgrass, Henry Kucera
      Pages 3-18

    3. Introduction to TSQL2

      • Richard T. Snodgrass
      Pages 19-31

    4. TSQL2 Tutorial

      • Richard T. Snodgrass
      Pages 33-47

    5. A Second Example

      • Richard T. Snodgrass, Christian S. Jensen, Curtis E. Dyreson, Wolfgang Käfer, Nick Kline, John F. Roddick
      Pages 49-73

  3. Language Design

    1. Front Matter

      Pages 75-75
      PDF

    2. The Baseline Clock

      • Curtis E. Dyreson, Richard T. Snodgrass
      Pages 77-96

    3. The Data Model for Time

      • Curtis E. Dyreson, Michael D. Soo, Richard T. Snodgrass
      Pages 97-101

    4. Supporting Multiple Calendars

      • Richard T. Snodgrass, Michael D. Soo
      Pages 103-121

    5. Temporal Data Types

      • Michael D. Soo, Richard T. Snodgrass
      Pages 123-152

    6. The Surrogate Data Type

      • Christian S. Jensen, Richard T. Snodgrass
      Pages 153-156

    7. The TSQL2 Data Model

      • Christian S. Jensen, Richard T. Snodgrass, Michael D. Soo
      Pages 157-240

    8. Schema Specification

      • Richard T. Snodgrass, Christian S. Jensen, Fabio Grandi
      Pages 241-243

    9. The From Clause

      • Richard T. Snodgrass, Christian S. Jensen, Fabio Grandi
      Pages 245-249

    10. Valid-Time Selection and Projection

      • Suchen Hsu, Christian S. Jensen, Richard T. Snodgrass
      Pages 251-298

    11. Modification

      • T. Y. Cliff Leung, Christian S. Jensen, Richard T. Snodgrass
      Pages 299-303

    12. Cursors

      • Christian S. Jensen, Richard T. Snodgrass, T. Y. Cliff Leung
      Pages 305-309

    13. Event Tables

      • Richard T. Snodgrass
      Pages 311-318

    14. Transaction Time Support

      • John F. Roddick, Richard T. Snodgrass
      Pages 319-325
Back to top

About this book

Temporal databases have been an active research topic for at least fifteen years. During this time, several dozen temporal query languages have been proposed. Many within the temporal database research community perceived that the time had come to consolidate approaches to temporal data models and calculus­ based query languages, to achieve a consensus query language and associated data model upon which future research can be based. While there were many query language proposals, with a diversity of language and modeling constructs, common themes kept resurfacing. However, the community was quite frag­ mented, with each research project being based on a particular and different set of assumptions and approaches. Often these assumptions were not germane to the research per se, but were made simply because the research required a data model or query language with certain characteristics, with the partic­ ular one chosen rather arbitrarily. It would be better in such circumstances for research projects to choose the same language. Unfortunately, no existing language had attracted a following large enough to become the one of choice. In April, 1992 Richard Snodgrass circulated a white paper that proposed that a temporal extension to SQL be produced by the research community. Shortly thereafter, the temporal database community organized the "ARPA/NSF In­ ternational Workshop on an Infrastructure for Temporal Databases," which was held in Arlington, TX, in June, 1993.
Back to top

Keywords

Back to top

Editors and Affiliations

  • Department of Computer Science, University of Arizona, Tucson, USA

    Richard T. Snodgrass

Back to top

Bibliographic Information

Back to top

Publish with us

Policies and ethics

Back to top
Access via your institution

Buy it now

eBook USD 259.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 329.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Search

Navigation