Here I’m describing you the database users and administrators in the DBMS.
The people who are accessing or working with the database are called database users and administrators. We know that the primary aim of the DBMS is to store the data or information and retrieve whenever it is needed by the database users.
Database Users and Administrators
Those who are working with the database can be categorized into two; the database users and the database administrators.
The database users also can be categorized again into five groups according to how they interact with the database. They are:
- Native Users
- Application Programmers
- Sophisticated Users
- Specialized Users
- Stand-alone Users
1. Native Users
These are the database users who are communicating with the database through an already written program.
For example, when a student is registering on a website for an online examination. He creates data in the database by entering and submitting his name, address and exam details.
2. Application Programmers
These are the software developers and programming professionals who write the program codes.
They use tools like Rapid Application Development (RAD) tools for creating user interfaces with minimal efforts.
3. Sophisticated Users
Sophisticated users are those who are creating the database. These type of users do not write program code. And they do not use any software to request the database.
The sophisticated users directly interact with the database system using query languages like SQL.
4. Specialized Users
The sophisticated users who write special database application programs are called specialized users. The write complex programs for the specific complex requirements.
5. Stand-alone Users
Those who are using database fo personal usage. There are many database packages for this type database users.
The person who has the central control over a database system is called Database Administrator (DBA).
The database administrator has the following functions in a database system.
-Schema Definition: The database administrator creates the original database schema by executing a set of data definition statements in DDL.
-Storage structure an access method definition.
-Schema and physical or organization modification: The database administrator performs the changes to the schema according to the needs of organizations or physical needs to improve the database performance.
-Provide the granting of authorization to access data: The database administrator can decide the which parts of the database can be accessed by a user, by using the different types of authorization methods.
-Database maintenance: The database maintenance includes the following processes.
- Regular backing up of the database.
- Ensuring the disk space for performing the required operations.
- Monitoring the jobs running on the database.
I hope this article might be helped you for learning the Database Users and Administrators in DBMS.