SAP HANA in-memory database is a specialized database with following features
- All the read & write operations, take place in memory.
- Data can be stored both in row and column format.
- Every column is a secondary index and there is no need to maintain separate indexes.
- It has a much better Data compression as data from the same column can be stored together
- It utilizes distributive, multiprocessing & massive parallel processing capabilities of modern CPUs.
- validation logic
- control flow logic
- service enablement logic
- as most of
- calculation logic
- data-intensive processing
- are pushed down into the database layers to leverage the power of the features mentioned above.
Data-intensive logic can be written in SQL and SQL Script and it also has built-in support for XML for Analysis (XMLA) and Multidimensional Expression language (MDX) access for analytics.
The above information is just to get started. I would keep updating this blog with more up-to-date information.