Components of DBMS:
Every component plays a
vital role in database management. These components are:
1.
Data:
A data can be defined as a
collection of raw facts and figures. The
term database is referred as a collection of the related data. The data is a
key component and for the management of it the DBMS works.
2.
Software:
It includes both types of
software viz. system and application software that are used to work on a
database. The software is set of instruction required to manage, maintain and
work with data. It also provides an interface between the user and a database.
3.
Hardware:
The hardware includes CPU as
well as other peripheral devices such as monitor, keyboard, hard disk, printer,
etc. These are required for input, processing and output purposes.
4.
User:
It includes all types of
users that are benefited by the DBMS. Following are the various types of users
commonly associated with a DBMS:
a) The DBA (Database Administrator) is a
person or group of persons that have the central control over the DBMS. They
are in charge of implementing the system within an organization. Further, they
have all the system privileges and it is they decide access permissions for
other users to access the database system.
b) The end users are persons who sit at
workstations and interact with the system. They may need to respond to requests
from people that are outside of an organization, or to find answers to the
questions quickly asked by higher level management. In some cases they may
generate periodic reports. If required, they should be allowed to change data
within the system.
c) Direct users are
those users that use the database system directly by following instructions
provided in an interface. Such users interact with system using applications
that are already developed.
d) Indirect users
work with the DBMS indirectly. They commonly use output generated programs for
decision making.
e) The application programmers interact with
the system using HLL such as VB, Java, C#.Net etc. they access the data from
programs written using such HLL.
5. Procedures:
Procedures are instructions and rules that assist on how to use the DBMS, in its design and running the database. They serve as a guide to the users that operate and manage it.
very helpfull
ReplyDelete