Friday, July 19, 2019

Introduction of DBMS(Database Management System)

Introduction of DBMS(Database Management System)

Data: -

Data is a facts and statistics stored or free flowing over the network. Generally, it is row and unprocessed.

For example: -
If you have a website and it has login or sign up system then the user fills the information for login the website to access more and more feature. So, here the information of the user is called as data.

Database: -

A database is a collection of data which is organized in a way that can be easily accessed, managed and updated or modify. In the database we can select the desired data quickly and easilyDatabase will be Software based or hardware based with one sole purpose storing Data.
During early computer days, information was collected and keep on tapes that were mostly write only. Which means once information is store on it, it can never be read again. They are slow and bulky.

DBMS(Database Management System): -

The full name of DBMS is Database Management System. A DBMS is a collection of programs or a software that allows user to creation definition and manipulation or updation of database.
Allowing user to store process and access, analyses data easily, (DDL/DML)DBMS provides us a tool to perform various operations or task like making Database, storing information on it, change data, creating table within the database and lot of things.
DBMS also provides security or protection to the database. It also maintains data consistency in case of multiple user.

For example: -
Suppose, You are the user of Facebook and you sign in in your account, It’s possible by the DBMS (Database Management system) because all the information’s of user is stored or managed by the DBMS software. Your username and password will work by the DBMS software.

Here are some examples of DBMS: -

These are the DBMS software which is used at this time
MySQL, Oracle, Sql server, IBM DB2, Amazon simple DB
DDL- Data Definition Language (Creation of table)
DML- Data Manipulation language (Sql server) searching, sorting.

Next Topic ➧ Characteristics of DBMS

No comments:

Post a Comment