Overview of Sap Hana: In-Memory Computing Technology and ITS Applications
Srikantarao S1, Radhika K R2
1Srikantarao S, Information Science, BMSCE, Bangalore, India.
2Dr. Radhika K R, Information Science, BMSCE, Bangalore, India.
Manuscript received on May 22, 2014. | Revised Manuscript received on June 04, 2014. | Manuscript published on June 30, 2014. | PP: 136-139  | Volume-3, Issue-5, June 2014.  | Retrieval Number:  E3155063514/2013©BEIESP

Open Access | Ethics and Policies | Cite
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)

Abstract: Traditional database management systems are designed for optimizing performance on hardware with constrained main memory. Disk I,O was the main bottleneck. The focus was on optimizing disk access, where by minimizing the number of disk pages to be read into main memory during processing. The SAP HANA database is designed from the ground up around the idea that memory is available in abundance. Instead of optimizing I,O hard disk access, SAP HANA optimizes memory access between the CPU cache and main memory. SAP HANA is a massively parallel (distributed) data management system that runs fully in main memory, allowing for row- and column based storage options, and supporting built-in multitenancy.
Keywords: High-Performance Analytic Appliance (HANA), Structured query language (SQL), multidimensional expression (MDX), Online transaction processing (OTLP), Online analytical processing (OLAP).