BookMooch logo
 
home browse about join login
Richard T. Snodgrass : Developing Time-Oriented Database Applications in SQL (The Morgan Kaufmann Series in Data Management Systems)
?



Author: Richard T. Snodgrass
Title: Developing Time-Oriented Database Applications in SQL (The Morgan Kaufmann Series in Data Management Systems)
Moochable copies: No copies available
Topics:
>
Published in: English
Binding: Paperback
Pages: 544
Date: 1999-07-26
ISBN: 1558604367
Publisher: Morgan Kaufmann
Weight: 2.05 pounds
Size: 7.7 x 9.4 x 1.1 inches
Amazon prices:
$28.60used
$2,701.30new
Description: Product Description

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.


Amazon.com Review
What is everywhere but occupies no space; can be measured but not seen or touched; can be spent, wasted, or killed, but not destroyed or changed? The simple answer is time, and the relationship between the fourth dimension and data is the foundation for Developing Time-Oriented Database Applications in SQL, a fascinating book by Richard T. Snodgrass.

Anyone who has ever attempted to create or modify a database containing temporal data will appreciate the complexity of the task. Snodgrass's book aims to simplify it by first helping the reader fully understand the concepts involved before covering the SQL code needed to carry out the work. The book is punctuated with interesting information about the measurement of time through the ages, plus illustrative examples of where disaster has occurred following the misuse of time-specific data, and it comes with a free CD-ROM containing example code.

Make no mistake, this book is by no means an easy read. It's complex and very wordy, and non-programmers may get lost in the SQL quite quickly. This aside, it's an informative, well-written attempt to explain a complicated concept. --Steve Russell, amazon.co.uk

URL: http://bookmooch.com/1558604367
large book cover

WISHLIST ADD >

SAVE FOR LATER >

AMAZON >

OTHER WEB SITES >

RELATED EDITIONS >

RECOMMEND >

REFRESH DATA >