RDBMS (Relational Database Management System)

An RDBMS is a software system used to manage relational databases. It provides the tools for creating, managing, and interacting with a database that stores data in a structured format, typically in tables with rows and columns. The “relational” part refers to the way data is stored in tables (relations) and how relationships between data are established using keys.

• Key Features of RDBMS:
  • Tables: Data is stored in tables (relations) with rows (records) and columns (fields).
  • Keys: RDBMS uses keys like primary keys and foreign keys to establish relationships between tables.
  • Normalization: The process of organizing data to avoid redundancy and improve data integrity.
  • ACID Properties: Ensures transactions are processed reliably (Atomicity, Consistency, Isolation, Durability).
  • Data Integrity: Ensures accuracy and consistency of the data through constraints like NOT NULL, UNIQUE, etc.
  • Concurrency Control: Manages multiple users accessing the database simultaneously.
• Examples of RDBMS:
  • MySQL
  • PostgreSQL
  • Oracle Database
  • Microsoft SQL Server
  • IBM Db2

 

Aspect	RDBMS	SQL
Definition	Software system that manages databases and provides tools for data storage and manipulation.	A language used to interact with databases, specifically for querying and managing data.
Functionality	Manages and stores data in tables, maintains relationships, enforces integrity, and ensures transactions are handled correctly.	Provides a set of commands (queries) to interact with the data inside an RDBMS.
Role	It is the platform (or software) that allows data management using SQL.	It is the language used to operate on data within the RDBMS.
Example	MySQL, PostgreSQL, Microsoft SQL Server, Oracle	SELECT, INSERT, UPDATE, DELETE, etc.
Focus	Manages database structure, storage, and integrity.	Provides a syntax for querying and manipulating data.