Historically, database systems were designed to perform well on computer systems with limited RAM. As a consequence, slow disk I/O was the main bottleneck in data throughput. The architecture of those systems was designed with a focus on optimizing disk access e.g. by minimizing the number of disk block (or pages) to be read into main memory when processing a query. Today‘s applications execute many data intense operations in the application layer, which leads to latency.
With the explosion of data all over the world (15 Petabytes of new information is created every day and expected to reach 450 billion of B2B transactions per day by 2020) & the way Information Technology is getting used by enterprise users as well as individuals (thanks to mobile phone revolution) , there is an acute need for extreme performance, low latency (response time) which in turn has led the focus on ‘In-Memory Database Platforms’.
SAP’s razor-sharp focus on in-memory database technology is paying off. SAP HANA is an in-memory,
column-oriented, relational database management system (RDBMS) that’s designed to support
transactions and complex query processing on the same data set. (Incidentally, HANA stands for High Performance Analytic Appliance. Later on, SAP is not seen keen on providing this expansion & is happy calling it just HANA, just like it did away with the expansion of SAP long ago)
SAP HANA is a full transactional, ACID (Atomicity, Consistency, Isolation, Durability) compliant relational database, designed to cost-effectively run transactions and analytics on a single copy of data, with maximum performance.
What makes SAP HANA sizzle?
- Real Time Analytics –
Thanks to in-memory architecture of SAP HANA, we can do OLTP (On Line Transaction Processing) & OLAP (On Line Analytical Processing) at ease, enabling operational analytics. SAP HANA provides on-the-fly analysis so you can make real-time decisions. SAP HANA permits OLTP & OLAP workloads on the same platform by storing data in high-speed memory, organizing it in columns, partitioning and distributing it among multiple servers. This delivers faster queries that aggregate data more efficiently yet avoids costly full-table scans and single column indexes. There is paradigm shift for developers in HANA, since it allows all the data intensive logic down in the database as SQL, SQL script & HANA views, thereby ensuring the best application performance.
- Massive Speed
SAP tested the scan speed of an SAP HANA database across a variety of Intel CPU processors. These tests achieved results of 3.19 billion symbol scans per second per core. The early use cases with SAP HANA address a conventional pain point by accelerating analytics, and hence insights, on massive volumes of detailed data. Hence, end users can not only get answers faster (e.g., CO-PA reports that used to take hours can now run within seconds) without disruption, but also are now empowered to ask any question without requiring additional investment of IT’s time or resources to pre-define queries, pre-aggregate data into tables or cubes, or to generate indexes and materialized views.
- Radical Efficiency
By porting the data from a classic database to SAP HANA, eliminating unnecessary index and aggregate tables, and enabling operational reporting directly within SAP HANA, the data footprint was reduced by a factor of 37 in a test conducted and on an average 7-8 I at customer environments. With the increase in duplicate records increases the compression, reduced hardware cost and maintenance