- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What do you mean by data base management system (dbms)?
The Database Management System (DBMS) is defined as a software system that allows the user to define, create and maintain the database and provide control access to the data.
It is a collection of programs used for managing data and simultaneously it supports different types of users to create, manage, retrieve, update and store information.
A small startup company and industries managing a huge amount of data becomes a mess. So, software like DBMS brought a revolution in many fields regarding efficient information management.
It is basically a set of programs which allow users to store, modify or update, and retrieve information from the database as per the user requirements.
DBMS also provides security and protection to databases. It acts as a middle layer between the database and user.
The different types of DBMS are My SQL, Oracle, MYSQL Server, Microsoft Access, SQL, DB2 etc.
Functions of DBMS
The functions of DBMS are explained below −
The motive behind the development of the DBMS is to manage the information as a whole.
Its main objective is to make the data easily accessible, rapid, less costly and flexible for its users.
It removes the duplication of data and minimizes data redundancy.
The extra space covered by duplicate data is used for other purposes and there is no wastage of space.
The DBMS is easy to use and learn.
DBMS packages are user-friendly and flexible.
There is data independence because the user can do changes at any level of the database without impact on other levels like hardware and software processes.
DBMS is economically good for everyone.
Anyone can use, store and manipulate data at an affordable price.
It can be accessible by multiple users and helps to recover data in case it is not saved by the user. The system can easily recover the data in no time and it maintains accuracy and integrity.
It prevents unauthorized access to the data and the data remains private. Through centralized control, DBMS makes it sure that proper security is provided to the data.
It is useful for retrieving, analyzing and storing the data.
The diagram given below depicts the working of a DBMS −
- What do you mean by schedule in DBMS?
- What do you mean by C++ Tokens?
- What do you mean by corporate culture?
- What do you mean by compliance specialist?
- What do you mean by Teen Stress?
- What do you mean by performance testing?
- Database Management System (DBMS)
- What do you mean by timeOut in TestNG?
- What do you mean by Listeners in TestNG?
- What do you mean by glue in Cucumber?
- What do you mean by congestion control algorithm?
- What do you mean by interfaces and services?
- What do you mean by Scenario Outline in Cucumber?
- What do you mean by default constructor in Java?
- What do you mean by buffer in C language?