What is a database and Secrets of database? Who uses it? What are its benefits?
If all these questions are coming in your mind then you must read this article.
Whether it is a small business, a government organization or a multinational company, a website or a web application, even the games you play in mobile or watch an online video are data everywhere.
Have you ever wondered where all this data is kept and how it is managed?
All these are possible with the help of the database. Today we are going to discuss about this in this article.
What is data?
Before understanding the database, it is important to know what the data is. Data is a small part of any information. It can be a fact related to a person, object or place.
Such as your name, your age, height, weight, mobile number etc. are some data related to you.
Data can be in many different types of formats like text, number, image, file etc.
When these data are processed in a particular form, it becomes information.
What is a database?
A database is a group of many data. These data are stored in the database in an orderly manner so that they can be easily accessed when needed. You know Secrets about database.
You must have used Microsoft Office Excel where we use a table to store data which we divide into several different columns to make our work easier.
Similarly, in the database, the data is stored in a table that contains many columns and rows, which makes them easy to access.
There can be many such tables inside a database.
There can be many examples of this and it is quite difficult to tell about all. We give below some examples where a database is used:
1. Online video streaming:
Whether you watch videos on Youtube or watch your favorite web series on Netflix, every video streaming site uses a database to manage its data, where information from the details of the video to the users watching it also stores. it occurs.
2. Online Gaming:
3. Stock Market:
4. Aadhaar Card:
5. Railway Reservation System:
7. Social Media:
8. Online shopping website:
- It is easy to insert new data, edit and delete old data.
- It is easy to filter data.
- Multiple applications or users can access the same database simultaneously.
- Importing or exporting data from a database table is very easy.
- It provides more security than paper files.
- Reduces Redundancy.
- Keeps programs and data separate from each other.
- It provides features like backup and recovery.
What is the DBMS (Database Management System)?
- Create Database
- Create a table
- Inserting data into a table
- Retrieve Data
- Updating already stored data
- Delete data etc.
- SQL Server
- IBM DB2