- Tech know how online

database management system (DBMS)

Database management systems (DBMS) are used for information management. Such a system consists of the data and the programs with which the data is managed and processed. It can be understood as a kind of magazine for all data and is responsible for storage, security, integrity, recoveries and access to the data.

The database management system has a data directory, comparable to a catalog, which contains data about the names, structure, attributes, location and types of the stored data; metadata, so to speak. In this metadata directory, all logical and physical information and changes are stored throughout the life of the data: from import to deletion. DBMS software controls the organization and storage of data on disks, as well as the retrieval, security, and integrity of data in a database. In addition, a DBMS system can typically generate reports, import and export data from external applications, and query the database. If the data is stored in computermemory rather than on hard disks, then it is an in-memory database( IMDB).

An important aspect of DBMS systems is data security. Typically, a DBMS system has several levels of security in addition to the operating system and network security requirements. It supports user access to the database using password, authentication and user login. If the database is a distributed database( DDB), then database management is performed centrally by a Distributed Database Management System( DDBMS).

Englisch: database management system - DBMS
Updated at: 28.05.2019
#Words: 231
Links: information management (IM), system, data, security, integrity
Translations: DE

All rights reserved DATACOM Buchverlag GmbH © 2024