Sybase 12.4.2 manual Database server, Catalogs and IQ

CHAPTER 1 Overview of Adaptive Server IQ System Administration

•Sybase Central is an application for managing Sybase databases. It helps you manage database objects and perform common administrative tasks such as creating databases, backing up databases, adding users, adding tables and indexes, and monitoring database performance. Sybase Central has a Java-based graphical user interface, and can be used with any operating system that allows graphical tools.

•DBISQL, also called Interactive SQL, is an application that allows you to enter SQL statements interactively and send them to a database. DBISQL has a window-like user interface on all platforms.

The Introduction to Adaptive Server IQ explains how to use Sybase Central and DBISQL to perform simple administrative tasks. If you are not already familiar with these tools, you should read about them in the Introduction to Adaptive Server IQ and use the tutorials provided there.

In addition to these tools, Adaptive Server IQ provides a number of stored procedures that perform system management functions. See “Stored procedures” for more information. You can also create your own procedures and batches.

A few administrative tasks, such as selecting a collation, rely on command-line utilities. These utilities are discussed in other chapters of this book, and described in the Adaptive Server IQ Reference Manual.

The database server

The database server is the “brain” of your Adaptive Server IQ system. Users access data through the database server, never directly. Requests for information from a database are sent to the database server, which carries out the instructions.

Catalogs and IQ

An Adaptive Server IQ database is a joint data store consisting of three parts:

•The permanent IQ Store

•The Temporary Store

5