RDBMS
Stands for Relational Database Management
System. RDBMS data is structured in database tables, fields and records. Each
RDBMS table consists of database table rows. Each database table row consists of
one or more database table fields.
RDBMS store the data into collection of tables, which might be related by
common fields (database table columns). RDBMS also provide relational operators
to manipulate the data stored into the database tables. Most RDBMS use SQL as database query
language.
Edgar Codd introduced the relational database model. Many modern DBMS do not
conform to the Codd’s definition of a RDBMS, but nonetheless they are still
considered to be RDBMS.
The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL.
Features :
It stores data in tables.
Tables have rows and column.
These tables are created using SQL.
And data from these tables are also retrieved using SQL
Difference between DBMS and RDBMS
|
DBMS |
RDBMS |
|
DBMS stand for Database Management System, which consist n number of tables there is no relationship between another table |
RDMBS stand for Relational Database Management System, which having the relationship with other tables. |
|
The Relationship between tables in DBMS is Physical |
The relationship in RDBMS is Logical. |
|
DBMS does not support Data Integrity |
RDBMS support Data integrity |
|
DBMS does not support Structural Independence and Advanced Query Capabilities |
RDBMS support Structural Independence and Advanced Query Capabilities |
|
DBMS does not support Security |
RDBMS supports Security on Databases. We cannot share data between. |
Data abstraction
- Suppression of details of data organization and storage
- Highlighting of the essential features for an improved understanding of data