Developing Time-Oriented Database Applications in SQL (Morgan Kaufmann Series in Data Management Systems)

Developing Time-Oriented Database Applications in SQL (Morgan Kaufmann Series in Data Management Systems)

by Richard T. Snodgrass
4/5
(14 votes)

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.

uk"I highly recommend this book to anyone interested in temporal data-either designing and building databases that record information over time, or just understanding the concepts that underlie representing temporal information.

an excellent job of organizing and summarizing this important area.

"From the foreword by Jim Gray, Microsoft Research"a long time in the making, not only because the subject matter can seem overwhelmingly complex if not presented carefully, but also because of the great number of examples that Snodgrass has taken from real application systems and translated into standard SQL.

"From the foreword by Jim Melton, Oracle Corporation.

Format
504 pages, Paperback
First published
July 1999
Publishers
Morgan Kaufmann Publishers
Subjects
Database software·Databases·Data structures·Sql·Sql ·Information storage·Retrieval·Real-time data processing·Computers·Computers·Languages·Programming·Computer books and software·Programming languages
Language
English

This is my first Amazon review. Most of the time I wouldn't even bother thinking about writing a review but this book is different.

(This review refers to the on-line version of the book, as distributed by the author) Hardly an easy read and quite long, but very much worth the trouble to read end-to-end. I actually wished it were longer, since some aspects are bypassed entirely (e.

I enjoyed reading this book more than most technical books, because the author maintains a very pleasant style and adds interesting anecdotes. It isn't presented as a theoretical book, but presents the basic issues with case studies and a review of SQL3 proposed extensions.

Books

Similar books