RDBMS

RDBMS

 RDBMS (Relational Database Management System) is a type of database system used for creating, managing and operating, a relational database. It is used for defining the relation between the multiple tables of the database. Examples of RDBMS are: NIS-Access, Oracle, SQL Server, My SQL etc.

Function of RDBMS

The functions of RDBMS are:

  • Easier access of data.
  • Better security for the protection of data.
  • Representation of all types of relationships.
  • Data redundancy is reduced.
  • Faster and efficient searching of required data.
  • Easier modification and deletion of data.
  • Concurrent access of data
  • Providing user interface to access data
  • Maintaining integrity by enforcing standards

Advantages of RDBMS

Advantages of RDBMS are:

 Redundancy can be reduced: The use of RDBMS reduces redundancy. Redundancy refers to the duplication of data i.e. data stored more than one location. The reduced redundancy results in:

  • Minimized wastage of storage
  • Easier access and manipulation of data 
  • Confusing cases can be avoided

 Inconsistency can be avoided: Reduced redundancy results in avoiding inconsistent state. RDBMS ensures that the database is always in consistent state.

 Standards can be enforces: RDBMS applies standards or rules, which is used to minimize error during input process and maintain security.

 Integrity can be maintained: RDBMS helps to maintain accuracy of the data by applying standards or rules.

Data can be shared: With the use of RDBMS, same data can be shared and used by multiple users at the same time.

Provides security: RDBMS provides security mechanism on the database, so that it can be used only by the authorized users. It provides authentication and access control.

 Providing user interface to access data: It provides user interface through Which user can access database. It provides both GUI and CUI based user interface.

 Provides facility for backup and recovery: It provides tools for backup, restore and recovery tools.

  • Different Between DBMS AND RDBMS
                                DBMS                            RDBMS
DBMS stand for Database Management System  RDBMS stand for Relational Database Management System
DBMS application store data as fileRDBMS application stores data in a tabular form
Normalization is not present in DBMSNormalization is present  
It does not contain relation between tableIt contains relation between table  
It doesn’t apply any security with regards to data manipulationIt define different integrity constrains for the data manipulation
It doesn’t support distributed databaseIt support distributed data base
It designed for handling small amount of data, single user in a small organizationIt designed to handle large amount of data, multiple users in a large organization

Leave a Reply

Your email address will not be published. Required fields are marked *