DBMS itself is called Database Management System. It is a computer software. With the help of which we can Create, Delete, Update and Manage our database. With the help of database management system, users can access and analyze their data very easily.
What is Database Management System?
Database management system is a system for managing any computer data, in which users can create, delete, access and analyze their data very easily.
Database is a collection of interrelated or similar data, which is called database. And at the same time it helps in keeping the data safe. So that users can access the data easily.
Types of Database Management Systems
There are following types of Database Management System but there are 4 main ones among them:
- Relational Database: In relational database, data related to each other is shown in the form of rows and columns.
- Network Database: In network database, data is kept in the form of records and all the data is linked to each other.
- Hierarchical Database: This type of data is shown in the form of a tree structure, which has Parent and Child.
- Object-oriented Database: In this, data is shown in the form of objects, which is made up of classes and objects.
other types :
- NoSQL Database
- Distributed Database
- Cloud Database
- Operation Database
- Centralized Database
- Data Warehouse
Examples of Database Management System?
- MySQL
- Oracle
- Microsoft SQL Server
- PostgreSQL
- IBM DB2
History of Database Management Systems
The history of database management systems dates back as far as computers, the first database management system software was created at IBM in 1960, which was called IMS (Integrated Management Systems).
This database management system was created for the Apollo program and is still used in many places today.
This database management system was built on the basis of hierarchical database model.
How does a database management system work?
First, the database management system organizes your database files and then provides data access and control to the user.
To do this, it also allows the user of the database management system to make changes in the data of its database files, in which you can create and update any data if needed.
What is the function of database management system?
Database management system has the following functions:
- Data Redundancy: The system has its own personal files which sometimes become duplicate files, avoiding this is called data redundancy.
- Sharing Of Data: In this the data administrator controls the data and allows the user to access the data.
- Data Consistency: The same type of data can be stored in the database through the database management system.
- Integration Of Data: In this it is easy to retrieve and update the data.
- Data Security: In the database management system, the data is completely controlled by the data administrator, which increases the security of the database.
- Remove Procedures: In this, data can be recovered easily.
- Accessing data: DBMS allows users to access data in a secure and efficient manner.
- Organizing data: DBMS helps in organizing data into tables, indexes and other structures.
Applications of Database Management System
- In Bank: Used to store customer information, loan information etc.
- In Bank: Used to store customer information, loan information etc.
- In College and School: Used to store student information and teacher information.
- In telecommunication: Used to store call records, bill and balance information.
- In Finance: Used to store information about stock, sales, and purchases.
- In Sales: Used to store customer, product and sales information.
- In Manufacturing: Used for supply chain management and tracking the product.
- In HR management: Used to store information about employees, salary, payroll and paycheck etc.
What are the basic components of database management system?
- Software
- Hardware
- Data
- Database Access Language
- Query Processor
- Run Time Database Manager
- Data Manager
- Database Engine
- Data Dictionary
- Report Writer
Features of Database Management System:
Following are the features of Database Management System:
- The main feature of database management system is to prevent data duplication and redundancy.
- Database management systems also provide backup and recovery facilities.
- Database management systems can handle large amounts of data.
- Database management system saves on storage and expenses.
- Database management system provides high level security to users and data.
- Any user can work on the database management system.
- Database management systems allow users to create, modify, and delete database objects.
- Database management systems allow users to insert, update, delete, and retrieve data from the database.
- The database management system ensures that the database remains in a consistent state even in case of system failure or interruption.
Benefits of Database Management System:
Following are the benefits of Database Management System:
- Database Management System It is easy to search and retrieve data in the system.
- Data sharing is done very easily.
- Database management systems allow very thorough data integration.
- Database management system provides a strong security to protect the data.
- Database management system helps in providing quick access to frequently accessed data.
- It enables data sharing between users and applications.
- Connects different types of data to a single database.
Disadvantages of Database Management System:
Database management system also has the following disadvantages:
- Database management system is a difficult process and it is not easy to implement.
- The possibility of error in the database also becomes very high.
- To create a database management system, both hardware and software are required.
- To improve the efficiency of the database system, the system has to be kept running.
- Database management system is a difficult software as it requires technical expertise to configure and maintain it.
- It requires system resources such as memory, CPU and disk space.
- There are difficulties in data transfer.
What are the characteristics of database management system?
Following are the characteristics of Database Management System?
Being of self describing nature.
- Having Program Data Independence.
- It supports multiple views data.
- Sharing of database can happen between multiple users.
What are the functions of database management system?
- Create Data: Data is created through DBMS.
- Manage Data: In this the data is managed.
- Update Data: In this, data can be updated as per requirement.
- Delete Data: In this, the data which is not needed is deleted.
- Data Backup: Data can be backed up in this.
- Data Recovery: In this, data is recovered in case of system failure.
- Also Read This:- what is database schema with example
- Also Read This:- What are the features of MS Word?
- Also Read This:- What is osi model in computer network
- Also Read This:- What is System Planning?
FAQs:
DBMS itself is called Database Management System. It is a computer software. With the help of which we can Create, Delete, Update and Manage our database. With the help of database management system, users can access and analyze their data very easily.
Data Base Management System is a software, which is used to create and manage the database.