What is RDBMS , Before Knowing concerning info, should be having a Knowledge about What is Database Management System.
Table of Contents
Database – Click Here
What is RDBMS
RDBMS Full Forms – Relational Database Management Systems.
In our generation, All modern database management systems are based on RDBMS.
Example : SQL, MS SQL Server, ORACLE, My-SQL , IBM DB2 and Microsoft Access.
RDBMS also is called Relational Data Base Management System because it is based on relational model which is introduced by E.F. Codd.
How it works :
Data is represented in terms of tuples in RDBMS and tuple also called row.
Relational database is mostly used database. RDBMS contains number of tables and that table has its own primary key.
During collection of organized the set of tables, the data can be accessed easily in RDBMS.
RDBMS Examples :
SQL, MS SQL Server, ORACLE, My-SQL , IBM DB2 and Microsoft Access.
Importance of RDBMS :
We know that a RDBMS means Relational Database Management System is required for manipulating and managing data in proper an efficient manner. So Therefore, many applications and web servers adopted this technology for storing, retrieving, inserting, managing and manipulating their data. This system was working well till the advent of Big Data, so we can easily handled this.
Advantages of RDBMS :
- Easy To Use
- Data Manipulation
- Limied Redundancy
- Better Integrity
- Data Independence
- Multi User Accessable
- Multi Interface
Disadvantages of RDBMS :
- Software is Expensive
- Complex Software
- Requires Skill full Knowladge to Implement
- More Difficult If Data is Lost
- certain Applications are slower processing
What is table :
The RDBMS database to used by tables to store data. A table is a collection of related data which is entries and contains rows and columns to store data.
A table is example of data storage in RDBMS.
What is field :
Field is a smaller entity of the table that is contain perticular information about every record in the table.
What is row or record :
A row of a table is called record and It is contain the perticular information of each individual entry in the table and It is a horizontal entity in a table.
What is column :
Column is a vertical entity in the table that is contain all information which is associated with a specific field in a table.
NULL Values :
The NULL value of the table specified that the field has been left blank during record creation time and It is totally different from the value filled with zero or a field that contains space.
DBMS vs RDBMS :
Different Between DBMS and RDBMS –
- DBMS applications to store data as file.
- Normalization is not present
- Does not used any security with regards to data manipulation
- Uses file system to store data thats why there will be no relation between the tables
- It Does not support distributed database
- This for small organization and deal with small data. it supports to be single user.
- Examples of DBMS is file systems, xml.
- RDBMS application to store data in a tabular form
- Normalization is present.
- Defines the integrity constraint for the purpose of Atomocity, Consistency, Isolation and Durability property.
- RDBMS, data value is stored in the form of tables, so a relationship between these data values will be stored in the form of a table as same.
- Supports distributed database
- It is designed to handle large amount of data. it supports to be multiple users.
- Example of RDBMS is mysql, postgre, sql server, oracle.