Reference
DBMS
Abbreviation for “DataBase Management System.”
3
DBMS (DataBase Management System)
A database product (software) called a “database management system”
is used to manage and manipulate databases.
The role of database management systems is to structurally store data and
maintain consistency so that the user can properly use the database at any
time.
The main functions of database management systems are summarized below.
Database management system
Database
definition
Simultaneous
processing
(exclusive
access control)
Log
management
Operations
management
Data
manipulation
Recovery process
(function)
Access
management
Reorganization
Database
Function
Reference
Buffer
A “buffer” is an area of memory used to
store data temporarily.
249
Description
Database
definition
Standardize the operations for defining the database structure,
including tables, items, and indexes.
Data manipulation
Standardize data manipulation (search, insert, update, and delete actions) with respect to the database.
Simultaneous
processing
(exclusive access
control)
Maintain data consistency so that even if multiple users manipulate the database simultaneously, no discrepancies arise in the
data.
Recovery process
(function)
Restore the data to the state it was in just before experiencing
hardware or software issues.
Log management
Store and manage the log files necessary for the recovery process.
Access control
Set user privileges for the database so that users without privileges cannot access the data.
Operations
management
Several management-related functions including database
backups and restoration, storage status, and buffer status.
Reorganization
Resolve database fragmentation resulting from repetitive adding and deleting of data.
Reorganizing the database improves the speed of data manipulation.