The TSQL2 Temporal Query Language Book

	List of Figures
	List of Tables
	Preface
1	Rationale for a Temporal Extension to SQL	3
2	Introduction to TSQL2	19
3	TSQL2 Tutorial	33
4	A Second Example	49
5	The Baseline Clock	77
6	The Data Model for Time	97
7	Supporting Multiple Calendars	103
8	Temporal Data Types	123
9	The Surrogate Data Type	153
10	The TSQL2 Data Model	157
11	Schema Specification	241
12	The From Clause	245
13	Valid-Time Selection and Projection	251
14	Modification	299
15	Cursors	305
16	Event Tables	311
17	Transaction Time Support	319
18	Temporal Indeterminacy	327
19	Temporal Granularity	347
20	"Now"	385
21	Aggregates	395
22	Schema Versioning	427
23	Vacuuming	451
24	An Architectural Framework	465
25	A Timestamp Representation	475
26	SQL-92 Compatibility Issues	501
27	An Algebra for TSQL2	505
28	Language Syntax	549
29	Section 5 Lexical Elements	551
30	Section 6 Scalar Expressions	563
31	Section 7 Query Expressions	591
32	Section 8 Predicates	599
33	Section 10 Additional Common Elements	605
34	Section 11 Schema Definition and Manipulation	607
35	Section 12 Module	617
36	Section 13 Data Manipulation	621
37	Section 21 Information Schema and Definition Schema	629
38	Section 22 Status Codes	631
	References	633
	Author Index	651
	Syntax Index	657
	Subject Index	667