Table of Contents
In this article, you’ll learn about Different types of Database Users like Database Administrator (DBA), Naive / Parametric End Users, System Analyst and more.
Any user who uses database and takes benefits from the database is considered a Database Users. They can be programmers, scientists, engineers, business person or can be an employee.
Different types of Database Users
Database users in DBMS can be categorized based on their interaction with the databases. According to the tasks performed by the database users on the databases, we can categorize them into seven categories as follows:
- Database Administrators (DBA)
- Database Designers
- System Analysts
- Application Programmers / Back-End Developers
- Naive Users / Parametric Users
- Sophisticated Users
- Casual Users / Temporary Users
Let’s understand about each of them in brief,
Who are Database Designers?
Database Administrator (DBA) is a person/team who is responsible for managing the overall database management system. i.e. the schema and also controls the 3 levels of database.
The DBA will then create a new account id and password for the user if he/she need to access the data base.
DBA is also responsible for providing security to the data base and he allows only the authorised users to access/modify the data base.
- DBA also monitors the recovery and back up and provide technical support.
- The DBA has a DBA account in the DBMS which called a system or superuser account.
- DBA repairs damage caused due to hardware and/or software failures.
Who are Naive / Parametric End Users?
Parametric End Users are the unsophisticated who don’t have any DBMS knowledge but they frequently use the data base applications in their daily life to get the desired results.For example, online library system, ticket booking systems, ATMs etc which has existing application and users use them to interact with the database to fulfill their requests.
Who is a System Analyst?
System Analyst is a user who analyzes the requirements of parametric end users. They check whether all the requirements of end users are satisfied.
Who are Sophisticated Users?
Sophisticated users can be engineers, scientists, business analyst, who are familiar with the database. They can develop their own data base applications according to their requirement. They don’t write the program code but they interact the data base by writing SQL queries directly through the query processor.
Who are Database Designers?
DataBase Designers are the users who design the structure of data base which includes tables, indexes, views, constraints, triggers, stored procedures. He/she controls what data must be stored and how the data items to be related.
Who are Application Program?
Application Program are the back end programmers who write the code for the application programs.They are the computer professionals. These programs could be written in programming languages such as Visual Basic, Developer, C, FORTRAN, COBOL, etc.
Who are Casual Users / Temporary Users?
Casual Users are the users who occasionally use/access the data base but each time when they access the data base they require the new information, for example, Middle or higher level manager.