SAP HANA Dynamic Tiering
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.
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 |