Various functions of DBMSs

Database management systems provide various functions that allow management of data:

  • Data definition – Creation, modification and removal of definitions that describe the organization of data.
  • Update – Insertion, updation, and deletion of the actual data.
  • Retrieval – Providing information in a form directly usable or for further processing by other applications. The retrieved data may be provided  in a form same as it is stored in the database or in a new form obtained by altering the result data on the fly or by deriving new data from the result data.
  • Administration – Creation and monitoring of users, enforcing data security, maintaining data integrity, dealing with concurrency control, and recovering information that was affected by an unexpected system failure.