Contents
What is Database Management System?
Database Management System is a software system which manages and retrieves the data from the database. This software package is meant for performing various operations like creation of database, storing of data in it, updating of data, table creation in database and many more.
Database is simply the organized collection of interrelated data at one place. Database organizes the collected data in the form of tables, report and schemas which makes insertion, deletion and retrieval of data from it quite easy. Database Management System provides protection to the database and maintains data consistency in it.
This management system accepts the request for data from the application and then instructs the operating system to provide specific data. Database management system works towards managing three things that are data, the database engine that allows accessing, modifying and locking of data and the data schema, which defines the logical structure of the database. Some common database management system software are: Oracle, FoxPro, MySQL, SQL Server etc.
Advantages of Database Management System
Advantages of Database Management System are as follows:
Improves Data Sharing
Database management system has improved the sharing of data from database. It develops such an environment where users can easily access data and share it among themselves. Database management system authorized the process of accessing data by users. Users have their own right to access the data up to a certain level.
Reduces Data Redundancy
Database management system avoids the duplication of data. Unlike file processing system where the same data is stored at different locations leading to data redundancy, data in database management system is stored and integrated in a single database. It stores data at one single place which avoids any chance of duplicate data.
Proper Data Integration
It integrates the data available at different locations to provide better access and clear picture to users. Integration of data is a key function of database management system as it contains multiple databases in it. It provides a unified view of data to users by combining many files into a single file. Data integration ensures that data is correct and consistent in database.
Maintain Data Consistency
Database management system maintains consistency of data by avoiding redundancy of data. Here all data is stored in a single database at one place. Any changes done in database are reflected immediately in it. All users view the same data in database and avoid any inconsistency. Unlike file processing system, it does not require updating of data again and again at several locations.
Data Security
Database management system protects data of database from unauthorized access. It grants access to database only to authorized users. This system provides users with username and password with which they can authenticate their identity while accessing the database. It helps in avoiding any unauthorized access to database. Database management system keeps database secure, tamperproof and theft free.
Maintains Privacy
It maintains privacy in database by setting the limit to data that can be accessed by users. Database management system applies certain privacy constraints to users for accessing data. It sets different database access levels and everyone can view data up to limit which he is allowed to.
Increase end-user Productivity
Database management system enhances the end-user productivity by providing better information. It has quicken the decision-making process by properly managing the data and improving data sharing. Businesses are able to make quality decisions on time which will improve its productivity and growth.
Data Backup and Recovery
Database management system avoids any data loss problems. This system automatically creates backup and recovery of the database. Unlike traditional file processing system, users are not required to create back up again and again as it performs all these functions automatically. It saves lots of time and resources required for creating backup as in case of traditional file processing system.