Skip to content

Notes on science, software and the craft of support

Martin EvansNotes and resources

Databases

Relational database management systems

A relational database management system stores data in tables and views, enforces structure and lets users query, secure and maintain the data.

A relational database management system is software designed to store and retrieve data from a database. It enables data to be stored in an organised, logical and secure manner. It is used to store and manage data in a database, which is a collection of information organised so that it can be accessed, managed and updated easily.

The main purpose of such a system is to provide a platform for database management. It is used to create, update, delete and access data. It contains tables, which are collections of data that can be related to each other in order to store and retrieve information. It also contains views, which are virtual tables that display data from multiple tables.

Features and products

A relational system allows users to define database structure, manipulate data, query data, develop database applications and secure the database. It also provides a user friendly interface for managing the database. It stores data in a relational way, which is a logical and efficient approach.

The most popular systems are Oracle, Microsoft SQL Server, IBM DB2, MySQL and PostgreSQL. Each has its own features and advantages. Oracle is widely used and provides a broad set of features, while MySQL is an open source system that is easy to use and popular among web developers.

When choosing a system, it is important to consider the size and complexity of the database, the type of data being stored and the performance requirements. It is also important to consider cost, support, security and scalability. A relational database management system is an essential tool for any organisation that needs to store and manage data in an organised, logical and secure manner.