Sybase 12.4.2 - Manual (Page 26)

Catalogs and IQ
6
• The Catalog Store
When you create an IQ database, all three stores are created automatically. You
create IQ databases using the procedures described in Chapter 3, “Working
with Database Objects”.
The IQ Store
The IQ Store is the set of Adaptive Server IQ tables. You can have one or more
permanent IQ Stores, each in a separate database. Each IQ Store includes a set
of tables that organize your data. The table data is stored in indexes, which are
structured so as to allow rapid response to various types of analytical queries
on very large quantities of data.
The Temporary Store
The Temporary Store consists of a set of temporary tables. The database
server uses them for sorting and other temporary processing purposes; you
cannot store your data in them directly.
The Catalog Store
The Catalog Store contains all of the information required to manage an IQ
database. This information, which includes system tables and stored
procedures, resides in a set of tables that are compatible with Adaptive Server
Anywhere. These tables contain the metadata for the IQ database. Metadata
describes the layout of the IQ tables, columns, and indexes. The Catalog Store
is sometimes referred to simply as the Catalog.
Adaptive Server Anywhere and Adaptive Server IQ
The Catalog Store closely resembles an Adaptive Server Anywhere store.
Adaptive Server Anywhere is a relational database system that can exist with
or without IQ. You may have Adaptive Server Anywhere-style tables in your
Catalog Store along with your IQ tables, or you may have a separate Adaptive
Server Anywhere database.