Database Management Systems (DBMS)
A database management system (DBMS) is the software that creates, manages and secures a database. This lesson covers its purpose and tools, including the data dictionary, data modelling and the logical schema, controlling who can access what, and keeping data safe with concurrency control, backup and recovery.
Key terms
- Database management system (DBMS)
- Software that creates, manages and controls access to a database.
- Data dictionary
- A store of metadata describing the database, such as table names, fields, data types and keys.
- Data modelling
- Defining the structure of the data and how it is organised before the database is built.
- Logical schema
- A description of the database's structure, such as its tables and relationships, independent of how it is physically stored.
- Access rights
- Permissions that control which users can see or change which data.
- Concurrency control
- Managing several users accessing the same data at once so that they do not conflict.
- Backup and recovery
- Regularly copying the database and being able to restore it after loss or corruption.
Part of Databases.