2. 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...
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Internal DBMS access
External access to the DBMS
Bibliography
Software tools
Eclipse http://www.eclipse.org/
JDK http://www.oracle.com/technetwork/java/javase/
SQLDeveloper http://www.oracle.com/technetwork/developer-tools/sql-developer/
...Standards and norms
- SLQ1 – Information processing systems – Database language – SQL - ISO 9075 - 1987
- SQL2 – Information technology – Database languages – SQL - ISO/IEC 9075 - 1992
- SLQ3 – Information technology –Database languages – SQL – Part 1: Framework (SQL/Framework) - ISO/IEC 9075–1 - 1999
The Ultimate Scientific and Technical Reference
