Data Structures and algorithms

Queue

Overview Of DBMS

    Guys , If you don't know  DBMS. And you are interested in DBMS , Mysql. So this blog will help you to overview the DBMS


             Introduction to DBMS

Before be discuss DBMS, Firstly we need to know what is Data and Database, then we discuss later about DBMS.

What is Data?

In simple words, Data is information it can be any type of information. Ex- Your Name, phone no, address etc.

Nowadays we use many software. Why we use software, because any software is made to manage data.

What is Database?

Database is a collection of files. Let’s take one example - suppose if we create any software application, so a database is a place where all your application related data is stored. And data can be stored in files. So database is a collection of files.

Ex-

·       Record of student stored in files.

·       Information stored over internet.

What is DBMS

DBMS is stands for Database Management System.  It  allows client/users to access data in database. The work to dbms is to interaction between user and database. In other words, Dbms

Is a process of defining (structure) , constructing , manipulating ( fetch , update, delete) and sharing data to users and web applications.

Introduction to RDBMS

It is stands for relational database management system.

It is based on relational model. we know that database is collection of files, when we have small amount of data then we can use dbms , but when we have large amount of data then we use RDBMS , In RDBMS we store our data in Table, which is the collection of rows and columns.

Ex- MySQL, Microsoft Office.

Note:-  Ms office is an example of both DBMS and RDBMS.

RDBMS VS DBMS                 

DBMS	RDBMS
It is collection of files.	It is collection of Tables.
We can’t create relationship.	We can create relationship b/w tables.
It is used in small amount of data.	It is used in large amount of data.
Ex – Xml files.	Ex- MySQL.

Thanks for read  my blog. If any doubt or problem , So guys don't hesitate , ask me. I will try to clear your doubts.