Developing Time-oriented Database Applications in SQL

Front Cover
Morgan Kaufmann Publishers, 2000 - Computers - 504 pages
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


Defining State Tables

9 other sections not shown

Common terms and phrases

About the author (2000)

Richard Snodgrass has been artist in residence at the Helene Wurlitzer Foundation in Taos, New Mexico, and at LightWork, University of Syracuse. He is also the recipient of a fellowship from the Pennsylvania Council on the Arts. His photographs are included in the permanent collection of the Oakland Museum of Art and in private collections and galleries nationwide. His books include the critically acclaimed novel There s Something in the Back Yard and the photographic commemoration of the Flight 93 Temporary Memorial, An Uncommon Field. Selections of Kitchen Things originally appeared in TABLE magazine, where he is a regular contributor. He lives in Pittsburgh, Pennsylvania, with his wife, Marty, and two indomitable female tuxedo cats, raised from feral kittens, named Frankie and Becca. For more information, go to

Bibliographic information