Do not use the Infobright IEE database. It is a fast, standalone columnar database masquerading as a big data solution. If you need a real big data solution, look for a distributed solution that actually has a proven track record.

I don't suggest using an SQL-like solution for Big Data storage at all. But, if this is the case, it should be Oracle or paid versions of MySQL.

Get the 30-day free trial version and try to implement part of your project or conduct a formal Proof of Concept (PoC). You will be surprised by how easy and fast the development is.

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

It is very straightforward and easy to work with. It is excellent for real-time analytics, sensor data and agile data model development/implementation.

Ad-hoc analytics are extremely reliable and easy to live with.