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.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between RDBMS and HBase
- Difference between RDBMS and OODBMS
- Difference between RDBMS and MongoDB
- Difference between RDBMS and Hive
- Difference between ER Model and RDBMS
- Difference Between RDBMS and Hadoop
- Difference between RDBMS and Couchbase
- Difference between RDBMS and IBM DB2
- RDBMS Full Form
- RDBMS Architecture
- Difference between OLAP and OLTP in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Difference between 1NF and 2NF in DBMS
- Difference between DDL and DML in DBMS
- Main difference between Timestamp protocol and Thomos write rule in DBMS
- Difference between Trigger and Procedure in DBMS
- Difference between 2NF and 3NF in DBMS
- Difference between 3NF and BCNF in DBMS
- Difference between Cursor and Trigger in DBMS
- Difference between File System and 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.