iTSCET

iT Portal

Explain the difference between DBMS and RDBMS ?

DBMS:


DBMS offers organized way of storing, managing and retrieving information.

A DBMS is a storage area that persist the data in files. To perform the database operations, the file should be in use.
Relationship can be established between 2 files.
There are limitations to store records in a single database file depending upon the database manager used.
DBMS allows the relations to be established between 2 files.
Data is stored in flat files with metadata.
DBMS does not support client / server architecture.
DBMS does not follow normalization. Only single user can access the data.
DBMS does not impose integrity constraints.
ACID properties of database must be implemented by the user or the developer

RDBMS:


RDBMS provides all features of DBMS with added referential integrity concept.

RDBMS stores the data in tabular form.
It has additional condition for supporting tabular structure or data that enforces relationships among tables.
RDBMS supports client/server architecture.
RDBMS follows normalization.
RDBMS allows simultaneous access of users to data tables.
RDBMS imposes integrity constraints.
ACID properties of the database are defined in the integrity constraints.

3 Comments

  1. velan

    DBMS: software that helps to store data in a database in the form of tables, manage databases on a single system or across a local network. They are used to manage small amount of data and are used in small business applications. eg: MsExcel

    RDBMS: a DBMS that also allows relationships to be established across different tables and allows querying of the table to extract certain data. They are useful to efficiently manage vast amount of data and are used in large business applications. eg: Oracle, MySQL.

    So essentially, RDBMS is a superset of DBMS.

  2. Excellent. I agree.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: