Open Access Open Access  Restricted Access Subscription Access

In-memory Technique: High Performance Analytics with SAP HANA Track E-DATA Warehousing and Data Mining


Affiliations
1 City College, Bangalore, India
 

Increasingly sophisticated business decision models depend on extremely fast access and manipulation of massive data stores. Insight into business operations often demands data volumes that are beyond the capabilities of traditional disk-based systems to process them in real time, which can limit access to benefits such as Efficiency provided by the ability to respond in real-time to the changing needs of the business, Flexibility based on insight that accurately directs quick action and Empowerment of business users to make and act on smart decisions. This reality often causes a separation between ongoing business needs and the analytic applications that support them. The purpose of this research is to identify and avoid delays caused by the data replication and the lag time between data gathering and interpretation, which delays the ability to benefit from business information, thereby limiting its value. SAP HANA in-memory database is a hybrid in-memory database that combines rowbased, columnbased, and object-based database technology, optimized to exploit the parallel processing capabilities of current hardware in cloud environment [9]. The study shows how to Gain real-time business insights with near-zero latency.

Keywords

In-Memory Technique, BI, SAP High Performance Analytics Appliance (HANA), RDMBS, Cloud, High Availability.
User
Notifications
Font Size

  • Vishal Sikka, Juchang Lee, Michael Muehle, Norman May, Franz Faerber, Hasso Plattner, Jens Krueger, Martin Grund “High-Performance Transaction Processing in SAP HANA”.
  • Lalit Dole, Girish Talmale and Jayant Rajurkar “Analysis of SAP HANA High Achievability Competence” January 2014, pp. 141-146.
  • Philipp Grobe, Wolfgang Lehner and Norman May “Advanced Analytics with the SAP HANA Database”.
  • Franz Farber and Norman May and Wolfgang Lehner “The SAP HANA Database – An Architecture Overview”.
  • Dr. Berg, “Real HANA Performance Test B e n c h m a r k s ” 2013,http://sapinsider.wispubs.com/
  • Todd Muirhead, “Certified SAP BW-EML Benchmark on Virtual HANA” 2014.
  • “SAP Standard Application Benchmark R e s u l t s ” 2 0 1 3 a n d 2 0 1 4 , http://global.sap.com/
  • H. Plattner. A, “Common Database Approach for OLTP and OLAP Using an In-Memory Column Database”. In Proc. SIGMOD, pages 1-2, 2009.
  • SAP HANA Cloud Documentation, https://help.hana.ondemand.com/
  • TPC-H. http://www.tpc.org/tpch/, 2014.
  • “Quest Benchmark Factory,” Website, 2012, http://www.quest.com/benchmarkfactory/
  • IBM X6 enterprise servers, http://www03.ibm.com/systems/in/x/x6/
  • IBM Redbook: In-memory computing with SAP HANA on IBM eX5 Systems

Abstract Views: 436

PDF Views: 192




  • In-memory Technique: High Performance Analytics with SAP HANA Track E-DATA Warehousing and Data Mining

Abstract Views: 436  |  PDF Views: 192

Authors

Sunitha Watts
City College, Bangalore, India
Aliyas Shaik
City College, Bangalore, India

Abstract


Increasingly sophisticated business decision models depend on extremely fast access and manipulation of massive data stores. Insight into business operations often demands data volumes that are beyond the capabilities of traditional disk-based systems to process them in real time, which can limit access to benefits such as Efficiency provided by the ability to respond in real-time to the changing needs of the business, Flexibility based on insight that accurately directs quick action and Empowerment of business users to make and act on smart decisions. This reality often causes a separation between ongoing business needs and the analytic applications that support them. The purpose of this research is to identify and avoid delays caused by the data replication and the lag time between data gathering and interpretation, which delays the ability to benefit from business information, thereby limiting its value. SAP HANA in-memory database is a hybrid in-memory database that combines rowbased, columnbased, and object-based database technology, optimized to exploit the parallel processing capabilities of current hardware in cloud environment [9]. The study shows how to Gain real-time business insights with near-zero latency.

Keywords


In-Memory Technique, BI, SAP High Performance Analytics Appliance (HANA), RDMBS, Cloud, High Availability.

References