| |
|
RDBMS VS DBMS
Question Posted on 21 Oct 2019
Home >> Tutorial >> SQL >> RDBMS VS DBMS |
RDBMS VS DBMS
When we target on differnce between DBMS and RDBMS we will came to know what is DBMS and RDBMS. Although both are used for stroing information in database but both uses different techniques and methods.
Below are the 8 main difference between DBMS and RDBMS
(1)RDBMS:- The main and most important feature in RDBMS is normalization that have separate RDBMS from DBMS.
(1)DBMS:-And Normalization is not present in DBMS.
(2)RDBMS:-It will store data in tabular form.
(2)DBMS:- On the other hand this will store data as a file.
(3)RDBMS:-These are the four main example of RDBMS mysql, postgre, SQL Server, Oracle etc.
(3)DBMS:-The file systems that is used now a days is XML this is the example of DBMS.
(4)RDBMS:-One more main feature of RDBMS is support of distributed database.
(4)DBMS:- DBMS not support distributed database.
(5)RDBMS:-It is basically designed to handle large ammount of data which also supports multiple users.
(5)DBMS:-DBMS is basically used for small organization whihc deal with small data. Which usually support single user.
(6)RDBMS:- Here data values are stored in the orm of tables and tables identifiers called primary key.
(6)DBMS:- Here data is stored in either a hierarchical form or a navigational form.
(7)RDBMS:-RDBMS defines the integrity constraint for the purpose of Atomocity, Consistency, Isolation and Durability property.
(7)DBMS:-DBMS will not apply any security or data manipulation.
(8)RDBMS:-As we know when we store data in table there is some relation between these tables are happen and this relationship is also stored in the form of a table as well.
(8)DBMS:-DBMS uses file system to no question arise of any relation in between the tables.
After reading above difference you will now get the information about the DBMS and RDBMS. And you will also know that RDBMS is the extension of DBMS. There are lots of third party tools available in market who supports both DBMS and RDBMS. | |
|
|
|
|