The TSQL2 Temporal Query Language

Richard T. Snodgrass (Ed.): The TSQL2 Temporal Query Language. Kluwer 1995, ISBN 0-7923-9614-6

The TSQL2 Language Design Committee consisted of Richard T. Snodgrass(chair), Ilsoo Ahn, Gad Ariav, Don S. Batory, James Clifford, Curtis E. Dyreson, Ramez Elmasri, Fabio Grandi, Christian S. Jensen, Wolfgang Käfer, Nick Kline, Krishna G. Kulkarni, T. Y. Cliff Leung, Nikos A. Lorentzos, John F. Roddick, Arie Segev, Michael D. Soo and Suryanarayana M. Sripada

• Frontmatter.
  

Part I: Overview

• Richard T. Snodgrass, Henry Kucera:
  Rationale for a Temporal Extension to SQL. 3-18
  
• Richard T. Snodgrass:
  Introduction to TSQL2. 19-30
  
• Richard T. Snodgrass:
  TSQL2 Tutorial. 31-46
  
• Richard T. Snodgrass, Christian S. Jensen, Curtis E. Dyreson, Wolfgang Käfer, Nick Kline, John F. Roddick:
  A Second Example. 47-72
  

Part II: Language Design

• Curtis E. Dyreson, Richard T. Snodgrass:
  The Baseline Clock. 73-92
  
• Curtis E. Dyreson, Michael D. Soo, Richard T. Snodgrass:
  The Data Model for Time. 93-98
  
• Richard T. Snodgrass, Michael D. Soo:
  Supporting Multiple Calendars. 99-118
  
• Michael D. Soo, Richard T. Snodgrass:
  Temporal Data Types. 119-148
  
• Christian S. Jensen, Richard T. Snodgrass:
  The Surrogate Data Type. 149-152
  
• Christian S. Jensen, Richard T. Snodgrass, Michael D. Soo:
  The TSQL2 Data Model. 153-238
  
• Richard T. Snodgrass, Christian S. Jensen, Fabio Grandi:
  Schema Specification. 239-242
  
• Richard T. Snodgrass, Christian S. Jensen, Fabio Grandi:
  The From Clause. 243-248
  
• Suchen H. Hsu, Christian S. Jensen, Richard T. Snodgrass:
  Valid-Time Selection and Projection. 249-296
  
• T. Y. Cliff Leung, Christian S. Jensen, Richard T. Snodgrass:
  Modification. 297-302
  
• Christian S. Jensen, Richard T. Snodgrass, T. Y. Cliff Leung:
  Cursors. 303-308
  
• Richard T. Snodgrass:
  Event Tables. 309-316
  
• John F. Roddick, Richard T. Snodgrass:
  Transaction Time Support. 317-324
  
• Curtis E. Dyreson, Richard T. Snodgrass:
  Temporal Indeterminancy. 325-344
  
• Curtis E. Dyreson, Richard T. Snodgrass:
  Temporal Granularity. 345-382
  
• James Clifford, Curtis E. Dyreson, Richard T. Snodgrass, Tomás Isakowitz, Christian S. Jensen:
  ``Now''. 383-392
  
• Nick Kline, Richard T. Snodgrass, T. Y. Cliff Leung:
  Aggregates. 393-424
  
• John F. Roddick, Richard T. Snodgrass:
  Schema Versioning. 425-446
  
• Christian S. Jensen:
  Vacuuming. 447-460
  

Part III: Implementation Issues

• Michael D. Soo, Christian S. Jensen, Richard T. Snodgrass:
  An Architectural Framework. 461-470
  
• Curtis E. Dyreson, Richard T. Snodgrass:
  A Timestamp Representation. 471-496
  
• Michael D. Soo, Nick Kline, Richard T. Snodgrass:
  SQL-92 Compatibility Issues. 497-500
  
• Michael D. Soo, Christian S. Jensen, Richard T. Snodgrass:
  An Algebra for TSQL2. 501-544
  

Part IV: Language Specification

• Language Specification. 547-629
  

• References, Author Index, Syntax Index, Subject Index.