Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Developing Time-Oriented Database Applications in SQL (The Morgan Kaufmann Series in Data Management Systems) Paperback – July 26, 1999

4.5 out of 5 stars 11 customer reviews

See all formats and editions Hide other formats and editions
Price
New from Used from
Paperback
"Please retry"
$3,869.72 $31.14

2016 Book Awards
Browse award-winning titles. See all 2016 winners
click to open popover

Editorial Reviews

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

Review

"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
NO_CONTENT_IN_FEATURE

Image
Interested in the Audiobook Edition?
If you’re the author, publisher, or rights holder of this book, let ACX help you produce the audiobook.Learn more.

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Paperback: 544 pages
  • Publisher: Morgan Kaufmann (July 26, 1999)
  • Language: English
  • ISBN-10: 1558604367
  • ISBN-13: 978-1558604360
  • Product Dimensions: 9.2 x 7.3 x 1 inches
  • Shipping Weight: 2 pounds
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Best Sellers Rank: #662,775 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By David Beardsley on January 23, 2006
Format: Paperback
People seem to be selling used copies of this book for quite a bit ($125+) but you can get a PDF of the book for free from the author:

[...]

Thanks to the author for providing this resource!
Comment 36 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on November 10, 1999
Format: Paperback
Professor Snodgrass has effectively communicated temporal data to me with this top-notch book. I have been designing systems for 25+ years and, for me, this book ranks with Donald Knuth's, "Art of Programming: Fundamental Algorithms (first edition)" and Charles Petzold's "Programming Windows", for its impact, in particular on my thinking process in software development. Every system I review, every table I design, every object that I design be considered differently than before I read this book.
His analogies are "country", but important. It took three settings of an hour each on 10 pages until the concepts really sank in. I have seen these constructs in Data Warehouses, but now I see a future for these in transactional systems.
Every time based system will eventually incorporate these concepts (and new SQL tools) - In particular all accounting systems including banking, brokerage (especially portfolio management), tax accounting.
For example, right now we are working on a system to track and manage vendor problems in a "just in time" manufacturing environment. If our tables had been designed with these temporal concepts, we would be able to more effectively communicate trends to our management users.
Those people who are familiar with these concepts may find it boring, but for those of us learning, I say thank you!
Comment 23 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I've used this book while working as the lead data architect on several large database projects, and it's been a lifesaver. It brings rigor and discipline to a very difficult area for SQL (true relational) databases: handling, reporting on, and storing the changing [versions of] data over time.
The concepts are themselves quite difficult and challenging, and I would be loathe to even attempt to build a system tracking changing data over time without this book's priceless assistance.
Another reviewer, an instructor, didn't like the book: it is not a tutorial and may be hard to use, understand, or follow if you are not already working on a problem that this book can help you solve.
But if you are involved in creating (say) an insurance application that must handle retroactivity, or a financial system that must be able to re-create an earlier financial report and explain why today's version of Q2 is different from yesterday's, then you NEED this book.
Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
The one-of-a-kind book is a practical research on how the real world changes over time effect the viability of database design.
The author provides many solutions to real-life problems and (most important!) 'gotchas' of the these solutions. The examples are provided for many popular DBMSs(from MS Access to Oracle).
The reader benefits greatly from the superb organization of material, clear language and good illustrations.
The sidebar notes on history of time-measuring devices provide a nice break from the 'heavy-duty' stuff.
I bought my copy two month ago and it has already became a one of the best-thumbed books on my professional shelf.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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. For anybody involved in the design of databases with temporal functionality (i.e. involved in the design of real-life databases, period!!), it is a must read. I have been designing systems for over 20 years and first worked on temporal functionality back in the early nineties, hand-rolling our own temporal referential integrity. Great fun! I thought that I had a good grasp of the domain - well, I do, but in this book, Snodgrass has comprehensively categorised and organised the domain of temporal data into an accessible, practical, and complete set. He does so in a manner that is very readable using real-world examples. I wish I had come across it long ago. However, even though 12 years old, it is still highly relevant and will continue to be so. It has clarified my understanding and given me new perspectives on past projects as well as opening my eyes up to new possibilities. Top class all round.

One aspect to the business of temporal data that is not treated in this book (and wouldn't be treated here as the book stands) but is relevant is the interaction between the system and the user. Dealing with temporal data as a designer is a bit of a head-wrecker, pity the poor user! A book outlining best user interface practices for managing, presenting, visualising, expressing the sometimes convoluted concepts in plain domain specific language would be an excellent development to this excellent foundation.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
(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.g. sequenced GROUP BY, maintaining referential integrity during DELETEs). It was an eye-opener.

Do expect to spend a lot of time trying things out yourselves, and look out for small mistakes in the SQL code examples throughout.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse