Sybase IQ Multiplex
Date:
By: Philip Howard
Classification: Product Evaluation
Sybase IQ Multiplex (IQ-M) is a relational database aimed at data
warehousing environments and, particularly, at very large data warehouses.
What distinguishes IQ-M from its principal competitors is that it is predicated
upon a column-based approach rather than the row-based approach that is
traditional for relational databases. This provides a number of very significant
advantages within a query environment, not least in terms of performance and
scalability. Specifically, IQ-M installations will normally offer orders of
magnitude improvements in query performance (especially where those
queries are complex or require large table scans) while requiring reduced
hardware resources. In other words it provides (much) better performance for
less money.