Understanding Database Management System (DBMS).
                     Understanding Database 
Management System (DBMS)
What is Database?
• The database is a collection 
of inter-related data which is 
used to retrieve, insert and 
delete the data efficiently. 
• It is also used to organize 
the data in the form of a 
table, schema, views, and 
reports, etc.
Source: www.javatpoint.com
Database Management System
• Database management 
system is a software which is 
used to manage the 
database. 
• For example: MySQL, Oracle, 
etc are a very popular 
commercial database which 
is used in different 
applications.
Source: www.javatpoint.com
DBMS allows users the following tasks
• Data Definition: It is used for 
creation, modification, and 
removal of definition that 
defines the organization of data 
in the database.
• Data Updating: It is used for the 
insertion, modification, and 
deletion of the actual data in the 
database.
• Data Retrieval: It is used to 
retrieve the data from the 
database which can be used by 
applications for various 
purposes.
• User Administration: It is used 
for registering and monitoring 
users, maintain data integrity, 
enforcing data security.
Source: www.javatpoint.com
Characteristics of DBMS
• It uses a digital repository 
established on a server to 
store and manage the 
information.
• It can provide a clear and 
logical view of the process 
that manipulates data.
• DBMS contains automatic 
backup and recovery 
procedures.
• It contains ACID properties 
which maintain data in a 
healthy state in case of 
failure.
Source: www.javatpoint.com
Characteristics of DBMS Cont.
• It can reduce the complex 
relationship between data.
• It is used to support 
manipulation and processing 
of data.
• It is used to provide security 
of data.
• It can view the database 
from different viewpoints 
according to the 
requirements of the user.
Source: www.javatpoint.com
Advantages of DBMS
• Controls database 
redundancy: It can control 
data redundancy because it 
stores all the data in one 
single database file and that 
recorded data is placed in 
the database.
• Data sharing: In DBMS, the 
authorized users of an 
organization can share the 
data among multiple users.
Source: www.javatpoint.com
Advantages of DBMS Cont.
• Easily Maintenance: It can 
be easily maintainable due 
to the centralized nature of 
the database system.
• Reduce time: It reduces 
development time and 
maintenance need.
• Multiple user interface: It 
provides different types of 
user interfaces like graphical 
user interfaces, application 
program interfaces
Source: www.javatpoint.com
Disadvantages of DBMS
• Cost of Hardware and 
Software: It requires a high 
speed of data processor and 
large memory size to run 
DBMS software.
• Size: It occupies a large 
space of disks and large 
memory to run them 
efficiently.
Source: www.javatpoint.com
Disadvantages of DBMS Cont.
• Complexity: Database 
system creates additional 
complexity and 
requirements.
• Higher impact of failure: 
Failure is highly impacted 
the database because in 
most of the organization, all 
the data stored in a single 
database and if the 
database is damaged due to 
electric failure or database 
corruption then the data 
may be lost forever.
Source: www.javatpoint.com
Applications of DBMS
• Multiuser and Concurrent 
Access DBMS supports multi-
user environment and allows 
them to access and 
manipulate data in parallel.
• Multiple views − DBMS 
offers multiple views for 
different users. 
• Security − Features like 
multiple views offer security 
to some extent where users 
are unable to access data of 
other users and 
departments. 
Source: www.javatpoint.com