602SQL Documentation Index  


Database is a storage for data and other database objects. Each SQL server serves only a single database.

Database registration

Each database is designated by its name and is registered under this name both on the server and client computers. Server gets the database name on startup and locates the appropriate database file by using the database registration entries. A client uses database registration entries to get the network address of the server working with the database, so the client can connect to the server.

Databases are registered in the system registry on Windows, and in the /etc/602sql configuration file on Linux.

Internal database architecture

Database can be internally divided into schemes. Each object (such as a database table) belongs to a particular scheme. More objects of the same name may exist in different schemes. The schemes usually correspond with the database applications being run on the server. The schemes mostly contain data tables, stored procedures or components of the user application interface.

Planning shared databases and network database servers

Data, that should be accessible over a network can be stored in a single central database or divided into more databases. Several things should be considered when deciding how many databases to use:

Apart from the network database sharing, users can create local databases for private data handling. These databases are run over local servers.

List of topics: