The evolution of EDW framework based on In-memory computing technology: a field study of SAP BW on HANA
Abstract
The framework design of Enterprise Data Warehouse (EDW) system is one of the most important and complex tasks in building a robust and scalable data warehouse system at enterprise level. Benefit from the constantly decline in prices of memory, in-memory computing has become an applicable solution for many EDW systems. This paper first introduced the basic concepts of in-memory computing based on SAP High-Performance Analytic Appliance (HANA), a new platform based on in-memory databases (IMDB). Then the paper discussed the new generation of SAP data warehouse solution-SAP Business Warehouse (BW) on HANA and focused on the framework changes from Layered Scalable Architecture (LSA) to Layered Scalable Architecture based on SAP HANA (LSA++). Further, a field study of the evolution of EDW framework in L company was conducted and a case study of L company’s mixed EDW modelling scenario was analyzed in detail. The next generation production of SAPBW/4HANA was also referred at the end of the paper.
Keywords: Enterprise Data Warehouse; OLAP; In-memory computing; SAP; SAP BW; SAP HANA; LSA; LSA++