I’ve mentioned InfiniDB before in a previous post titled, “Star Schema Bechmark: InfoBright, InfiniDB and LucidDB,” but it’s been 4 years since that was published. Recently I evaluated column-storage solutions for Percona Cloud Tools and took another look at InfiniDB 4. There was the release of version 4, which I think is worth attention.
What is interesting in InfiniDB 4:
- Fully OpenSource, GPLv2. There is no reserved features for Enterprise version
- Multiple CPUs are used even for single query execution
- WINDOW functions in SQL queries
What is WINDOW functions? In short, in regular SQL for a given row you can’t access to previous and …[Read more]