Tuesday, October 14, 2014

DBMS V/S RDBMS


DBMS
RDBMS
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
DBMS does not support Client/Server Architecture
Most of the RDBMS supports Client/Server Architecture
DBMS does, not support Distributed databases
Most of the RDBMS supports Distributed databases
In DBMS there is no security of data
In RDBMS there are multiple levels of security
Logging in at O/S level
Command level (i.e. at RDBMS level)
Object level
Each table is given an extension in DBMS
Many tables are grouped in one database in RDBMS
DBMS may satisfy less than 7 to 8 rules of Dr. E. F. Codd
RDBMS usually satisfy more than 7 to 8 rules of Dr. E. F. Codd
Naming Conventions
DBMS
RDBMS
Field
Column, Attributes
Record
Row, Tuple, Entity
File
Table, Relation, Entity Class

No comments: