Internal DBMS access

A DBMS is a two-part piece of software: server software and client software. Depending on the distribution of this software on different machines, the internal players have different working methods at their disposal.

These modalities are differentiated according to two essential criteria: the need for client software installation and the machine on which the software is run.

The following paragraphs describe how to access DBMSs, illustrated in "The Oracle World". Oracle's classic architecture is based on a client-server organization.

– On the server, the DBMS manages one or more instances. An instance corresponds to a DB, which physically consists of a memory space, a set of processes and a set of files. Each instance hosts schemas (also known in Oracle as accounts, users or owners). Among these schemas, a distinction...