Show TOC

Multi-Temperature Data ManagementLocate this document in the navigation structure

Due to information lifecycle management, customers often apply multi-temperature strategies, whereby data is classified by access frequency as either hot, warm or cold. Depending on this classification and data usage, this data is stored in different memory areas.

A multi-temperature memory strategy may be required for different reasons, for example:

  • Storage of historical data
  • Clickstream logs for multiple years of Web data and detailed machine logs
  • Guidelines for saving company data, such as the need to save all data for at least seven years due to legal reasons

In addition to frequently accessed active data, large BW systems also contain a large volume of data that is only accessed rarely. The data is either never or rarely needed in Data Warehouse processes or for analysis. The main challenge of implementing a multi-temperature memory strategy is to seamlessly integrate the warm and cold memory areas and to make these areas invisible to the outside, in order to ensure that all required functions are applied to this data. SAP offers you various solutions, which help to reduce TCO thanks to optimized SAP HANA main memory resource management.

The following illustration provides an overview of multi-temperature data classification and the SAP solutions for the various data categories: