602SQL Documentation Index  

602SQL Server Operation and Administration

About the Client - Server Architecture

602SQL is based on the client-server model. The essence of this model is that a program offering services in a certain field is separated from programs using these services.

The program offering these services is called a server, in our case database (SQL) server. Server stores data in a database, allows searching them according to various criteria, sorts them, modifies them a ensures their integrity. The program using these services is called a database client. The client can display database data in visible windows, allows data inserting, data transfer between various file formats, monitoring server operation, developing database applications for the server.

SQL server usually serves multiple clients simultaneously. These clients can work on the same computer as the server, on a computer on a local network or on a computer that can connect to the server over Internet, WAN, dial-up etc. Each client can work with the same data, utilize each other's result and share information between them.

SQL servers offering services over a network usually run permanently. SQL server in the desktop version can be utilized for data operations only in the context of a single computer - then it's usually run and terminated by the client that requires its services.

602SQL doesn't allow client programs working over the same database to change contents of some shared file. The clients sent their requests to the server and only the server reads or writes data to the database.

Operating System Requirements

602SQL server can be run on Windows 98 SE and newer. Only a small part of functionality is restricted to newer versions : full support of Unicode character strings or ISO charsets requires Windows 2000 or newer.

602SQL server can be run on common Linux distributions. 602SQL server implements glibc version 2.3, is can be therefore run even on older distributions. 602SQL server is independent on nonstandard libraries. The graphic client uses X and GTK+ 2.2, however the server doesn't require these components.

Platform Differences

602SQL server is platform independent a offers the same services on all supported platforms. The platform differences occur mainly when the server uses special services installed on each platform:

Licence Conditions

Operation of the 602SQL server is restricted by a licence depending on server version.

List of topics: