Text search and analysis in SAP HANA
This paper presents the options available in SAP HANA for text search and analysis. These options relate to the numerous ways in which the HANA platform can be used, especially in business applications, which have not been equipped with these types of functions before. The SAP HANA platform offers the users the possibility to search and visualize the content of the tables with the same simplicity as an Internet search does. The text search function entails a certain tolerance for errors (fuzzy search) as well as the processing of multilingual terms and synonyms. One possible example is filling in the value “buenes eires tele” in a field, and finding the correct value despite the faulty spelling, by searching the value across several columns. Nevertheless, the users cannot always easily determine if the result is the expected one, the correct one, within the fuzzy search context which tolerates errors. Have you ever wondered why you get unexpected results when you search for something on the web?