Relational Database Management System


 

Relational Database Management Systems (RDBMS) are database management systems which store data in a relational data model. This model was originally proposed in 1970 by Edgar F. Codd. Normalised data are saved in tables, interconnected using primary and secondary keys. In spite of some criticism, to this day RDBMS are still used as the conventional storage medium for transaction-oriented systems such as ERP systems, where mass data must be saved and edited simultaneously by multiple users.

Notwithstanding the abstract mathematical definition of the database model, relational databases are comparatively simple and flexible to operate. This played an important role in the success of this database technology. RDBMS are characterised by weaknesses in visualisation and analysis of multidimensional and hierarchical data structures in tables; this has led to the development of multidimensional databases, especially for planning, reporting and analysis in Business Intelligence.

The language used for data query or data manipulation is called Standard Query Language (SQL).

 

Back to glossary