2.4. Cheaper Secondary and Tertiary Storage

Bulk storage is also cheaper and faster today. Traditionally, secondary storage meant disk drives that required moving a physical read/write head to locate data. When you connected to the database, the system connected to these drives and got ready to move data in and out of primary storage to and from them.

In 2007, the traditional disk drive is being challenged by solid-state memory. When the right price point is hit, there will be little speed difference between primary and secondary data.

Tertiary or archival storage is the slowest storage on a system, and it is usually off-line. That means the user has to deliberately “mount” or “dismount” the media to get to the data. This is for data that is ...

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.