A database management system is software that enables users to store, manage and retrieve data from a computer system. It is a set of programs that allow users to create, update and maintain a database, and it is designed to store, retrieve and manipulate data in an efficient and secure manner.
At its most basic level, a database management system stores data in an organised way. It stores data in tables, which are composed of records or rows. Each record contains data about a particular item, such as a customer or a product. The columns of the table contain the attributes of the item, such as a name, an address, a phone number or a product identifier.
Responsibilities
The system manages the data stored in the database. That includes creating, updating and deleting records, providing access to the data and applying security measures so that data is safe from unauthorised access. It can also generate reports and analyse data.
There are several types of database management system, including relational, object oriented, hierarchical, network and distributed systems. Each type has its own features and capabilities. The choice depends on the type of data that needs to be stored, the size of the database and the complexity of the queries.
The most popular type is the relational database, which stores and retrieves data organised into tables. It is the most common type in business applications and is used in banking, finance, retail and healthcare. Object oriented databases store data in objects rather than tables and suit complex data structures. Hierarchical databases suit data organised in a hierarchy, network databases suit data related through multiple relationships, and distributed databases suit data spread across multiple computers.
Database management systems are used in small businesses, large enterprises, government and education. The right choice depends on the needs of the organisation and the data it holds.
Sources and further reading
Official documentation and reference material for this topic.