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.

 

HANA Data Tiering Whiteboard

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.

 

 

2 Comments
You must be Logged on to comment or reply to a post.
  • 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