Skip the navigation

SAP's HANA will speed real-time data analytics

High-Performance Analytic Appliance's in-memory technology significantly boosts analytics performance, analysts say

December 1, 2010 07:02 PM ET

Computerworld - SAP's High-Performance Analytic Appliance, or HANA, which started shipping on Wednesday, should give its customers a much faster, more flexible way to analyze large volumes of data in real-time, analysts said.

Much of the performance gains come from HANA's use of an in-memory computing technology which allows data to be processed in a system's RAM as opposed to reading it off I/O disks. The in-memory approach enables much faster data processing and should allow companies to run far more sophisticated data analytics applications compared to conventional relational databases.

"Any enterprise that is a user of large data sets for data analytics," will find HANA interesting said Frank Scavo, manging partner of the IT consulting firm Strativa. "HANA represents a large improvement not only in processing speed but in flexibility and cost of data analytics."

HANA's ability to let large data sets be manipulated in memory will enable enterprises to run more ad hoc queries against business data, and reduce the need for pre-define cubes and queries, he said.

Companies will be able to take a large dataset and decide what questions they want to run against it, in real time. "It adds a lot of flexibility to the whole process of data analysis," Scavo said.

In contrast, with most conventional data warehouses where data is stored in static tables "you have to predict the sort of questions you will ask about the data so you can architect it accordingly," Scavo said.

SAP said that during pilot tests with a consumer goods company, HANA's in-memory computing engine enabled the company to run arbitrary, complex queries on over 450 billion records in a matter of seconds, compared with the hours it would have taken previously.

Such capabilities are becoming increasingly useful, especially in industries such as the retail sector, health care, scientific analysis and financial services, Scavo said. "There has been an explosion in the amount of structured and unstructured data that organizations have been able to collect," and are looking to mine, he said.



Our Commenting Policies