Query Speed, Data Compression, Not restricted schema design, Fast Loading, Zero administration, Easy to learn and use.
Improvements to My Organization
ASIQ offers a query engine where you can design a fully denormalized schema depending on business needs. It has the best performance in data retrieval compared to other database engines and reduces HW cost, achieving up to 70% less storage; Database is smaller than input data, even with all the indexes.
Room for Improvement
No – ASIQ has ability to scale by adding CPUs or nodes with no need to re-organize the data.
Customer Service and Technical Support
Customer Service: GoodTechnical Support: Good
I have used other traditional RDBMs in Business Intelligence systems like MSSQL and Oracle but the performance was not so good when increasing the data volumes. In order to achieve the ASIQ performance, we had to spent a lot of time configuring properly the database.
The initial setup was straightforward.
Is the best choice when used as DW data repository because it combines high speed queries and lower TCO.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jun 08 2014