GeografÃa de Albania

Management and the access to a Database are ensured by a whole of programs which constitute the basic Management system of data (DBMS).

A basic management system of data generally lodges several databases, which are intended for software or different sets of themes.

One usually distinguishes the DBMS traditional, relational SGBD-R or DBMS, the SGBD-O Orienté object.

Functions of a DBMS

Addition of data

A DBMS must allow the addition of data. For that, it is first of all necessary to be able to describe the data with a language of description of data (LDD) . Once the described data, one can add values which correspond to description that one made by the means of a data manipulation language (LMD) .

Updated of the data

The data must be able. One must be able to change the definition of the data and the values of the data thanks to the LDD and LMD respectively.

Retrieval the data

The data retrieval is a crucial point. It is necessary that the DBMS can restore the data quickly.

Operation of a DBMS

Access methods to the data:

Sequential access.
access by chopping.
access indexed.

Some management systems of databases

(except contrary precision, it is about DBMS with relational claims):

4D of 4D SA
Adabas of Software AG
Access of Microsoft
Hidden of InterSystems (multidimentionnelle SGBDO)
Cloudscape (IBM, near to DB2), now Open Source and become Apache Derby
DBASE
external DB2 Bond DB2 of IBM, relational DBMS
DL/1 (or IMS/DB) of IBM, hierarchical DBMS
EyeDB SGBDO Open Source developed in C++
Files of chopping dB of the University of Berkeley
FileMaker Pro of FileMaker
FirebirdSQL, relational DBMS resulting from InterBase Free software
Gdbm files from chopping of the gnu
HyperFile of PCSoft
HSQLDB bases relational written in Java
Informix
Ingres
Interbase of Borland
Kexi, the relational Database free of the continuation KOffice of KDE.
MySQL, relational DBMS, Free software for the " Community Edition" , there exists also a commercial release
MaxDB of SAP AG and MySQL AB
OpenQM: a SGBDR multivaluée in double license LPG and commercial.
Oracle of Oracle Corporation
Pick (database multivalué)
PostgreSQL, relational DBMS Free software
Progress of Progress Software
SQL Server of Microsoft
SQLite
Sybase of Sybase
Unicorn of SirsiDynix
Windev of PCSoft

In detail:

a genealogy of SEQUEL which is in the beginning many DBMS
Histoire and genealogy of the DBMS
Comparatif of the DBMS

Internal bonds

Administrator of databases (also called dBa for DataBase Administrator )

External bonds

the French-speaking gate on the DBMS: Course, tutoriels, sources, and F.A.Q on SQL.
Forums DBMS: The forum of mutual aid of the French-speaking developers for SQL.
Pick: presentation of the operating system and multivaluée SGBDR.
Forum of news French-speaking news:fr.comp.applications.sgbd.

Be-X-old: Сыстэмакіраваньнябазамізьвестак