HANA and Her SAP Happiness
June 20, 2012
It has been a year since SAP launched its in-memory database processor HANA, and the company is pleased with the results, according to the Register’s “SAP Smashes HANA Forecasts, Adds Big Iron Benchmark.” The software more than doubled its revenue forecast, raking in over $200 million. More than half of the 354 HANA customers (64,000 end users) are using the product for non-SAP data. On top of that, SAP as a whole had some of the best profits of its history over the last year.
What’s next for this joyful company? Thomson informs us:
“The company will be announcing new hardware systems for big iron data processing engines. A benchmarking machine using 4,000 processor cores and 100TB of DRAM has given a 600 millisecond data response time querying a 500TB database, [SAP CTO Visha] Sikka said. With new Intel processors SAP should be able to push that even higher, he suggested, and so far eight OEMS are building HANA kit.
“As part of the birthday jamboree, SAP will also be detailing customer wins, including contracts in the Indian banking sector and the oil industry. Sikka also reported that the $155m HANA Real-Tune Fund for database development was also bearing fruit.”
That all sounds great, but we have a couple of questions about dear HANA. Just how does one search the data in it? Is an SAP expert needed? Important to know before investing in the product.
Founded in 1972 by five former IBM workers, SAP is headquartered in Walldorf Germany but has operations in over 50 countries.
Cynthia Murrell, June 20, 2012
Sponsored by PolySpot
Comments
One Response to “HANA and Her SAP Happiness”
-
- Subscribe to Beyond Search
Feature archive
News archive
-
Hi,
Search in SAP HANA is pretty straight forward.
First you create a fulltext index for the table columns that contain text.
Next you are using the graphical modeler in SAP HANA Studio to create a search model. Essentially you are defining which tables and table columns make up your model, e.g. TITLE, ABSTRACT, FULLTEXT, DATE, AUTHOR_NAME from the “DOCUMENT” table and AUTHOR_LOCATION, AUTHOR_COMPANY from the “AUTHOR” table.
Your search model is then accessible for search via SQL and an http REST service.
You can then use the SAP HANA UI toolkit to configure an HTML5 UI, i.e. which data is displayed in the search result list, in the facets.
That’s it. Everyone who understands the data and has basic knowledge about HTML can create a search based application in SAP HANA.
Regards, Markus