SAP HANA – a Quantum Leap Forward
The HANA database technology is a fusion of different techniques in the field of software and hardware. On the software side will use a hybrid combines both the column-oriented operation of the in-memory database technology uses, with the relational databases popular row-oriented database technology. A normal database stores the data in Row-store format, as for example an Excel spreadsheet stored the data in rows and columns. An in-memory computing database stores its data in contrast Column-store format.
On the hardware side, the memory of the computer by the CPU cache and the (hard) disk are replaced by the main memory. The result is a huge increase in access times. These performance benefits are as revolutionary as the transition from punch card to fast hard drive.
Now instead of hour long batch run calculations, you get your data in real time. Just imagine the advantages HANA can bring to your business.