WARNING:
JavaScript is turned OFF. None of the links on this concept map will
work until it is reactivated.
If you need help turning JavaScript On, click here.
This Concept Map, created with IHMC CmapTools, has information related to: Sybase IQ, transaction log data in IQ tables, IQ store (for data) Stores data as indexes compressed, Sybase Central Manage SYSTEM, data as indexes compressed physically stored in dbfiles, Server Files include Catalog store transaction log, Admin custom configured Sybase IQ Server, IQ temporary store (for temporary data) Logical name is IQ_SYSTEM_TEMP, Relation Database can store Tables View Stored procedures Triggers Indexes Referential integrity (surrogate keys), IQ tables Include ISYSIQTABCOL ISYSIQDBFILE ISYSIQIDX ISYSIQINFO ISYSIQTAB, Sybase IQ Server Support only 1 Sybase IQ database, IQ message log Readable log file contains Insert and delete messages Error messages Status messages Query plans, Admin using DBISQL client, IQ store (for data) Stores transaction log data, Catalog store (for metadata) Contains all information needed to manage an IQ database Metadata stored in the system tables, Catalog store (for metadata) Contains all information needed to manage an IQ database Stored procedures (system and user), DBISQL client Manage SYSTEM, Catalog store transaction log Physical file name is dbname.log, IQ store (for data) physically organized as dbfiles, 3 Stores include IQ store (for data), Sybase IQ Server is the heart of Sybase IQ system