A database management system (DBMS) is a software interface that sits between a database and a user,
or between a database and an application (such as an inventory system).
Different DBMSs support different database models and different
- DDLs [Data Definition Language] and
- DMLs [Data Manipulation Language] .
A typical DBMS creates, manipulates, modifies, and maintains a database.
A relational database management system (RDBMS) supports the relational model.
It performs the same basic functions as those listed for a DBMS.
SQL is the data definition and data manipulation language that is packaged with an RDBMS.
The following SlideShow walks you through the major functions of a RDBMS. Use the forward and back arrows to navigate through the series of images.
One RDBMS can manage many relational databases.
Oracle, Microsoft, IBM, MySQL, and Sybase have comprehensive RDBMSs available on the market.
Each company packages its product(s) with utilities to enhance RDBMS capabilities and performance.
Product prices vary widely among these top competitors.
The next lesson discusses the concept of database change management.
Before moving on to the next lesson, click the Exercise link below to check your knowledge of the functions of an RDBMS.
RDBMS - Exercise