Introduction to Database Management System (DBMS)

A database is structured collection of data that is stored in a computer system. Databases help in accessing, manipulating, storing and analyzing data quickly and easily.

Databases can be Flat File Databases, Relational Databases, Distributed Databases etc.

Database management system (DBMS)

DBMS is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. DBMS allow the definition, creation, querying, update, and administration of databases. Some of the popular DBMSs are MySQL, Oracle, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB.

Database systems should have the following properties:

• Reliability
• Efficiency
• Scalability
• Concurrency control
• Data abstractions
• High-level query languages.

Relational database management system (RDBMS)

RDBMS is a type of database management system (DBMS) that lets you create, update, and administer a relational database. It is based on the relational model as invented by E. F. Codd, of IBM’s San Jose Research Laboratory.

One of the  feature of RDBMS is that a single database can be spread across several tables.  The data are stored into collection of tables, which might be related by common fields. RDBMS also provide relational operators to manipulate the data stored into the database tables. Generally, SQL is used as database query language in RDBMS.