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: HANA Data Modeling a Detailed Overview
- HANA Data Strategy: Data Ingestion including Real-Time Change Data Capture
- HANA Data Strategy: Data Ingestion – Virtualization
- HANA Data Strategy: HANA Data Tiering
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.
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.
Thanks, looking forward!
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
Nice Post! Thanks for sharing such an amazing article, really informative,it helps me a lot.
Very informative Superb