Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 25 / 536

CHAPTER 1 Overview of Adaptive Server IQ System Administration
5
• 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