15.00 - Warm, Hot, and Very Hot Data - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Warm, Hot, and Very Hot Data

Note: The distinction between warm, hot, and very hot data is somewhat conceptual and is only loosely parallel to the WARM and HOT categories of temperature‑based block‑level compression. Very Hot data is data that you or Teradata Virtual Storage determine should be added to the Very Hot cache or that is currently contained on Very Hot cylinders.

Warm and hot data typically constitute what is often called the operational data store. Quoting Fan and Pederson (2003), an operational data store “…is a collection of data in support of an organization's need for up-to-date, operational, integrated, collective information. [An operational data store…] is a purely operational construct to address the operational needs of a corporation.

Hot and warm data are both important in the extended lifetime of data, particularly with respect to multi-value compression (see “Compression Types Supported by Teradata Database” on page 695), as is cool data to a lesser degree.