文档介绍：Developing Time-Oriented Database Applications in SQL
by Richard T. Snodgrass ISBN: 1558604367
Morgan Kaufmann Publishers © 2000, 504 pages
An enjoyable plunge into the how-to of time and data, with
real-world situations and code.
Table of Contents ments
Back Cover
Synopsis by a Rohan
What's true today may not be tomorrow -- and data may only be useful if it
comes from a period with specific parameters. If you're wrestling with time-
related monsters in DBMS, this book will help you understand them, and if
you're trying to tame those beasts with SQL, this book is a quick whip and
chair to chase them into their cages. For example, if you want to define a
period, you'll see that, while SQL3 supports periods, SQL-92 doesn't, and
you'll learn to use various pairs of instants instead.
Good, friendly writing, real-world situations, and plenty of code examples
make it fun to explore valid time versus transaction time, sequenced and non-
sequenced queries, sequenced updates, instants, intervals, now, and much
more. While Developing Time-Oriented Database Applications in SQL may
not make you Master of Time, it will probably make you a happier developer
during those minutes, hours, and days you're bringing temporal concepts to
data with SQL.
Table of Contents
Developing Time-Oriented Database Applications in SQL - 3
Foreword - 5
Foreword
Preface
Chapter 1 - Introduction - 9
Chapter 2 - Fundamental Concepts - 15
Chapter 3 - Instants and Intervals - 25
Chapter 4 - Periods - 73
Chapter 5 - Defining State Tables - 90
Chapter 6 - Querying State Tables - 120
Chapter 7 - Modifying State Tables - 152
Chapter 8 - Retaining a Tracking Log - 193
Chapter 9 - Transaction-Time State Tables - 223
Chapter 10 - Bitemporal Tables - 245
Chapter 11 - Temporal Database Design - 313
- 2 -
Chapter 12 - Language Directions - 365
Chapter 13 - Prospects - 435
Glossary - 4