GISRSStudy » GIS » Relational Database Management System

Relational Database Management System

What is RDBMS

A Relational Database Management System (RDBMS) is a Database Management System based on relational model introduced by E.F Codd. In relational model data is represents in terms of rows.

A type of database in which data is organized across one or more tables. Tables are associated with each other through common fields called keys. In contrast to other database structures, an RDBMS requires few assumptions about how data is related or how it will be extracted from the database.

Usage

RDBMS is use to manage relational databases. Relational database is a collection of organized set of tables from which data can be access easily.

What is Table

A Relational database’s, table is a collection of data elements organized in trams of rows and columns. A table is a considered as convenient representation of relations. In below an example of marksheet table;

IDNameGenderMarksGrade
001AlexM488AA
002JamesM478+A
003MaryF475+A
004RobertM466A
005ElizabethF459A

RDBMS vs DBMS

RDBMSDBMS
Data stored is in table formatData stored is in the file format
Multiple data elements are accessible togetherIndividual access of data elements
Data in the form of a table are linked togetherNo connection between data
Normalization is present in RDBMS.Normalization is not present in DBMS.
Support distributed databaseNo support for distributed database
Data is stored in a large amountData stored is a small quantity
Here, redundancy of data is reduced with the help of key and indexes in RDBMSData redundancy is common
RDBMS supports multiple usersDBMS supports a single user
It features multiple layers of security while handling dataThere is only low security while handling data
The software and hardware requirements are higherThe software and hardware requirements are low
Example: Oracle, SQL Server.Example: mysql, postgre, sql server, oracle etc.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top