Difference Between DBMS & RDBMS in Tabular Form
| No. | Feature | DBMS | RDBMS |
|---|---|---|---|
| 1. | Full Form | Database Management System | Relational Database Management System |
| 2. | Storage | data as file. | data in a tabular form. |
| 3. | Security | DBMS does not apply any security with regards to data manipulation | RDBMS defines the integrity constraint for the purpose of ACID (Atomocity, Consistency, Isolation and Durability) property. |
| 4. | Normalization | Not present in DBMS. | Present in RDBMS. |
| 5. | Search | Data is generally stored in either a hierarchical form or a navigational form. | the tables have an identifier called primary key and the data values are stored in the form of tables |
| 6. | Relationship | no relation between the tables. | Data values are stored in the form of tables, so a relationship between these data values will be stored in the form of a table. |
| 7. | Useage | DBMS is meant to be for small organization and deal with small data. it supports single user. | RDBMS is designed to handle large amount of data. it supports multiple users. |
| 8. | Distributed Database | DBMS does not support | RDBMS supported. |
| 9. | Structure to Access | DBMS has to provide some uniform methods to access the stored information. | RDBMS system supports a tabular structure of the data and a relationship between them to access the stored information |
| 10. | Examples | file systems, xml etc. | mysql, postgre, sql server, oracle etc. |
(Visited 1,199 times, 1 visits today)
Written by: