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.