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 SQL Anywhere, a small footprint version of Adaptive Server Enterprise, 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 SQL (Structured Query Language) syntax supported by Sybase IQ, SQL Anywhere, and Adaptive Server Enterprise. Reference: Building Blocks, Tables, and Procedures provides an overview of compatibility of the SQL used by Sybase IQ, SQL Anywhere, and Adaptive Server Enterprise. See Appendix A, “Compatibility with Other Sybase Databases.”
