Skip to Content
Technical Articles

HANA Data Strategy: HANA Data Tiering

This is part of the HANA Data Strategy series of BLOGS

https://blogs.sap.com/2019/10/14/sap-hana-data-strategy/

Business Value

  • Greatly increase HANA data volume while significantly lowering TCO.
  • Allow customers to do things they never thought possible before.
  • Allow customers to EASILY use HANA advance platform on SAP and non-SAP datasets in real-time.
  • Easily analyze many datasets and very huge datasets faster and easier and less expensively than anyone ever thought possible.
  • Significantly lower time to develop and deliver solutions (TTD) due to supporting simpler columnar data models leveraging horizontal and vertical partitioning across data tiers delivering a much lower TCO solution.

 

2 Minute Overview

 

HANA Data Tiering Whiteboard

10 Minute Video:

https://sapvideoa35699dc5.hana.ondemand.com/?entry_id=0_dgt93d74

 

HANA Data Tiers

Default: Columnar in-memory storage

  • Incredibly fast and easy
  • Very low TTD supports simpler easier data models

 

HANA on-disk: Columnar on-disk tightly coupled storage

  • Very very fast and easy
  • Slower than in-memory but 10s-100s times faster than traditional databases
  • Very low TTD supports simpler easier data models
  • 5x HANA total storage
  • Tightly coupled with in-memory storage supporting hot/warm horizontal and vertical partitioning
  • Lower cost
  • Single security and governance model

 

HANA Relational Data Lake: Columnar on-disk loosely coupled storage

  • Very very fast and easy
  • Slower than in-memory but 10s-100s times faster than traditional databases
  • Very low TTD supports simpler easier data models
  • Designed for 10TBs to 10PBs data
  • Extremely low cost
  • Single security and governance model

 

HANA Data Tiering Technology Details

 

Best Practices Technology Overview

This is the HANA Cloud architecture using the current HANA technologies for each storage tier.

 

NSE Overview

https://blogs.sap.com/2019/06/19/store-more-with-sps04/

 

SAP HANA Cockpit NSE Reports

https://video.sap.com/media/t/1_yuu0zq5s

 

HANA Relational Data Lake

*Future content: HANA Relational Data Lake Workshop Demo.

 

 

Compared with other HANA Technologies

 

*Future content: detailed analysis and comparison.

 

SAP HANA Data Strategy BLOGs Index

 

SAP HANA Data Strategy

 

 

 

 

4 Comments
You must be Logged on to comment or reply to a post.
    • Thank you for this informative article.

      We have been targeting the cold data in our system by using DLM to move it to IQ. However, due to several technical issues with DLM, the strategy has not worked in totality. Any further tool apart from DLM that can help this purpose?

      Our scenario is that we have tables being replicated from SAP Business Suite on HANA into a separate HANA DB and Information views being built on top of such replicated tables. We have been trying to archive the data from these replicated table into IQ using DLM.

  • Douglas,

    Thanks for this very informative blog.

    I met you at SAP TechEd 2019.   We discussed being able to load data from HANA to IQ.   I can’t remember what you said about this so can you refresh my memory?

    What is the fastest way to load data from HANA to IQ?   I want to load the whole BW schema from HANA into IQ as fast as possible.

    Thanks.

    Regards,

    Mel Calucin