SAP HANA Dynamic Tiering: Official Tutorials & Resources

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

Summary matrix

Feature	Details
Highly scalable	Proven disk-based columnar store can scale up to handle 100TB of warm data.
Flexible deployment	SAP HANA dynamic tiering does not require SAP HANA certified hardware, enabling the use of lower cost commodity hardware. SAP HANA dynamic tiering also supports co-deployment with SAP HANA on a single host system.
High availability	SAP HANA dynamic tiering participates in the SAP HANA high availability architecture supporting the configuration of an active extended_storage_worker node and an extended_storage_standby node.
Backup & recovery	Support for full, differential and incremental backups for point in time recovery. Integrated into the BACKINT API to enable 3rd party tools.
System replication	Supports synchronous 2-tier system replication.
Integrated security	All connections are made through a SAP HANA worker node, ensuring that the same security model is applied to both the SAP HANA memory store and the SAP HANA dynamic tiering store.
High speed data loading	Data being loaded directly to tables or partitions in extended storage can be bulk loaded at speeds that match loading into SAP HANA in-memory storage.
Cross store query optimizer	SAP HANA optimizes queries across the in-memory and dynamic tiering engines delegating execution to the appropriate component. Both SQL and Calculation views are supported.
Management via SAP HANA Cockpit	The dynamic tiering process is managed from the SAP HANA Cockpit
Common modelling tools	Multistore and extended tables are created and queried using common HANA modelling tools including SAP HANA studio and SAP Web IDE for SAP HANA