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:

Mail support using SMTP/POP3 is available for all platforms, however you can use MAPI on Windows operating systems.
Fulltext indexing of text files is available for all platforms, however you can index documents in formats, for which you have necessary convertors installed on individual platforms.
Identity of the client connecting to the server can be verified by platform specific tools, e.g. you can use domain login on Windows operating systems.
Information describing installed server and existing databases are stored in different locations.
Date, time and other data conversion into a character string may depend on operating system locale.
The way of executing or automatic executing of the server differs : server may be run as a service or a task on Windows, or as a interactive task or a daemon on Linux.
Several slight differences exist in 602SQL Development Client too.

Licence Conditions

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

List of topics:

Installation of the 602SQL

Obsah

SQL Language in 602SQL