SAP's HANA database: Big performance for big data

Yesterday, Sybase's parent company, SAP, made a shocking claim that demolishes the conventional wisdom in the enterprise software industry. The claim: SAP is a database company. Not just any database company, but the database company for Big Data.

I know, I know. SAP is an enterprise resource planning (ERP) and business applications company. Its software runs on databases like those from Sybase and other companies. That's true. But the fact is, SAP is also database company.

Don't believe me? Well, in addition to having the products in its Sybase arsenal, SAP makes the fastest, most robust database available today: HANA. HANA's in-memory, massively parallel processing architecture makes it ideally suited for the era of Big Data. And I mean really Big Data.

In a recent independent benchmark HANA raced through a 100TB test database with 100 billion records. First, HANA achieved a 20x data compression level, which was remarkable. More impressive, though, was that with no caching, indexing, or materializing of the query results, the query responses were a mere 300 to 500 milliseconds. Compare this to some Oracle documentation that has claimed it was "lightning fast" at processing 100 million records in one second. HANA, then, can run 1,000 times more data in less than one-half the time than Oracle.

Beyond benchmarks, in the real world of Wall Street, one HANA application is using Sybase CEP (Complex Event Processing) to feed more than 2.1 million updates per second into the database. In a retail environment in Japan, one customer achieved 400,000 times performance improvement over its previous database environment. Adobe uses HANA to analyze customer data in real time and T-Mobile runs three HANA databases to analyze and reduce customer churn. It's stories like these that make HANA the fastest growing product in SAP history.

HANA portends to change not just perceptions about SAP as a database company, but real lives. Imagine, if you will, a cancer patient sitting in a doctor's office having a sample taken to analyze her genome. With those test results, medical professionals can prepare a targeted, personally designed treatment program for the patient. The problem is that today those test results take at least one month to complete. With HANA, the potential is that the doctor will get those results during the patient's initial office visit and can begin the treatment immediately.

HANA dramatically changes the database industry landscape. Now, according to Gartner, SAP has "put extraordinary competitive pressure on the megavendors, including IBM, Microsoft and Oracle" to follow its lead. However, they are a long, long way behind the new database technology leader.

Big Data is fast becoming SAP's best friend because it cries out for a database like HANA. And with Big Data on everyone's lips these days they'll soon be talking about SAP as the database company for our Big Data era. And it won't be shocking news to anyone.

Related reading:

Invent new possibilities with HANA, SAP's game-changing in-memory software

SAP Sybase IQ Database 15.4 provides advanced analytic techniques to unlock critical business insights from Big Data

SAP Sybase Adaptive Server Enterprise is a high-performance RDBMS for mission-critical, data-intensive environments. It ensures highest operational efficiency and throughput on a broad range of platforms.

SAP SQL Anywhere is a comprehensive suite of solutions that provides data management, synchronization and data exchange technologies that enable the rapid development and deployment of database-powered applications in remote and mobile environments

Overview of SAP database technologies
Top 10 Hot Internet of Things Startups
Join the discussion
Be the first to comment on this article. Our Commenting Policies