Types of Database Users:
1. Database Administrator (DBA):
- DBA Stands for Database Administrator.
- It is a person or a team, who is responsible for managing the overall database management system.
- It is the leader of the database. It is like a superuser of the system.
- It is responsible for the administration of all the three levels of the database.
- DBA is responsible for:
- Deciding the instances for the database.
- Defining the Schema
- Liaising with Users
- Define Security
- Back-up and Recovery
- Monitoring the performance
2. Database Designers:
- Database designers design the appropriate structure for the database, where we share data.
3. System Analyst:
- System analyst analyses the requirements of end-users, especially naïve and parametric end users.
4. Application Programmers:
- Application programmers are computer professionals, who write application programs.
- They are the developers who interact with the database by means of DML queries.
- These DML queries are written in the application programs like C, C++, JAVA, Pascal, etc.
- These queries are converted into object code to communicate with the database.
- For example, writing a C program to generate the report of employees who are working in particular department will involve a query to fetch the data from database. It will include an embedded SQL query in the C Program.
5. Naïve Users / Parametric Users:
- Naïve Users are Un-sophisticated users, which has no knowledge of the database.
- These users are like a layman, which has a little bit of knowledge of the database.
- Naive Users are just to work on developed applications and get the desired result.
- For Example, the Railway’s ticket booking users are naive users. Or Clerical staff in any bank is a naïve user because they don’t have any DBMS knowledge but they still use the database and perform their given task.
6. Sophisticated Users:
- Sophisticated users can be engineers, scientists, business analysts, who are familiar with the database.
- These users interact with the database but they do not write programs.
- They are database developers, who write SQL queries to select/insert/delete/update data.
- They do not use any application or programs to request the database.
- They directly interact with the database by means of query language like SQL.
- In short, we can say this category includes designers and developers of DBMS and SQL.
7. Casual Users / Temporary Users:
- These types of users communicate with the database for a little period of time.
Tags:
DBMS