12 Differences between DBMS And RDBMS

-
COMPARISON OF DBMS & RDBMS


Fig Credit : vsionhub123.blogspot.com

DBMS :-

A DBMS is a software used to store and manage data. The DBMS was introduced during 1960's to store any data. It also offers manipulation of the data like insertion, deletion, and updating of the data.


DBMS system also performs the functions like defining, creating, revising and controlling the database. It is specially designed to create and maintain data and enable the individual business application to extract the desired data.

Fig Credit : vsionhub123.blogspot.com

RDBMS :-


Relational Database Management System (RDBMS) is an advanced version of a DBMS system. It came into existence during 1970's. RDBMS system also allows the organization to access data more efficiently then DBMS. RDBMS  is Also the  type of DBMS which is based on the Relational Model.


RDBMS is a software system which is used to store only data which need to be stored in the form of tables. In this kind of system, data is managed and stored in rows and columns which is known as tuples and attributes. RDBMS is a powerful data management system and is widely used across the world.

Fig Credit : vsionhub123.blogspot.com


Comparison Between DBMS & RDBMS  :-

Fig Credit : vsionhub123.blogspot.com


PARAMETERS
DBMS
RDBMS
Full  Form
Data Base Management System
Relational Data Base Management System

Definition
 DBMS is a software application that acts as an interface between the user, various applications and the database for the purpose of analyzing and storing the data.

It is a software which is used to store only that data which can be stored in the form of tables (also called relations). Data is managed and stored in rows and columns also known as tuples and attributes respectively
Data Size
Small  data
Large data

Store Data
Store  Data as Files internally
Store Data as Tables internally
Users
Single users
Multi – users

Normalization Process
Not Present
Present

Distributed Database  
Not Support Distributed Database  
Support Distributed Database

   
Redundancy
Common in this model
Keys and Indexes doesn’t  allow redunadncy
Security
No
Multiple levels of security
Relation
No Relation  
Relation between Tables

Examples
FoxPro  , IMS ,.xml etc
SQL Server , MySQL ,Oracle etc











Comments

Post a Comment

cloud computing

DATA ABSTRACTION VS DATA ENCAPSULATION

-
Image
COMPARISON BETWEEN DATA ABSTRACTION  VS DATA ENCAPSULATION Fig. Credit :  knowledge hub DATA ABSTRACTION  :- Data Abstraction is the showing of only necessary details of the object   and Hiding   the unnecessary and unwanted details . For example ,  just like how a car shows  but hides the circuitry/ implementation. Fig. Credit :  knowledge hub   DATA ENCAPSULATION  :- Wrapping of data just hiding properties and methods. The data should not go out directly  i.e. outside person is not allowed to access the data .For example , just   like how the implementations of bank account details are hidden from the banker . Fig. Credit : knowledge hub DIFFERENCE BETWEEN DATA ABSTRACTION  VS DATA ENCAPSULATION :- Fig. Credit :  knowledge hub Parameters Data Encapsulation Data Abstraction Definitio...
Read more

Iaas(Infrastructure as a service )

-
Image
Iaas FULL FORM :- Infrastructure as a service  . Fig. Credit :  visionhub123.blogspot.com DEFINITION :- ·         There are three main categories of cloud computing services are Iaas(Infrastructure as a service   ), platform as a service ( PaaS ) and software as a service ( SaaS ) .                                              ·         IaaS (Infrastructure as a Service), as the name suggests, provides you the computing infrastructure, physical virtual machines and other resources like virtual-machine disk image library, block and file-based storage, firewalls, load balancers, IP addresses, virtual local area networks etc. ·     ...
Read more