DataBase Management System (DBMS)
A DBMS is a software that allows us to create,
define and manipulate database, allowing users to store, process and analyze
data easily. DBMS provides us with an interface or a tool, to perform various
operations to create a database, storing of data and for updating data, etc.
DBMS also provides protection and security to the databases. It also maintains
data consistency in case of multiple users.
Examples of DBMS softwares are : Foxpro, dbase.
1. Data stored into Tables
Data is never directly stored into the
database. Data is stored into tables, created inside the database. DBMS also
allows to have relationship between tables which makes the data more meaningful
2. Reduced Redundancy
In the modern world hard drives are very cheap,
but earlier when hard drives were too expensive, unnecessary repetition of data
in database was a big problem But DBMS follows Normalisation which divides the
data in such a way that repetition is minimum.
On live data, it is being continuously updated
and added, maintaining the consistency of data can become a challenge. But DBMS handles it by itself.
4. Support Multiple user and
DBMS allows multiple users to work on
it(update, insert, delete data) at the same time and still manages to maintain
the data consistency.
DBMS provides users with a simple query
language, using which data can be easily fetched, inserted, deleted and updated
in a database.
The DBMS also takes care of the security of
data, protecting the data from unauthorized access. In a typical DBMS, we can
create user accounts with different access permissions, using which we can
easily secure our data by restricting user access.
7. DBMS Supports Transactions
It allows us to better handle and manage data
integrity in real world applications where multi-threading is extensively used.
Segregation of application program
Minimal data duplication or Data Redundancy
Easy retrieval of data using the Query Language
Reduced development time and maintenance
The Database Management System can be divided
into five major components as follows:
4 . Procedures / Methods
5.Database Access Languages
Hardware: The computer, hard disk, I/O channels for data, and any other physical component
involved in storage of data
Software: This main component is a program that controls everything. The DBMS software
is capable of understanding the Database Access Languages and interprets into database commands for execution.
Data: It is that resource for which DBMS is designed. DBMS creation is to store and utilize
They are general instructions to use a database
management system such as installation of DBMS, manage databases to take
backups, report generation, etc.
Languages: They are the languages used to write
commands to access, insert, update and delete data stored in any database.
Examples of popular DBMS: Dbase, FoxPro