Difference between DBMS and RDBMS
DBMS: A system software which is used to create and maintain databases is called DBMS. Defining, manipulating, retrieving and managing data in a database are also performed by DBMS. In DBMS data is stored in file format.
RDBMS: Relation database management system is considered as an enhanced version of DBMS. RDMBMS is basically a DBMS contains row-based table structure which is used to connect related data elements. Functions like accuracy security, consistency and data integrity of data are performed in RDBMS. In RDBMS, data is stored in table format and data access can be done more efficiently.
| DBMS | RDBMS |
|---|---|
| 1. In DBMS, data is stored in file format. | 1. In RDBMS, data is stored in table format. |
| 2. Either a hierarchical form or a navigational from is used to store data in DBMS. | 2. A tabular structure where the headers are used as column names and the rows containing corresponding values are used to store data in RDBMS. |
| 3. DBMS means database management system. | 3. RDBMS means relational database management system. |
| 4. Normalization is not supported in DBMS. | 4. Normalization is supported in RDBMS. |
| 5. Security of data is absent in DBMS. | 5. Multiple level of security at logging level, at command level, at object level is present in RDBMS. |
| 6. In DBMS there is no relationship between the data. | 6. In RDBMS, consistency is ensured by maintaining relationship between table. |
| 7. While performing operations ACID model is not followed. | 7. Here most operations follow ACID model. |
| 8. Client server Architecture is not supported in DBMS. | 8. Client server Architecture is supported in RDBMS. |
| 9. Distributed Architecture is not supported in DBMS. | 9. Distributed Architecture is supported in RDBMS. |
| 10. Here, data elements are accessed individually. | 10. In is possible to access multiple data elements at the same time. |
| 11. Small quantity of data is handled here. | 11. Large quantity of data is handled here. |
| 12. DBMS allows data redundancy. | 12. In RDBMS, data redundancy is not allowed by keys and indexes. |
| 13. Single user is supported here and can be beneficial for small organization. | 13. Multiple users are supported here and can be beneficial for large organization. |
| 14. Slower data fetching for heavy amount of data. | 14. Faster data fetching for heavy amount of data. |
| 15. Integrity constants are not supported in DBMS. | 15. Integrity constants are supported in RDBMS. |
| 16. Low software and hardware necessities are visible. | 16. Higher software and hardware necessities are visible. |
| 17. Examples are XML, a file system, MS access, Windows registry etc. | 17. Examples are MySQL, Oracle, SQL Server, Postgre SQL etc. |
| 18. Here, data loss possibility is high. | 18. Here, data loss possibility is low. |
| 19. Less than 7 rules of Dr. e f codd is satisfied in DBMS. | 19. More than 7 to 8 rules of Dr. e f codd is satisfied in RDBMS. |
| 20. DBMS is less useful than RDBMS. | 20. RDBMS is more useful than DBMS. |
Recommended Posts:
Contributed By: Romana Rahman Ema