Database Users and Administrators
A primary goal of a database system is to retrieve information from and store
new information into the database. People who work with a database can be
categorized as database users or database administrators.
1. Database Users and User Interfaces
There are four different types of database-system users, differentiated by the way
they expect to interact with the system. Different types of user interfaces have
been designed for the different types of users.
• Na¨?ve users are unsophisticated users who interact with the system by invoking
one of the application programs that have been written previously.
For example, a clerk in the university who needs to add a new instructor to
department A invokes a program called new hire. This program asks the clerk
for the name of the new instructor, her new ID, the name of the department
(that is, A), and the salary.
The typical user interface for na¨?ve users is a forms interface, where the
user can fill in appropriate fields of the form. Na¨?ve users may also simply
read reports generated from the database.
As another example, consider a student, who during class registration
period, wishes to register for a class by using a Web interface. Such a user
connects to a Web application program that runs at a Web server. The application
first verifies the identity of the user, and allows her to access a form
where she enters the desired information. The form information is sent back
to the Web application at the server, which then determines if there is room
in the class (by retrieving information from the database) and if so adds the
student information to the class roster in the database.
• Application programmers are computer professionalswho write application
programs. Application programmers can choose frommany tools to develop
user interfaces. Rapid application development (RAD) tools are tools that enable
an application programmer to construct forms and reportswith minimal
• Sophisticated users interact with the system without writing programs. Instead,
they form their requests either using a database query language or by
using tools such as data analysis software. Analysts who submit queries to
explore data in the database fall in this category.
• Specialized users are sophisticated users who write specialized database
applications that do not fit into the traditional data-processing framework.
Among these applications are computer-aided design systems, knowledgebase
and expert systems, systems that store data with complex data types (for
example, graphics data and audio data), and environment-modeling systems.
2. Database Administrator
One of the main reasons for using DBMSs is tohave central control of both thedata
and the programs that access those data. A person who has such central control
over the system is called a database administrator (DBA). The functions of a DBA
|These Topics Are Also In Your Syllabus|
|1||Introduction to Database Security Issues||link|
|2||Introduction to Database Security Issues||link|
|You May Find Something Very Interesting Here.||link|
|3||The Natural Join||link|