Open Source Business Intelligence (BI) does not have to be slower than commercial solutions. On the contrary, the processing time of Palo Server 2.0 has picked up 10 times the speed compared to its previous version and in-memory OLAP database applications used for planning, reporting, consolidation and analysis run that much faster. In fact, BI applications based on Palo 2.0 may run faster than popular commercial BI solutions.
Palo Server facilitates high speed by keeping processed data in memory (In-Memory OLAP). Queries for base and also aggregated data cells take place in real-time and provide results quickly. With that, Palo Server provides a great contrast to popular multidimensional databases, which are based on relational technologies (ROLAP). Further, in-memory planning – both top/down as well as bottom/up – is supported by the functionality to write-back data into the cubes. [Read more…]