- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
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 −
- Related Articles
- What do you mean by schedule in DBMS?
- What do you mean by starch?
- What do you mean by adolescence?
- What do you mean by heat?
- What do you mean by tissue?
- What do you mean by environment?
- What do you mean by Garbage?
- What do you mean by Propagation?
- What do you mean by Silk?
- What do you mean by Sex?
- What do you mean by disease?
- What do you mean by Nutrients?
- What do you mean by Obesity?
- What do you mean by Ruminants?
- What do you mean by Roughage?