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,226 times, 1 visits today)
Written by: