Database Management System (DBMS) is a software that is used to define, create and maintain a database and provides controlled access to the data.
Relational Database Management System (RDBMS) is an advanced version of a DBMS.
|DBMS stores data as file.||RDBMS stores data in tabular form.|
|Data elements need to access individually.||Multiple data elements can be accessed at the same time.|
|No relationship between data.||Data is stored in the form of tables which are related to each other.|
|Normalization is not present.||Normalization is present.|
|DBMS does not support distributed database.||RDBMS supports distributed database.|
|It stores data in either a navigational or hierarchical form.||It uses a tabular structure where the headers are the column names, and the rows contain corresponding values.|
|It deals with small quantity of data.||It deals with large amount of data.|
|Data redundancy is common in this model.||Keys and indexes do not allow Data redundancy.|
|It is used for small organization and deal with small data.||It is used to handle large amount of data.|
|It supports single user.||It supports multiple users.|
|Data fetching is slower for the large amount of data.||Data fetching is fast because of relational approach.|
|The data in a DBMS is subject to low security levels with regards to data manipulation.||There exists multiple levels of data security in a RDBMS.|
|Low software and hardware necessities.||Higher software and hardware necessities.|
|Examples: XML, Microsoft Access, etc.||Examples: MySQL, PostgreSQL, SQL Server, Oracle, etc.|
- Difference between RDBMS and MongoDB
- Difference between RDBMS and OODBMS
- Difference between RDBMS and Hive
- Difference between RDBMS and HBase
- Difference between DDL and DML in DBMS
- Difference between OLAP and OLTP in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Need for DBMS
- Deadlock in DBMS
- Disadvantages of DBMS
- Starvation in DBMS
- Cascadeless in DBMS
- Recoverability in DBMS
- Interfaces in DBMS
- Database Objects in DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.