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.
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.
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 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 (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.