SAP HANA Dynamic Tiering

Get Started

Official SAP HANA Dynamic Tiering tutorials and resources

Dynamic tiering is a native data tiering solution available in the SAP HANA platform that provides 'hot' and 'warm' data management in a single physical database and even within a single partitioned table. Here we provide official resources to learn about this feature.

New to SAP HANA dynamic tiering?

SAP HANA dynamic tiering is a technology enabler for application driven data aging that allows you to utilize lower cost disk storage for historical data within a single SAP HANA database, or even a single multistore table.

Multistore tables

A multistore table is a SAP HANA partitioned column table with some partitions residing in memory, and some on disk. By managing tiered data in a single physical table, multistore tables simplify the development of SAP HANA applications by eliminating the need to code against separate tables for hot data versus warm data.

Integrated system administration

SAP HANA dynamic tiering participates in SAP HANA backup and recovery, high availability and system replication. Tight integration of the SAP HANA platform simplifies the design and implementation of standard system administration tasks of SAP HANA systems using SAP HANA dynamic tiering compared to using an external data storage option such as Hadoop.

Data lifecycle management

Rule based data lifecycle management is assisted by the DLM tool within the SAP HANA data warehousing foundation. Developers can use the DLM tool to configured automated movement of aged data from in-memory column store table-to-disk based extended tables.

Under the hood: SAP HANA dynamic tiering

SAP HANA dynamic tiering provides an integrated disk-based columnar data store as part of an SAP HANA system. Developers can use SAP HANA dynamic tiering to implement a tiered data management system entirely within the SAP HANA platform, without requiring the costly implementation, integration or management of an external data warehouse or data lake.

Summary matrix

Feature

Details

Highly scalable

Proven disk-based columnar store can scale up to handle 100TB of warm data.