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

• SAP HANA Data Strategy: HANA Data Modeling a Detailed Overview
• HANA Data Strategy: Data Ingestion including Real-Time Change Data Capture
  • Access SAP ERP data from SAP HANA through SDI ABAP Adapter by Maxime Simon
• HANA Data Strategy: Data Ingestion – Virtualization
• HANA Data Strategy: HANA Data Tiering
  • Store More with SPS04 – NSE BLOG