What is dbms write its advantages and disadvantages
Definition of DBMS: The full form of DBMS is Database management system. The most important part of the database is the Data, whether it’s for the purpose of maintaining records of school students or office employees etc. Before the onset of computers this data was stored manually in papers. But after computerization, DBMS system software has been used. The full form of DBMS is Database management system which means that system which manages the data. Collection of Data is known as Database which is stored in an organized way. DBMS is a system software which is a collection of many programs. Programmers and users can systematically create, modify, update or retrieve data in a systematic way with the help of DBMS. DBMS has more advantages than traditional computer file-based processing approach. Read – What is DBMS in Hindi
In simple language, DBMS is an interface between Data and users. It makes sure data is accessed in consistent and organized manner. Nowadays many Database management system is available which are made for small systems i.e. personal computers to big systems or supercomputers. An important function of Database is to manage Database Schema. Since the launch of DBMS, there have been many updates. Example of DBMS are Microsoft SQL Server, MS Access, MYSQL, Oracle Database, SQLite, dBase, Foxpro, IBM Informix, Firebird etc.
DBMS manages three important things which are Data, Database engine and Database Schema. Data operations like Data access, modification, locked etc can be performed with the help of Database engine. Database Schema defines logical structure of Database. These three fundamental elements of DBMS provide element concurrency, security, data integrity and uniform administration. Other than this some more tasks supported by DBMS are change management, performance monitoring, toning, backup and recovery. Real life examples of Databases are library system, banking database, flight and railway reservation systems, inventory systems etc.
Important functions of DBMS –
- Concurrency control system – If many users access the database at a time then it ensures data is accessible.
- Data storage management – It provides mechanism for data storage.
- Authorization and Security – Security rules are defined for users access.
- Data definition services – DBMS accepts data definitions like internal schema, external schema etc.
- Reduce Redundancy
- Better Data Integration
- Data Sharing
- Data standard
- Data Backup and Recovery
- Better Speed
- Better Performance
- Increase Productivity
- The higher cost of DBMS software
- Dependency increase on computer and DBMS expert
- Increased Cost