Menu

SAP HANA DYNAMIC TIERING PART-2

SAP HANA DYNAMIC TIERING –FUTURE DEFACTO STANDARD SAP IN-HOUSE DATA AGING SOLUTION – Part 2  

Please refer to Part 1 - http://www.tek-analytics.com/bloginner.php?title=SAP-HANA-DYNAMIC-TIERING-PART-1

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 @ info@tek-analytics.com


           NAVEEN MANNE @ Tek-Analytics
SAP BIG DATA & ADVANCED ANALYTICS|SAP HANA