programmierung-datenbanken-1

Databases

A database is a system of electronic data management (DBS). In this process, data volumes are stored efficiently, without contradiction, intelligently and permanently, as well as required parts are made available in different presentation forms and application programs which are user-friendly.

The DBS consists of two parts: a database management system, and a management software. First stores the amount of data to be managed and thus represents the actual database (DB).

The administrative software, on the other hand, structures the storage of the data, internally organizes all processes and controls all write and read accesses to the DB. For administration and querying, a DBS provides a user-friendly database language and interface.

The essential functions of databases are today:

Optimization of inquiries
Enables Stored Procedures and Triggers
Save, overwrite and delete data
Management of data and metadata
Generation of data security
Creation of data protection
Arrangements for data integrity
Multi-user concept and transaction operation
Providing key figures via technology, services and operation of the DBMS

The database is an independent data organization, with which data stocks can be managed flexibly. This means that new data is added, old deleted or existing can be updated.