Differences
between DBMS and RDBMS:
DBMS
|
RDBMS
|
(i)
DBMS Applications store data as file.
|
(i)RDBMS
Applications store data in a tabular form.
|
(ii)
In DBMS, data is generally stored in either a hierarchical form or a
navigational form.
|
(ii)
In RDBMS, the tables have an identifier called primary key and the data
values are stored in the form of tables.
|
(iii)
Normalization is not present in DBMS.
|
(iii)
Normalization is present in RDBMS.
|
(iv)
DBMS does not apply any security with regards to data manipulation.
|
(iv)
RDBMS defines the integrity constraint for the purpose of ACID (Atomicity, Consistency,
Isolation and Durability) property.
|
(v)
DBMS does not support distributed database.
|
(v)
RDBMS supports distributed database.
|
(vi)
DBMS uses file system to store data, so there will be no relation between the
tables.
|
(vi)
In RDBMS, 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 as well.
|
(vii)
DBMS is meant to be for small organization and deal with small data, it
supports single user.
|
(vii)
RDBMS is designed to handle large amount of data, it supports multiple users.
|
(viii)
DBMS model cannot achieve the structural and data independence.
|
(viii)
Example of RDBMS are my sql, posture, sql server, oracle etc.
|
(ix)
Examples of DBMS are file systems, xml etc.
|
(ix)
RDBMS model can achieve both the structural and data independence.
|
No comments:
Post a Comment