Chapter 10. Working with Temporal Data

It's probably fair to assert that time is a central component of every possible database of any interest to anyone. Imagining a database that lacks a time component is tantamount to imagining life without time passing; it simply doesn't make sense. Without a time axis, it is impossible to describe the number of purchases made last month, the average temperature of the warehouse during the night in July, or the maximum duration that callers were required to hold the line when calling in for technical support.

Although utterly important to our data, few developers commit to really thinking in depth about the intricacies required to process temporal data successfully. Unfortunately, working with time-based data ...

Get Expert SQL Server 2005 Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.