Description: I Overview.- 1 Rationale for a Temporal Extension to SQL.- 2 Introduction to TSQL2.- 3 TSQL2 Tutorial.- 4 A Second Example.- II Language Design.- 5 The Baseline Clock.- 6 The Data Model for Time.- 7 Supporting Multiple Calendars.- 8 Temporal Data Types.- 9 The Surrogate Data Type.- 10 The TSQL2 Data Model.- 11 Schema Specification.- 12 The From Clause.- 13 Valid-Time Selection and Projection.- 14 Modification.- 15 Cursors.- 16 Event Tables.- 17 Transaction Time Support.- 18 Temporal Indeterminacy.- 19 Temporal Granularity.- 20 "Now".- 21 Aggregates.- 22 Schema Versioning.- 23 Vacuuming.- III Implementation Issues.- 24 An Architectural Framework.- 25 A Timestamp Representation.- 26 SQL-92 Compatibility Issues.- 27 An Algebra for TSQL2.- IV Language Specification.- 28 Language Syntax.- 29 Section 5 Lexical Elements.- 30 Section 6 Scalar Expressions.- 31 Section 7 Query Expressions.- 32 Section 8 Predicates.- 33 Section 10 Additional Common Elements.- 34 Section 11 Schema Definition and Manipulation.- 35 Section 12 Module.- 36 Section 13 Data Manipulation.- 37 Section 21 Information Schema and Definition Schema.- 38 Section 22 Status Codes.- References.- Author Index.- Syntax Index.

Please Wait