Free Web Development Online Tutorials, Learn to Code
Learn Relational database management system SQL Database, What is RDBMS? MS SQL Tutorial Online

SQL RDBMS Concept

What is RDBMS?

RDBMS Stands for Relational Database Management System Overview.

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.

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
Comment
Name
Email
Website
Subscribe