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 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:
Anywhere and IQ use a different schema from Adaptive Server Enterprise for the catalog (tables, columns, and so on).
Anywhere and 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 10, “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 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 IQ. The dba user
ID owns a small number of IQ system tables, used for IQ user and
multiplex administration.
