Database Management System (also known as DBMS) is software
for storing and retrieving users' data by considering appropriate security
measures. It allows users to create their own database as per their
requirement. It consists of a group of programs which manipulate the database
and provide an interface between the databases. It includes the user of the
database and other application programs. The DBMS accepts the request for data
from an application and instructs the operating system to provide the specific
data. In large systems, a DBMS helps users and other third-party software to
store and retrieve data. "A database management system (DBMS) is a
collection of programs that manages the database structure and controls access
to the data stored in the database". A DBMS makes it possible for end
users to create, read, update and delete data in a database. The DBMS
essentially serves as an interface between the database and end users or
application programs, ensuring that data is consistently organized and remains
easily accessible. A database management system (DBMS) is system software
for creating and managing databases. The DBMS provides users and programmers
with a systematic way to create, retrieve, update and manage data. DBMS examples
include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle,
RDBMS, dBASE, Clipper, and FoxPro.
Advantages of DBMS:-
Minimize Data Redundancy: In File Processing System,
duplicate data is created in many places because all the programs have their
own files. This creates data redundancy which in turns wastes labor and space.
In Database Management System, all the files are integrated in a single
database. The whole data is stored only once at a single place so there is no
chance of duplicate data.
Sharing of Data: In DBMS, Data can be shared in
between authorized user of database. All the users have their own right to
access the database up to a level. Database Administration has complete access
of database. He can assign users to access the database. Others users are also
authorized to access database and also they can share data between them. Many
users have same authority to access the database.
Data Consistency: DBMS controls data redundancy which
in turn controls data consistency. Data consistency means if you want to update
data in any files then all the files should not be updated again. As in DBMS,
data is stored in a single database so data becomes more consistent in
comparison to file processing system. Also updated values are available to all
the users immediately.
Data Integrity: Data integrity means unification
of so many files into a single file. In DBMS data is stored in different
tables. A database contains different tables that are linked to each other.
Many users feed entries in these tables so it is important to maintain data
items and association between data items. DBMS allows data integrity that makes
it easy to decrease data duplicity Data integration reduces redundancy as well
as data inconsistency.
Security: Data security means protecting your precious data
from unauthorized access. Data in database should be kept secure and safe to
unauthorized modifications. Only authorized users should have the grant to
access the database. There is a username set for all the users who access the
database with password so that no other guy can access this information. DBMS
always keep database tamperproof, secure and theft free.
Development of new applications: If a new
application is required and data is available for creating the application then
it is very easy to develop new application. No time will be consumed in
creating stored data again and again.
User questions & answers