Database Users

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 2

DATABASE USERS & DATABASE ADMINISTRATORS:

People who work with a database can be categorized as database users or database administrators.

Database Users:
There are four different types of database-system users, differentiated by the way they expect to interact with the
system.

Naive users:
Naive users are unsophisticated users who interact with the system by invoking one of the application programs that
have been written previously.

Application programmers:
Application programmers are computer professionals who write application programs. Application programmers can
choose from many tools to develop user interfaces. Rapid application development (RAD) tools are tools that
enable an application programmer to construct forms and reports without writing a program.

Sophisticated users:
Sophisticated users interact with the system without writing programs. Instead, they form their requests in a database
query language. They submit each such query to a query processor, whose function is to break down DML
statements into instructions that the storage manager understands. Analysts who submit queries to explore data in the
database fall in this category.

Specialized users:
Specialized users are sophisticated users who write specialized database applications that do not fit into the
traditional data-processing framework.

Database Administrator:
One of the main reasons for using DBMSs is to have central control of both the data and the programs that access
those data. A person who has such central control over the system is called a database administrator (DBA).

Database Administrator Functions/Roles:


The functions of a DBA include:

Schema definition:
The DBA creates the original database schema by executing a set of data definition statements in the DDL, Storage
structure and access-method definition.

Schema and physical-organization modification:


The DBA carries out changes to the schema and physical organization to reflect the changing needs of the
organization, or to alter the physical organization to improve performance.

Granting of authorization for data access :


By granting different types of authorization, the database administrator can regulate which parts of the database
various users can access. The authorization information is kept in a special system structure that the database system
consults whenever someone attempts to access the data in the system.

Routine maintenance:
Examples of the database administrator’s routine maintenance activities are:
1. Periodically backing up the database, either onto tapes or onto remote servers, to prevent loss of data in case of
disasters such as flooding.

2. Ensuring that enough free disk space is available for normal operations, and upgrading disk space as required.
3. Monitoring jobs running on the database and ensuring that performance is not degraded by very expensive tasks
submitted by some users.

You might also like