Any person who uses the database and takes benefits from the database is considered as Database Users. They can be programmers, scientists, engineers, business person or can be an employee.
Database Administrator (DBA):
DBA stands for database administrator, can be a single person or can be a team, which 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 everything that is related to the database means every person who will access the database first has to permission from the DBA.
DBA has full control of data stored in the database and also full control of those application programs which will access the database.
It is responsible for the administration of all three levels of the database.
The DBA has all the privileges of the DBMS, he also can assign or remove the privileges from the other database users.
DBA is responsible for:
- Deciding the Instances for the Database.
- Deciding the Storage Structure and Access Strategy.
- Defining the Schema.
- Working with Developers.
- Granting of Authorization for data access.
- Managing Database Users and Security.
- Training and Support Users.
- Routine Maintenance.
- New Software Installation.
- Monitoring the database server’s health and Tuning accordingly.
Database designers design the appropriate structure for the database, where we share data.
System analyst analyses the requirements of end-users, especially naïve and parametric end users. They are responsible for the design, structure, and properties of the database. The main concern of the system analyst is on feasibility, economic and technical aspects.
Application programmers are computer professionals, who write application programs. They are developers who interact with the database through DML queries. They are the programmers and develop application programs such as C, C++, Java, PHP, Python, etc. They develop application programs and provide a user interface through applications so the other user can interact with the database.
They also specify what modifications are needed to the database structure for an application and relay it to the database administrator.
Naïve Users / Parametric Users:
Naïve Users are Unsophisticated users, who have no knowledge of the database. These users are like a layman, which has a little bit of knowledge of the database. They are the end-users of the database who work through the menu-driven applications.
This type of user does not need to be aware of the presence of the database system. They interact with the database only with the help of the application interface. They are just accessing the application whatever they are using.
Naive Users are just to work on developed applications and get the desired result.
For Example: 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.
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
Casual Users / Temporary Users:
These types of users communicate with the database for a little period of time.
Different Types of Database Users
Frequently Asked Questions
What is the meaning of database?
Database is a shared collection of logically related data, where data is stored in a systematic manner to meet the requirements of different users and serve some specific purpose.
For example: A college database is maintained where all the information about students, teachers, staff, books, etc. So we can use that information later to solve its purpose.
What do you mean by DBMS?
Database Management System is a collection of application programs, which allows its users to define, create, maintain, and control access to the database. It also helps store, modify, and extract data from a database as per the user’s requirements.
Some DBMS examples are: Oracle, MySQL, IBM DB2, Sybase, etc.
Explain some advantages of DBMS?
• It provides data abstractions means it abstract the data from the users, which is not useful for the users.
• It controls data redundancy.
• It also minimized data inconsistency.
• We can easily manipulate data like- insertion, modification, or deletion.
• Data can also be shared by multiple applications.
• It also provides data security, where the data can only be access by authorized users of the organization.
• It also supports the multi-users view, many users can view and access the database at the same time.
Explain some disadvantages of DBMS?
• To run the DBMS, we need a costly high-speed processor and also a large memory size.
• If we are using the first time database system, then we have to convert our old file-based system into the database system, which is a difficult and time-consuming process.
• DBMS cannot be handled by any normal person, they are often complex systems, so the initial training is required and an organization paid plenty of amount for the training of workers.