Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 122 / 536

Building Your Adaptive Server IQ Databases
102
Multiplex users: The following steps are for creating a non-multiplex
database. To create a multiplex database, see the Adaptive Server IQ Multiplex
User’s Guide.
❖
To set up an IQ database:
1 Install and configure Adaptive Server IQ.
This step creates the database server and the
asiqdemo
database, and
allows you to create your first database when you have no other database
to connect to. See the Adaptive Server IQ Installation and Configuration
Guide for your platform for details.
2 Create an IQ database.
This step creates both the IQ Store and the Catalog Store. Use the
CREATE
DATABASE statement or the Sybase Central Create Database Wizard. See
“Working with databases” on page 106.
3 Create the tables in your IQ database.
Use the CREATE TABLE statement or the Sybase Central table editor. See
“Working with tables” on page 118
4 Create indexes for the tables.
Use the CREATE INDEX statement or the Sybase Central Index Wizard.
You can also create certain indexes automatically when you create your
tables. See Chapter 4, “Adaptive Server IQ Indexes.”
5 Load data into the tables.
Use the LOAD TABLE statement to bulk load data from files, or use the
INSERT statement to extract rows of data from an existing database. See
Chapter 5, “Moving Data In and Out of Databases.”.
6 Create join indexes as needed, to improve performance of queries that join
data from multiple tables.
To create a join index, use the CREATE JOIN INDEX statement, or the
Sybase Central Add JoinIndex Wizard. See Chapter 4, “Adaptive Server
IQ Indexes.”
Scheduling data definition tasks
Once the database exists and other users have access to it, follow these
guidelines when you need to perform additional data definition operations,
such as adding or modifying tables or indexes.