An IQ database is a joint data store consisting of three parts:
The Catalog Store includes system tables and stored procedures, and resides in a set of tables that are compatible with Adaptive Server 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 these:
Adaptive Server Anywhere and Sybase IQ use a different schema from Adaptive Server Enterprise for the catalog (tables, columns, and so on).
Adaptive Server 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 9, “System Tables” and Chapter 11, “System Views.”
In Adaptive Server Enterprise, the database owner (user ID dbo) owns the catalog objects.
In Adaptive Server 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.
