A software designed to store, manage and facilitate access to databases.
Types
Relation Database Management System (RDBMS)
DBMSs that allow CRUD (Create, Read, Update, Delete) over relational databases are called Relational Database Management Systems (RDBMS).
Distributed Database Management System (DDBMS)
Allows CRUD over distributed databases. It can be treated as a ‘master’ DBMS, since it should support translation between many different local DBMS.
Some further features it would need to support are:
- Locate data with a distributed (spread out over multiple locations) catalogue
- Determine location from which to retrieve data and process query components
- DBMS translation between nodes with different local DBMSs (using middleware)
- Data consistency (via multiphase commit protocols)
- Global primary key control
- Scalability
- Security, concurrency control, query optimisation, failure recovery
Query Processing
See Query Processing