Introduction
DBMS stands for Database Management System.
It is used for storing and managing Databases.
DBMS is software, used to create, update, delete, and retrieve data from the database.
The main use of the DBMS is to provide data efficiently and conveniently to the user as well as applications.
Database systems are used to handle large amounts of data..
Before introducing the DBMS, file systems were used to store the data.
The big problem with the file system was that it cannot stores data in a systematic manner and not provides data efficiently.
Another problem with the file system is Security.
There was a lack of security options with the file system and a backup of the database was not present.
So, the DBMS software overcomes all these problems.Example:
Mysql, Oracle, SQL Server, etc. are the example of the DBMS.
Why we use DBMS:
- For rapid application development
- To efficient use of data
- For powerful data administration
- Data integrity and data security
- Recovering the data from the crashes, Concurrent access to the data
- User-friendly language to manage the application
DBMS system allows the Database user to follow systems
Create:-
It allows the user to create. modify, update, and delete the definition of the organization of the data in the database.
Updation:-
It allows users to insertion, modification, and deletion of the actual data in the database.
Retrieval:-
It allows users to retrieve data from the database which can be used by applications for various purposes.
Administration:-
It allows the database administrator registration and monitoring of the users, enforce data security, maintains data integrity, and concurrency control, recovering of the data from corrupted and unexpected failures.
Advantages of DBMS
Reduce the data Redundancy
It reduces data redundancy to save space in the memory.
Data Sharing
Authorized users can share the data with their organization's users.
Easily Maintain
Maintenance of the database is easy because the database is stored in a centralized manner.
Reduces time
It reduces maintenance time as well as development time.
Backup
It provides auto backup and restores the data from the backup due to the Hardware and Software failure, Power failure etc.
Multiple user UI
Provides different types of UI, like GUI and command interface.
Disadvantages of Database
H/W and S/W Cost
It requires higher-speed hardware and a large memory size to run the DBMS software.
Higher impact of failure
Failure is highly impacted due to all data of the many organizations being stored in at single space, so if any hardware failure occurs then all data may be lost permanently.
Applications of DBMS
Airlines: To store the flight information, passenger information, and schedule of the flights.
Telecom: User details, network usage, call details, etc
Universities: Store the student's academic information
Banking: To store the information of the bank customer, account information, and transactions.
Sales: To store the information on purchases, sales, stock,s, etc.
Manufacturing: Production information, suppliers, inventories.
