DBMS Functions: Data Storage, Retrieval, and Update; Security; Recovery Crashes and Integrity (Especially for GATE-Geospatial 2022)

Get top class preparation for IMO-Level-2 right from your home: get questions, notes, tests, video lectures and more- for all subjects of IMO-Level-2.

Examrace Books on Mapping, GIS, and Remote Sensing prepares you throughly for a wide range of practical applications.

The SQL independent of the underlying database structure and many vendors offer SQL implementations for their database systems.

A DBMS makes it possible for users to create, edit and update data in database files. The DBMS makes it possible to store and retrieve data from those database files.

Functions of DBMS

This Diagram Shows a DBMS Functions

A DBMS provides,

  • Data storage, retrieval, and update: A DBMS provides users with the ability to store, retrieve and update data in the database.
  • Security: is used to grant/revoke privileges to users,
  • Recovery crashes: A DBMS provides a mechanism for recovering the database if the database is damaged in any way.
  • Integrity: A DBMS provides a means to ensure that both the data in the database and changes to the data follow certain rules.

Within an organization, the development of the database is typically controlled by database administrators (DBAs) and other specialists. This ensures the database structure is efficient and reliable.

Database administrators also control access and security aspects. For example, different people within an organization use databases in different ways. Some employees may simply want to view the data and perform basic analysis. Other employees are actively involved in adding data to the database or updating existing data. This means that the database administrator needs to set the user permissions. You don՚t want someone who only needs to view the database to accidentally delete parts of the database.

Developed by: