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 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 these 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 thirty day evaluation period. |
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. |
| 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. |
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.