Types of Database users

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.

Thanks a lot for query or your valuable suggestions related to the topic.

Previous Post Next Post

Contact Form