The sample database

The sample database included with Sybase IQ contains the following tables.

Figure 1-1: Tables in the sample database

Shown is the entity relationship diagram of the ten tables that comprise Sybase IQ sample database. The script that creates this database is available: on Windows: %ASDIR%†emo—kasiqdemo.sql and on UNIX: $ASDIR/demo/mkasiqdemo.sql

The database is composed of several files named asiqdemo, which is stored in the demo subdirectory in your installation directory. Many of the examples throughout the documentation use this database.

The sample database contains internal information about a fictional company (employees, departments, and financial data), as well as product information (products) and sales information (sales orders, customers, and contacts).

Tables in the database

The tables in the sample database include the following:

Table name	Contents
contact	Contacts are held separately from customers.
customer	Information about customers includes names and addresses.
department	Information about departments, such as manager and name.
employee	Information about employees, such as name, salary, and location.
fin_code	Each expense and revenue item has a financial code.
fin_data	Quarter-by-quarter financial information about the company.
iq_dummy	A table with exactly one row, useful for extracting information from the database.
IQ_SYSTEM_LOGIN_INFO_TABLE	Used by database administrator. See “Managing IQ user accounts and connections,” Chapter 12, “Managing User IDs and Permissions,”Sybase IQ System Administration Guide.
IQ_USER_LOGIN_INFO_TABLE	Used by database administrator. See “Managing IQ user accounts and connections,” Chapter 12, “Managing User IDs and Permissions,”Sybase IQ System Administration Guide.
product	Information about products, such as price and quantity available.
sales_order	Information about sales orders, such as date and the sales representative who made the order.
sales_order_items	Each order consists of one or more items. Information about sales order items is held in a separate table.
SYSOPTIONDEFAULTS	Used by database administrator. See “Managing IQ user accounts and connections,” Chapter 2, “Database Options,”Sybase IQ Reference Manual.

Case sensitivity

The sample database is case insensitive. This means that case is not considered in comparison and string operations. For example, you can type user IDs and passwords in either uppercase or lowercase when using the sample database. Note that, unlike the sample database, any IQ databases you create are case sensitive by default.