1.What is HANA?
- HANA stands for High Performance Analytical Appliance(It gives us analytics on top of big data with very high speed)
- It is a proprietary database of SAP and an in-memory database.
- Data can be stored in row/column format(In ECC system, data is stored in row format)
- Available as on-premise/cloud/hybrid mode.
2. Why HANA?
- The customer base of the business is increasing and there is huge amount of data that needs to be handled. There is a need for a system which can process and analyze data quickly at affordable costs.
- Here we can clearly see that in the ECC and BW System the process requires a longer time, almost minimum of 24 hours to get data and analyze it, where as in case of HANA database we can run any system on top of same database and get a real time analytics of data in the system( both OLTP and OLAP occur together). This aids in handling of large amount of data and at a faster speed compared to other database systems.
3. Features of HANA
- Predictive Analysis: Based on the existing data we can analyze what will happen in the future. The existing data of last 3–4 years can be fed into HANA system and we can analyze the production and sell situation of the coming years. Helps in managing inventory.
- Work with spatial data: can create 3D objects in HANA
- Work with graphs in HANA: we can create graphs in HANA and measure the distance between places.
- Text analysis on top of structured as well as unstructured data: the data stored in row and column format (Excel) is structured data, data in (Word, Presentation, Social Media) is unstructured data.
- Integration with other databases(Hadoop Integration): We can replicate data from another database and then perform analytics on top of that data. Once connected to another database a virtual copy of that database can be made in HANA and the analytics can be performed.
- High availability and disaster recovery: database will be available most of the time and will rarely have glitches, even if it does can recover quickly.