Difference Between DBMS and RDBMS
Dbms and Rdbms both are used to store information in physical database but they have some differences, which is given below;
Dbms | Rdbms | |
---|---|---|
1 | In DBMS data are store as a file. | In Rdbms data are store in a tabular form. |
2 | In dbms relationship between two tables or files are maintained programmatically | In Rdbms relationship between two tables or files can be specified at the time of table creation. |
3 | Dbms does not support client server architecture. | Rdbms supports client server architecture. |
4 | Dbms does not support distributed architecture. | Rdbms support distributed architecture. |
5 | In dbms there are no security of data. | In rdbms there are multiple level of security, at logging level, at command level, at object level. |
6 | Dbms may satisfy less than 7 rules of Dr. e.f codd | Rdbms usually satisfy more than 7 to 8 rules of Dr. e.f codd. |
7 | Normalization is not available in DBMS. | Normalization is available in RDBMS. |
8 | Examples of DBMS are file systems, xml etc. | Example of RDBMS are mysql, postgre, sql server, oracle etc. |
Conclusion: After read all the above difference you can say that Rdbms is most secure and useful than Dbms.
Comments
Post a Comment