Developing Time-oriented Database Applications in SQL

Front Cover
Morgan Kaufmann Publishers, 2000 - Computers - 504 pages
1 Review
Whether you're a database designer, programmer, analyst, or manager, you've probably encountered some of the challenges-and experienced some of the frustrations-associated with time-varying data. Where do you turn to fix the problem and see that it doesn't happen again? In "Developing Time-Oriented Database Applications in SQL, a leading SQL researcher teaches you effective techniques for designing and building database applications that must integrate past and current data. Written to meet a pervasive, enduring need, this book will be indispensible if you happen to be part of the flurry of activity leading up to Y2K.

The enclosed CD-ROM contains all of the code fragments-implemented for Oracle8 Server, IBM DB2 Universal Database, Microsoft SQL Server, and other systems-and evaluation copies of the programs discussed in the book.
* Offers incisive advice on recording temporal data using SQL data types, defining appropriate integrity constraints, updating temporal tables, and querying temporal tables with interactive and embedded SQL.
* Provides case studies detailing real-world problems and solutions in areas such as event data, state-based data, partitioned data, and audit logs.
* Contains over 400 code fragments with detailed explanations.

From inside the book

What people are saying - Write a review

LibraryThing Review

User Review  - thepricefam - LibraryThing

Besides containing a wide-array of time-related trivia, this book contains a plethora of information in constructing temporal databases. Most of the book flew straight over my head, so it will take some time to soak in. Read full review

Contents

Introduction
1
3
25
Defining State Tables
111
Copyright

9 other sections not shown

Common terms and phrases

About the author (2000)

Snodgrass is professor of computer science at the University of Arizona.

Bibliographic information