SAP HANA RAMBLINGS
SAP HANA is a leading IMDB(In-memory DB, not the movies one:)). It works by keeping all required in RAM. The idea of developing in-memory cache was started with mounting pressure from BW customers for faster query execution times. Also the same case with APO CIF queues. SAP answered this query by developing live cache for APO and BW accelerator, both works keeping data in-memory. This prompted to develop a fully operational DB in-memory, SAP HANA. The cheaply available RAM costs are also a main reason. SAP HANA is configured for parallel processing and distributed processing. When a query is passed to HANA DB engine, HANA observes the generated execution plan of the query. Then it identifies the parts of query that can be computed in parallel there by reducing response time. Also, HANA is deployed in infrastructure that has disaster tolerance and high availability. SAP teams up with hardware vendors like HP,Hitachi, IBM to develop this hardware infrastructure. These vendo...