An IQ database is a joint data store consisting of:
The catalog store includes system tables and stored procedures, and resides in a set of tables that are compatible with SQL Anywhere.
The permanent IQ store is the set of Sybase IQ tables. Table data is stored in indexes.
The temporary store consists of a set of temporary tables which the database server uses for sorting and other temporary processing.
Catalog distinctions and compatibility features include:
SQL Anywhere and Sybase IQ use a different schema from Adaptive Server Enterprise for the catalog (tables, columns, and so on).
SQL Anywhere and Sybase IQ provide compatibility views that mimic relevant parts of the Adaptive Server Enterprise system tables, although there are performance implications when using them. For a list and individual descriptions, see Chapter 8, “System Views” and Chapter 9, “System Tables.” For a complete list of SQL Anywhere compatibility views, see SQL Anywhere Server – SQL Reference.
In Adaptive Server Enterprise, the database owner (user ID dbo) owns the catalog objects.
In SQL Anywhere and Sybase IQ, the system owner (user ID SYS) owns the catalog objects.
A dbo user ID owns the Adaptive
Server Enterprise-compatible system views provided by Sybase IQ.
The dba user ID owns a small number of Sybase IQ system
tables, used for Sybase IQ user and multiplex administration.
