Sybase® IQ is a high-performance decision-support server designed specifically for data warehousing.
Sybase IQ is part of the Sybase product family that includes Adaptive Server Enterprise and SQL Anywhere. Component Integration Services within Sybase IQ provide direct access to relational and nonrelational databases on mainframe, UNIX, or Windows servers.
Sybase IQ is available in several product editions.
| Product Edition | Description |
|---|---|
Enterprise Edition |
Supports all options and features. Optional features require additional licenses that are purchased separately. |
Small Business Edition |
Supports most of the functionality available in the Enterprise Edition, but does not support multiplex or any optional features. |
Single Application Server |
Provides the same functionality as the Small Business Edition, but is restricted to use in a one- or two-machine environment. |
Evaluation Edition |
Supports all options and features available in the Enterprise Edition for a 30-day evaluation period. |
Express Edition |
Supports all options and features available in the Evaluation Edition. Unlike the Evaluation Edition, the Express Edition does not expire, but does restrict the size of all IQ main dbspaces, permit other incremental license options, and cannot be deployed in a production environment. |
Optional features extend the utility of the Enterprise Edition.
| Option | Description |
|---|---|
Unstructured Data Analytics |
Supports Binary Large Object (BLOB) and Character Large Object (CLOB) storage and retrieval. Supports Binary Large Object (BLOB) and Character Large Object (CLOB) storage and retrieval. |
Advanced Security |
Supports these optional security features:
|
Multiplex Grid |
Lets you add additional nodes to a multiplex environment. Sybase IQ requires an additional license to start secondary multiplex nodes (readers/writers). |
Very Large Database Management |
Lets you add multiple table spaces and dbspaces to logically partition data into manageable subsets. Sybase IQ requires an additional license when the server creates or starts with two or more IQ user dbspaces. |
Express Edition |
Supports all options and features available in the Evaluation Edition. Unlike the Evaluation Edition, the Express Edition does not expire, but does restrict the size of all IQ main dbspaces, permit other incremental license options, and cannot be deployed in a production environment. |
All product editions except the Evaluation Edition require a license. Optional features are sold and licensed separately.
The Evaluation Edition is an unlicensed server, which provides full access to all features and options available in the Enterprise Edition. To run the Evaluation Edition beyond the thirty-day evaluation period, however, you must purchase and install the appropriate license.