Page tree
Skip to end of metadata
Go to start of metadata
The full text of this page is only available to our customers.

Please login or sign up. You may also need to provide your support ID if you have not already done so.

Discover with BMC Discovery
download

This product can be discovered by Enterprise version of BMC Discovery, but you can still Download our free Community Edition to discover [other products] !

What is this?
This is a product information page, containing details of the information that BMC Discovery gathers about a product and how it is obtained.
Product Name
Adaptive Server IQ
Publisher Page
Sybase
Category
Relational Database Management Systems
Release
TKU 2016-Nov-1
Change History
Sybase Adaptive Server IQ - Change History
Reports & Attributes
Sybase Adaptive Server IQ - Reports & Attributes
Publisher Link
Sybase

Product Description

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.

Sybase IQ Multiplex

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.

The full text of this page is only available to our customers.

Please login or sign up. You may also need to provide your support ID if you have not already done so.