- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is RDBMS? Explain its major functions
RDBMS is a relational database management system which is the root for SQL. It is designed totally for relational models. The relational model can be represented on a table with rows and columns. Oracle is an example of RDBMS.
RDBMS is a plan of action and employs a structure which permits to recognize, update and handle the relation database.
It is arranged in tables which contains rows and columns.
Every row in a table is nothing but a record through the unique ID known as key. Employs the normalization (method of arranging data in a database for eliminating the redundancy).
Functions of RDBMS
RDBMS provides the four major functions as listed −
Security
This is one of the most important functions of RDBMS. Security management sets rules that allow accessing the database. This function also sets restraints on what specific data any user can see or write.
Accuracy
In relational database management systems multiple tables are related to one another with the use of primary key and foreign key concepts. This makes data non repetitive so there is no chance for duplication of data. Hence, accuracy of RDBMS is good.
Integrity
Data integrity enforces the three constraints. Entity integrity means a table should have the primary key.
Consistency
The data consistency in relational model is best in RDBMS for maintaining data across application and database copies.
Advantages of RDBMS
The advantages of RDBMS are as follows −
RDBMS is based on rows and columns (table). So it is easier to understand RDBMS work.
RDBMS supports more than one user.
As it is advanced it can easily handle huge amounts of data.
Security is pretty good for RDBMS.
Disadvantages of RDBMS
The disadvantages of RDBMS are as follows −
It is very costly.
Special software is required for RDBMS.
Comparison of DBMS and RDBMS
The major differences between DBMS and RDBMS are as follows −
| DBMS | RDBMS | |
|---|---|---|
| User Availability | It only supports one user at a time. | RDBMS supports more than one user at a time. |
| Security | DBMS doesn’t have any kind of security | There are multiple layers of security in RDBMS. |
| Usage | DBMS is used to handle small amounts of data. | RDBMS is used to handle huge sums of data. |
| Order | Data is stored in forms of files. | Data in RDBMS is stored in the form of tables. |
| Speed | DBMS takes time to load data. | RDBMS loads data faster. |
- Related Questions & Answers
- What are the major functions of capital markets?
- What is type 3 grammar? Explain its properties
- What is OLAP? Explain its advantages and disadvantages
- Where is World Bank situated and what are its functions?
- What is JSON.stringify() and explain its use in javascript?
- What is JSON.parse() and and explain its use in javascript?
- What is definition of business finance and explain its types?
- What is query optimization and explain its two forms(DBMS)?
- What is the hedge ratio? Explain its advantages and disadvantages.
- What is the fetchone() method? Explain its use in MySQL Python?
- What is a single column cash book and explain its format?
- What is an acquisition strategy and explain its types and elements?
- What is a triple column cash book and explain its format?
- RDBMS terminologies
- How MySQL LOCATE() function is different from its synonym functions i.e. POSITION() and INSTR() functions?