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 stand for Database Management System||RDBMS stand for Relational Database Management System|
|DBMS application store data as file||RDBMS application stores data in a tabular form|
|Normalization is not present in DBMS||Normalization is present|
|It does not contain relation between table||It contains relation between table|
|It doesn’t apply any security with regards to data manipulation||It define different integrity constrains for the data manipulation|
|It doesn’t support distributed database||It support distributed data base|
|It designed for handling small amount of data, single user in a small organization||It designed to handle large amount of data, multiple users in a large organization|