Infobright DB Review

I love that the solution is a columnar DB.

What is most valuable?

I love that the solution is a columnar DB. This means that there is data compression on the disk, a fully-indexed columnstore, and highly efficient query execution.

How has it helped my organization?

ICE helped us improve the speed for the “group-by” query by 10x. The system is robust and simple (it seems to be MySQL); installation, configuration and backup are very easy. Furthermore, there is no need to fine-tune database schema objects. You can just create the tables and go.

What needs improvement?

Complex subquery and analitycal functions could be improved.

For how long have I used the solution?

We have used this solution for about 5 years.

What do I think about the stability of the solution?

When running a complex subquery, the system hangs without giving the user any response.

What do I think about the scalability of the solution?

I have not encountered any issues with scalability.

How is customer service and technical support?

I used the Community Edition, so there was no support granted.

Which solutions did we use previously?

I used row-based proprietary DB for a few years. To meet my goals, however, I switched to this solution. Columnar DB are faster and are simpler than row-based solutions. With Columnar DB, there is no need to create an index, analyze the table/index, tune the structure, etc.

How was the initial setup?

The initial setup very simple. It was just like installing MySQL. Our only task was to implement an effective way to refresh large fact tables, because no delete or trunc partitions are possibile in ICE. So we implemented a method to export all but the window data to refresh, and then to re-import them all.

What's my experience with pricing, setup cost, and licensing?

ICE is a Community Edition product and I test it only on non-production systems. I don’t investigate licensing.

Which other solutions did I evaluate?

No, it was the first columnar DB I tested.

What other advice do I have?

Be carefully with complex query and subquery; ICE does not work with these queries.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email