Use SAP HANA-Optimized InfoCubes and DSOs for Faster Data Access
- by Prakash Darji, Vice President and General Manager, Data Warehousing Solutions and SAP HANA Platform, SAP
- Daniel Rutschmann, Director, Data Warehousing Solutions and SAP HANA Platform
- May 11, 2012
Gain an understanding of how to use the new InfoProvider types introduced with SAP NetWeaver BW on SAP HANA, such as SAP HANA-optimized InfoCubes and DataStore Objects. Learn when and how to use them to take full advantage of the in-memory computing capabilities within SAP NetWeaver BW on SAP HANA. Doing so enables your organization to dramatically shorten the time it takes to load data and provide required information for reporting.
SAP NetWeaver BW on SAP HANA introduces new InfoProvider types that are optimized for the use of in-memory computing capabilities. As companies deploy SAP NetWeaver BW on top of SAP HANA, there are significant improvements in the area of data modeling that enable them to implement a much leaner Layered, Scalable Architecture. This approach results in a shorter time-to-market of developments of new applications and data models with SAP NetWeaver BW. Additionally, data loading cycles are shortened.
Traditionally business systems are deployed in a three-tier, client-server architecture in which the end users access applications on their desktop clients. With SAP NetWeaver BW, the data for these applications resides within various database management systems. The heavy workload of extracting, harmonizing, integrating, and consolidating data — thus transforming it into valuable information — occurs in the application tier. With SAP NetWeaver BW-based business solutions, the application layer typically consists of several ABAP application servers.
The database layer usually becomes a bottleneck as there is a lot of data traffic between the application and database layers caused by frequent data reads from the database into the application layer. With SAP HANA, this dramatically changes.
With the technology and software behind SAP HANA, application logic can be executed in the in-memory database layer with incredible speed, decreasing the need of transferring large data sets back and forth between the database and application servers. Multi-core CPUs combined with massively parallel processing (MPP), in-memory, and columnar constructs enable data-intense operations to occur close to where the data is stored. For example, by moving DataStore Object (DSO) activation runtime from the application layer to the database layer, the processing time is improved on average by a factor of 10 to 15.
Figure 1 outlines the move of application runtime to the in-memory database layer.
Would you like to see this full item?