What is RDBMS (Relational Database management System)

 Q. What is  RDBMS (Relational Database management System):-

It stands for "Relational Database Management System." An RDBMS is a DBMS designed specifically for relational databases. Therefore, RDBMS is a subset of DBMS.

 A relational database refers to a database that stores data in a structured format, using rows and columns. This makes it easy to locate and access specific values within the database. It is "relational" because the values within each table are related to each other. Tables may also be related to other tables. The relational structure makes it possible to run queries across multiple tables at once. 

                                   While a relational database describes the type of database an RDMBS manages, the RDBMS refers to the database program itself. It is the software that executes queries on the data, including adding, updating, and searching for values. An RDBMS may also provide a visual representation of the data. For example, it may display data in a tables like a spreadsheet, allowing you to view and even edit individual values in the table.

             Some RDMBS programs allow you to create forms that can streamline entering, editing, and deleting data. Most well known DBMS applications fall into the RDBMS category. Examples include Oracle Database, MySQL, Microsoft SQL Server, and IBM DB2. Some of these programs support non-relational databases, but they are primarily used for relational database management. Examples of non-relational databases include Apache HBase, IBM Domino, and Oracle NoSQL Database. These type of databases are managed by other DMBS programs that support NoSQL, which do not fall into the RDBMS category.

Advantages of RDBMS: 

1. It is easy to use.

 2. It is secured in nature. 

3. The data manipulation can be done. 

4. It limits redundancy and replication of the data. 

5. It offers better data integrity.

6. It provides better physical data independence. 

7. It offers logical database independence i.e. data can be viewed in different ways by the       different users.

 8. It provides better backup and recovery procedures. 

 9. It provides multiple interfaces.

10. Multiple users can access the database which is not possible in DBMS. 

Disadvantages of RDBMS: 

 1. Software is expensive.

 2. Complex software refers to expensive hardware and hence increases overall cost to avail    the RDBMS service.

 3. It requires skilled human resources to implement. 

 4. Certain applications are slow in processing. 

 5. It is difficult to recover the lost data.