Late Night Chronicles: #2 Diving into RDBMS

In the previous post, I talked about Data, Databases, DBMS , and their limitations. But today, let’s talk about the solution to those problems 👇 🧠 What is RDBMS? RDBMS (Relational Database Management System) is a type of DBMS where data is stored in a structured format using tables (rows and columns) . 👉 Unlike traditional file systems, RDBMS follows Row Level Locking System. 📌 Definition (ANSI) A software system that manages data organized into tables with rows and columns , allowing for ACID-compliant transaction 🧰 Examples of RDBMS Software Some commonly used RDBMS tools are: Oracle MySQL MS SQL Server PostgreSQL DB2 Sybase Informix (Fastest in terms of Processing Speed) 📂 Basic Concepts in RDBMS Column (Attribute / Key / Method) → Represents a property (e.g., Name, ID) Row (Tuple / Entity / Opportunity) → A single record (e.g., one student’s data) Table (Relation / Entity Class / Applet ) → Collection of rows and columns 👉 In simple words: Table = Structure Row = Data Column = Prop