Understanding database servers

This section describes the basic components of a Sybase IQ system as a basis for using the product and performing tutorial tasks.

Access to your database must be made through a server, which provides a communications channel and a manipulation device for the database. An IQ server can dynamically start and stop a database, and accept connections from applications or users running on the same machine or on other computers by means of the network that links the two machines.Users can have connection rights to a database, not to the server. Sybase strongly recommends that you manage only one database per server.

You can use multiple Sybase IQ servers to combine the use of IQ, Anywhere, and Enterprise databases. You can also use multiple Adaptive Server Enterprise servers to combine the use of IQ and Enterprise databases.

A Sybase IQ multiplex is an IQ database spread across a shared disk array. Each server in a multiplex runs Sybase IQ. Each set of an IQ Temporary Store and Catalog Store make up one server, and the servers share a common IQ Store. (Servers may also, if desired, have local IQ Stores of privately managed data.) Users with large query loads and shared disk arrays may create an IQ multiplex to reduce I/O requirements and gain additional CPU power and memory space. A Sybase IQ multiplex supports many users, each executing complex queries against the shared database.

You can manage all Sybase IQ servers using one tool — Sybase Central.