Skip to Content
Technical Articles
Author's profile photo Douglas Hoover

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

 

 

 

 

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Douglas Hoover
      Douglas Hoover
      Blog Post Author

      There is more detail to come on this topic, especially the detail around DT and Extension Nodes vs NSE and even more detail on NSE.

      Author's profile photo Anjana Ghatak
      Anjana Ghatak

      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.

      Author's profile photo Andrei Dorfman
      Andrei Dorfman

      Thanks, looking forward!

      Author's profile photo Mel Calucin
      Mel Calucin

      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

      Author's profile photo eronita carol
      eronita carol

      Nice Post! Thanks for sharing such an amazing article, really informative,it helps me a lot.

      Author's profile photo Vivek Chaudhary
      Vivek Chaudhary

      Very informative Superb