This product can be discovered by Enterprise version of BMC Discovery, but you can still Download our free Community Edition to discover [other products] !
Sybase IQ (formally known as Sybase Adaptive Server IQ and IQ Accelerator) is a highly scalable analytical engine, designed specifically from the ground up for query performance. Sybase IQ is optimized for data warehouse type applications, where data is added to databases but typically not modified much if at all, and the typical access is to search through the data. What distinguishes IQ 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.
The Sybase IQ Multiplex architecture allows for a much more scalable implementation of the database. Through the use of this architecture, many Sybase IQ instances can share the Sybase IQ Data Store simultaneously, allowing many more queries to be executed against the database without any noticeable performance degradation.
The Multiplex installation is composed of many host machines connected to a shared disk through a shared I/O backplane.
The Sybase IQ instances installed on these host machines are designated as either query servers or as a write server. There is only one write server allowed in the multiplex installation, but many query servers can be present. The creation of these servers is accomplished through the Sybase Central.