What is the best freely available software / database for OLAP data processing?

  softwareengineering

We would like to use a freely available database / software for OLAP style batch processing of less than 1PB of structured data. Free does not necessarily mean open source (although being open-source would be nice).

  • our queries are not ad-hoc. we need to process the data to crunch numbers that are then displayed in dashboard and reports but the queries are fixed. assume we don’t need to support myriad filters such as “ok show me how the numbers change if I do so and so”. however, if a database can address that scenario as well, we might as well use it.
  • we don’t need interactive response times although faster is always better.

this is mostly a green-field project so we don’t have any baggage or constraints like that. We have done some research but are confused with the large amount of tools available all promising to be the best and would welcome suggestions from the community.

by design we are not mentioning any potential candidates as we would like to hear untainted opinions that are not primed with any initial conditions.

LEAVE A COMMENT