Open In App

RDBMS Architecture

Last Updated : 09 Jun, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

RDBMS stands for Relational Database Management System and it implements SQL.
In the real-world scenario, people use the Relational Database Management System to collect information and process it, to provide service. E.g. In a ticket processing system, details about us (e.g. age, gender) and our journey (e.g. source, destination), are collected, and the ticket is provided to us.

RDBMS Architecture :

Note –
Each term in the diagram is explained below in the point number associated with the term.

  1. All data, data about data (metadata) and logs are stored in the Secondary Storage devices (SSD), such as Disks and Tapes.The programs that are used to do the day-to-day tasks of an enterprise are called Application programs. These programs provide the functionality for the day-to-day operations of the enterprise. They are written in high level languages (HLL) like Java, C etc, which along with the SQL, are used to communicate with the databases.
  2. RDBMS has a compiler that converts the SQL commands to lower level language, processes it and stores it into the secondary storage device.
  3. It is the job of Database Administrator (DBA) to set up the structure of the database using command processor. The DDL stands for Data Definition Language and is used by the DBA to create or drop tables, add columns etc. The DBA also uses other commands which are used to set constraints and access controls.
  4. Application Programmers compile the applications using a compiler and create executable files (compiled application programs) and then store the data on the secondary storage device.
  5. Job of Data Analyst is to use the Query Compiler and Query Optimizer (uses relational properties for executing queries) to manipulate the data in the database.
  6. RDBMS Run Time System executes the compiled queries and application programs and also interacts with the transaction manager and buffer manager.
  7. Buffer Manager temporarily stores the data of the database in the main memory and uses paging algorithm so that operations can be performed faster and the disk space can be managed.
  8. Transaction Manager deals with the principle of either completely doing a task or not doing it at all (Atomicity property). E.g. Suppose a person named Geeks, wants to send money to his sister. He sends the money and system crashes in between. In no case should it happen that he has sent money but his sister has not received it. This is handled by the transaction manager. The transaction manager would either refund the money to Geeks or transfer it to his sister.
  9. Log is a system, which records the information about all the transactions, so that whenever a system failure (disk failure, system shut down due to no power etc.) arises, the partial transactions can be undone.
  10. Recovery Manager takes control of the system so that it reaches a steady state after failure. The Recovery Manager takes into account the log files and undoes the partial transactions and reflects the complete transaction in the database.

Similar Reads

Difference between RDBMS and HBase
RDBMS (Relational Database Management System) and HBase are both types of database management systems, but they differ in several ways: Data Model: RDBMS uses a relational data model, where data is stored in tables with predefined columns and rows. HBase, on the other hand, uses a column-family data model, where data is stored in column families, w
5 min read
Difference between RDBMS and OODBMS
RDBMS: RDBMS stands for Relational Database Management System. It is a database management system based on the relational model i.e. the data and relationships are represented by a collection of inter-related tables. It is a DBMS that enables the user to create, update, administer and interact with a relational database. RDBMS is the basis for SQL,
2 min read
Difference between RDBMS and MongoDB
MongoDB is an open-source document-oriented database used for high volume data storage. It falls under the classification of a NoSQL database. NoSQL tool means that it doesn't utilize the usual rows and columns. MongoDB uses BSON (document storage format) which is a binary style of JSON documents. Features of MongoDB: Multiple Servers: It can run o
2 min read
Difference between RDBMS and Hive
RDBMS: RDBMS stands for Relational Database Management System. RDBMS is a such type of database management system which is specifically designed for relational databases. RDBMS is a subset of DBMS. A relational database refers to a database that stores data in a structured format using rows and columns and that structured form is known as table. Th
2 min read
Difference between ER Model and RDBMS
1. ER (Entity- Relationship) Model : ER model stands for entity relationship model. It specifies the structure of a database by giving the relationship between the entities of the system. An entity set is a group of entities that are similar to each other. It is considered as a conceptual design which can further be used to implement a database. It
2 min read
Difference Between RDBMS and Hadoop
RDMS (Relational Database Management System): RDBMS is an information management system, which is based on a data model.In RDBMS tables are used for information storage. Each row of the table represents a record and column represents an attribute of data. Organization of data and their manipulation processes are different in RDBMS from other databa
2 min read
Difference between RDBMS and Couchbase
1. RDBMS : RDBMS stands for Relational Database Management Systems. It is most popular database. In it data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily access because data is store in the table. This Model was proposed by E.F. 2. Couchbase : Couchbase Server is an open-source, distrib
2 min read
Difference between RDBMS and IBM DB2
1. RDBMS : RDBMS stands for Relational Database Management Systems. It is most popular database. In it data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily access because data is store in the table. This Model was proposed by E.F. 2. IBM Db2 : IBM Db2 is a family of data management produc
2 min read
Difference between Cassandra and RDBMS
Cassandra: Cassandra is a high-performance and highly scalable distributed NoSQL database management system. Cassandra deals with unstructured data and handles a high volume of incoming data velocity. In Cassandra data is written in many locations also data come from many locations this row represents a unit of replication and the column represents
2 min read
Difference Between RDBMS and DBMS
Database Management System (DBMS) is a software that is used to define, create, and maintain a database and provides controlled access to the data. Why is DBMS Required?Database management system, as the name suggests, is a management system that is used to manage the entire flow of data, i.e, the insertion of data or the retrieval of data, how the
4 min read