IN-MEMORY & EXTENDED STORAGE WITH ONE LOGICAL DB BUT DIFFERENT TIERS
SAP HANA WITH – DYNAMIC TIERING VS EXTERNAL STORAGE SYSTEMS
SAP Dynamic Tiering HANA | External Storage systems(Like Hadoop, Spark, Big Query) |
Dependent on HANA Disk capacity(additional storage can be purchased) | Unlimited disk capacity |
Lower TCO (70% cost reduction in Licenses) | Higher TCO |
Dynamic tiers in same HANA system | External additional systems required |
No additional 3rd party tools integration | Additional integration tools & Licenses |
Concurrent inserts from multiple connections on extended tables allowing multiple writes | No concurrent inserts |
All types of data manipulation are possible even on cold/warm data (Create, Read, Update, and Delete). | Write Once, Read only- Many. |
High speed data movement between In memory HANA tables & Extended tables. |
|
System Replication for Dynamic Tiering from HANA 2.0* |
|
QUICK LOOK ON HOW DOES DYNAMIC TIERING WORK WITH SAP BW ON HANA 
- BW requirements were the driving force behind extended storage-dynamic tiering
- BW uses dynamic tiering with object-based temperature assignment.
- In-Memory can be utilized in more efficient manner with proper staging in DT.
HOW DYNAMIC TIERING PLAYS PART IN BIG DATA ANALYTICS ?
SAP BIG DATA ANALYTICS WITH DYNAMIC TIERING VS EXTERNAL STORAGE 
FEW LIMITATIONS FOR REPORTING ON EXTENDED TABLES (HANA 1.0) OR MULTISTORE TABLES (HANA 2.0)
- SAP HANA advanced capabilities like text search and analytics, series data, and graph are not currently supported with extended tables, or on the dynamic tiering partitions of multistore tables.
- Extended tables are only allowed in Calculation Views. You cannot add extended table/multistore to Analytic or Attribute Views.
- Changing table in such a view to extended table invalidates the view.
- You cannot use extended tables or multistore tables in Core Data Services (CDS) views. In case, if you use an Application Function Library (AFL) function on data residing in dynamic tiering, the data is pulled into SAP HANA for processing in memory.
To be contd ..
- SAP HANA advanced capabilities like text search and analytics, series data, and graph are not currently supported with extended tables, or on the dynamic tiering partitions of multistore tables.
- Extended tables are only allowed in Calculation Views. You cannot add extended table/multistore to Analytic or Attribute Views.
- Changing table in such a view to extended table invalidates the view.
- You cannot use extended tables or multistore tables in Core Data Services (CDS) views. In case, if you use an Application Function Library (AFL) function on data residing in dynamic tiering, the data is pulled into SAP HANA for processing in memory.
To be contd ..
Let Tek Analytics Implement the solution for you. Please contact us @ [email protected]
NAVEEN MANNE @ Tek-Analytics
SAP BIG DATA & ADVANCED ANALYTICS|SAP HANA