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.