Users
of DBMS:
Database users are the one who really use and take
the benefits of database. There will be different types of users depending on
their need and way of accessing the database.
1.
Database Administrator (DBA)
2.
Application programmers
3.
System Analyst
4.
End users
1.
Database Administrator (DBA):
Database Administrator (DBA) is the
person or a group of persons who makes the strategic and policy decisions
regarding the data of the enterprise, and who provide the necessary technical
support for implementing these decisions. Therefore, DBA is responsible for
overall control of the system at a technical level. In database environment,
the primary resource is the database itself and the secondary resource is the
DBMS and related software administering these resources is the responsibility
of the Database Administrator (DBA).
2.
Application programmers:
As its name shows, application
programmers are the one who writes application programs that uses the database.
These
users write application programs to interact with the database. Application
programs can be written in some programming language such a C++,VB, ASP, .Net,
JAVA or some higher level fourth generation language. Such programs access the
database by issuing the appropriate request, typically a SQL statement to DBMS. These programs meet the user requirement and made
according to user requirements. Retrieving information, creating new
information and changing existing information is done by these application
programs.
They interact with DBMS
through DML (Data manipulation language) calls. And all these functions are
performed by generating a request to the DBMS. If application programmers are
not there then there will be no creativity in the whole team of Database.
3.
System Analyst:
System Analyst determines
the requirement of end users, especially naive and parametric end users and
develops specifications for transactions that meet these requirements. System Analyst gathers information according to user requirements
needed to develop a solution on it. System Analyst plays a major role in
database design, its properties; the structure prepares the system requirement
statement, which involves the feasibility aspect, economic aspect, technical
aspect etc. of the system.
4.
End users:
End users are those who access the database from the terminal end. End
users are the users, who use the applications developed. End users need not
know about the working, database design, the access mechanism etc. They just
use the system to get their task done. There are
basically two types of end users:
A.
Casual User:
These users have
great knowledge of query language. Casual users access data by entering
different queries from the terminal end. They do not write programs but they
can interact with the system by writing queries.
B.
Naive User:
Any user who does
not have any knowledge about database can be in this category. Their task is to
just use the developed application and get the desired results.
-profshardulp.patil@gmail.com
