Sybase IQ is a high-performance decision support server designed specifically for data warehousing.
Sybase IQ is part of the Adaptive Server® product family that includes Adaptive Server® Enterprise for enterprise transaction and mixed workload environments and Adaptive Server Anywhere, a small footprint version of Adaptive Server, often used for mobile and occasionally connected computing. Component Integration Services are embedded within Sybase IQ and all Adaptive Server configurations to provide Sybase IQ users with direct access to relational or nonrelational databases on the mainframe, UNIX, or Windows servers.
There are slight differences in the Structured Query Language (SQL, pronounced “sequel”) syntax supported by Sybase IQ, Adaptive Server Anywhere, and Adaptive Server Enterprise. Sybase IQ Reference Manual provides an overview of compatibility of the SQL used by Sybase IQ, Anywhere and Enterprise.
