Last modified on May 27th, 2020
What are the different types of database users?
Types of database users
There are many types of database users some of these are mentioned below;
Application programmers work on the database with the help of DML queries. The DML queries can be written in any e application programs just like pascal c c + + and java etc. The DML queries then converted into the low-level code to communicate with the database. For example if we write a program to get the salary report of all the employees of a department then we need to query to find the data from the database.
The sophisticated users are responsible to enter the SQL queries just like insert select delete and update into the database. The sophisticated users do not require any kind of application program to query with the database.
Sophisticated users can directly communicate with the database by giving the SQL queries.
Specialized users are also called sophisticated users but they are responsible for writing the special database application programs. The specialized users are responsible to develop the programs according to the given requirements.
Stand Alone Users
Standalone users use the ready-made databases and graphical interfaces with menus icons and buttons.
When we develop software with a good database then the native users are the actual users who work on the given database with the help of graphical user interfaces. For example the user of the librarian login into the library system software and then issues the books to the students with the help of the graphical user interface provided to the librarian.
The interesting thing is that the librarian doesn’t know about the database is and what are database is but the librarian can do a good job by using the interfaces.
The database administrator is responsible for establishing a good database environment and he is a person who is responsible for all the databases, installation of the database is the technical issues behind the databases and many other similar things that are involved in managing the database.
The database administrators are responsible for maintaining the data integrity data security data reliability, ensuring the normalization, to avoid the data redundancy and data inconsistency, and many other similar things. The good database administrators must have a knowledge of oracle based software, SAP, and SQL, etc.
Responsibilities of database administrators
- To install the database.
- To upgrade the database and patching.
- To ensure the database normalization.
- To ensure data consistency.
- To ensure the database access to all users all the time.
- To ensure a good uptime for the databases.
- To solve the issues related to the performance of the database is.
- To install and configure the database related hardware and components.
- To maintain a database that fulfills the international standard of the time.
- To ensure database quality.
- To build the database with good database models.
- To ensure the data backup.
- To ensure the successful database migrations in case of server changes.
- To build good database designs.