What is most valuable?
Query Speed, Data Compression, Not restricted schema design, Fast Loading, Zero administration, Easy to learn and use.
How has it helped 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.
What needs improvement?
What was my experience with deployment of the solution?
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
No – ASIQ has ability to scale by adding CPUs or nodes with no need to re-organize the data.
How are customer service and technical support?
Customer Service: GoodTechnical Support: Good
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
The initial setup was straightforward.
What was our ROI?
What other advice do I have?
Is the best choice when used as DW data repository because it combines high speed queries and lower TCO.