About the authors
Abby Barry is a Platform and Technologies Solution Engineer with experience in database, data management, and analytics solutions. She has been at SAP for 3 years in this role.
Doug Hoover is a Platform and Technologies Principal Solution Engineer with decades of experience in database, real-time data movement, enterprise data warehouse, advanced analytics, and big data.
This is our first post in our new blog series about the new innovations in the most recent SAP HANA release. Interested in a topic? Let us know!
Product: SAP HANA 2.0 SPS04
Feature: Native Storage Extension (NSE)
With SAP HANA’s latest service pack update (SPS04) comes new innovations. In this blog post, I will be explaining Native Storage Extension (NSE), a new native option for SAP HANA customers for warm data tiering. With NSE, you will be able to reduce TCO by gaining storage capacity by storing data in pageable columnar tables. An sample of the SQL code used to administer data storage and a technical deep-dive video are also included below.
Reduce TCO by gaining storage capacity
Reduce your TCO by significantly expanding your data capacity without requiring an additional SAP HANA License.
Think of your mission critical sales data from the past few days. Process managers need this data available in real-time to make critical operational decisions. Once the business process has been completed, you still need access but not with the same response time required by operational business needs. Now with NSE, this older data can be stored in a lower cost tier while still managed as part of the SAP HANA database.
Store data in pageable columnar tables
SAP HANA stores data at rest in columnar tables in-memory. NSE extends this in-memory storage to support pageable columnar tables while maintaining efficient and fast accesses. This mechanism provides a significantly lower Total Cost of Ownership by expanding the capacity of the SAP HANA database. Although slower than SAP HANA columnar in-memory tables, NSE is still much faster and extremely more efficient than standard row-based databases. Therefore, a huge benefit is that NSE allows SAP HANA to store huge amounts of data very affordably, supporting both vertical and horizontal partitioning of columnar tables across memory and disk.
Administer data storage with SQL
/*To create a page loadable table*/ CREATE COLUMN TABLE T (C1 INT, C2 VARCHAR(10)) PAGE LOADABLE; /*To create a page loadable partition*/ CREATE COLUMN TABLE TP (C1 INT) PARTITION BY RANGE (C1) ((PARTITION 0 <= VALUES < 1000 PAGE LOADABLE, PARTITION 1000 <= VALUES < 2000 COLUMN LOADABLE, PARTITION OTHERS COLUMN LOADABLE)); /*To create a page loadable column*/ CREATE COLUMN TABLE TC (C1 INT, C2 VARCHAR(10) PAGE LOADABLE);
Check out this video to see a technical overview of NSE
To start using SAP HANA today
We are excited to roll out this native SAP HANA warm data tiering solution that boasts full SAP HANA functionality at a lower TCO for customers. Drop a question below if you want to learn more. Want to start using SAP HANA today? Check out SAP HANA Service homepage on the SAP Cloud Platform site and contact your SAP Account Executive!