Chapter 2. Hardware, Data Volume, and Maintaining Databases

A MAJOR FACTOR in data processing is that the hardware has changed radically in the last few years. Moore’s Law is a rule of thumb that computing speed doubles every 18 months; but the principle applies to more than just processor speeds. All hardware is faster and cheaper than it has ever been and it continues to get faster and cheaper. Because storing data is cheaper, the volume of data is increasing. The question for a database is how to keep up with the changes.

In an article entitled “A Conversation with Jim Gray” (Storage, Vol. 1, No. 4, June 2003), Dave Patterson began the interview with the question “What is the state of storage today [2003]?”

Jim Gray’s response was:

We have ...

Get Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL 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.