What is RDBMS?

Oracle, MS-SQL database are the example of RDBMS, RDBMS Stands for Relational Database Management System, which indicates any large database system that allow to store data in a structured way.

Every RDBMS system must have some standard properties and follow some basic principles.

ACID Properties of RDBMS

Any relational database management system (RDBMS) must have ACID properties; ACID stands for Atomicity, Consistency, Isolation, and Durability, let’s look at following properties more at details.

ACID properties are designed to handle any transaction in any state.

  • Atomicity
  • Consistency
  • Isolation
  • Durability
What is Data and Data Storing?

Logically every single facts or figures about any information are data, information about anything and everything. We can store such facts or figures about information in notepad, word file, excel file, ms access, power point or in any other storage capabilities, we call them data store.

SQL RDBMS Concept

SQL Stands for”Structured Query Language”, which is programming language used in database programming, now often we term SQL as database , some people say “S-Q-L” , some says sequel, what we try to mean is, the MS-SQL , which is a RDBMS! Now more or less all RDBMS system use sql as programming language, now syntax may differ from one RDBMS to another.

Relational Database Management System

Relational database management system (RDBMS) is a set of components with capabilities to enable user to easy access, create and manage data using Structured Query Language (SQL).

In RDBMS you can Create, Read, Update and Delete data, check authentication and authorization for each user in very systematic way. SQL RDBMS has many built-in components and objects to carry out such activities. An RDBMS may also provide capability of displaying visual representation of the data.

Most of the well known Database applications fall into RDBMS category. Examples database like MySQL, Oracle Database, Microsoft SQL Server, and IBM DB2 etc.

Any databases that are managed by other DMBS programs that support NoSQ, fall under Non-RDBMS category. Like Oracle NoSQL DB.

rdbms concept

RDBMS Characteristics
  • All data stored in the tables
  • It ensures that all data stored are in form of columns and rows
  • Each table can have primary key, which helps in unique identification of any rows in that table
  • There can be relationships among two or multiples tables (usually done with help of Foreign Keys)
  • It allows indexing (Cluster and Non-Cluster) and faster retrieval of data at any point of time
  • Supports Transaction (with different Isolation Level)
  • Data can be managed and controlled by multiple user with different set of user roles
 
Hire SQL Developer
What is RDBMS!
SQL Training: For any group or corporate training, please contact us at webtrainingroom(at)gmail.
SQL job Interview Questions Answers
Course in Demand
SQL database development tutorials for learning sql query, data manipulation language, working with MS SQL Server.
RDBMS Concept
MS SQL Examples | Join MS SQL Course