Open In App

Personnel involved in Database Management System

Last Updated : 21 Apr, 2023
Like Article

Many persons are involved in the design, use, and maintenance of a large database with a few hundred users. Here we will consider people who may be called “Actors on the Scene”, whose jobs involve the day-to-day use of a large database.

  1. Database Administrators: Administrating the primary (database) and secondary (DBMS and related software) is the responsibility of the database administrator (DBA). The DBA is responsible for authorizing access to the database, coordinating and monitoring its use, and acquiring software and hardware resources as needed.
  2. Database Designers: Database Designers are responsible for identifying the data to be stored in the database and for choosing appropriate structures to represent and store this data. Database designers typically interact with each potential group and user and develop a view of the database that meets the data and processing requirements of these groups.
  3. End Users: End users are the people whose jobs require access to the database for querying, updating, and generating reports; the database primarily exists for their use. There are several categories of end users:
    • Casual end user: Occasionally access the database, but they may need different information each time. They are typically middle-or high-level managers or other occasional browsers.
    • Naive or Parametric end user: Their main job function revolves around constantly querying and updating the database, using standard types of queries and updates that have been carefully programmed and tested. Bank tellers, Reservation Clerks for airlines, hotels, etc are the example of Naive end users.
    • Sophisticated end users: Sophisticated end users include engineers, scientists, business analysts, and others who thoroughly familiarize themselves with the facilities of the DBMS so as to implement their applications to meet their complex requirements.
    • Stand-alone users: They maintain the personal databases by using ready-made program packages that provide an easy-to-use menu or graphics-based interfaces.
  4. Software Engineers: System analysts determines the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements.Application programmers implement these specifications as programs; then they test, debug, document, and maintain these canned transactions. Such analysts and programmers are called Software Engineers.

There are several personnel involved in the management of a database management system, including:

Database administrators (DBAs): These professionals are responsible for the overall management of the database system. They are in charge of setting up, configuring, and maintaining the database, as well as ensuring its security and performance.

Database developers: These professionals design and create the database schema, tables, views, and queries. They work closely with the DBAs to ensure that the database is designed and implemented to meet the needs of the organization.

Data analysts: These professionals use the database to extract and analyze data to provide insights into business performance, trends, and customer behavior.

Data architects: These professionals are responsible for designing the overall structure of the database and ensuring that it is scalable, secure, and optimized for performance.

Application developers: These professionals create applications that interact with the database. They work closely with the database developers and DBAs to ensure that the applications are efficient and use the database resources appropriately.

System administrators: These professionals are responsible for the hardware and software infrastructure that supports the database system. They ensure that the database servers are up and running and that they have adequate resources to support the database.

Security personnel: These professionals are responsible for ensuring that the database is secure and that data is protected from unauthorized access or theft. They work closely with the DBAs and system administrators to implement security measures and monitor the database for security breaches.

Several personnel are typically involved in managing and maintaining a Database Management System (DBMS) to ensure its efficient functioning. The key personnel include:

  1. Database Administrators (DBAs): DBAs are responsible for managing and maintaining the DBMS. They are responsible for tasks such as installing and configuring the DBMS, designing and implementing the database schema, ensuring data security and backup, and optimizing database performance.
  2. Database Developers: Database developers are responsible for developing and implementing the database applications using the DBMS. They are responsible for tasks such as designing and implementing the database schema, developing stored procedures, triggers, and functions, and writing database queries.
  3. Data Analysts: Data analysts are responsible for analyzing the data stored in the DBMS to derive insights and trends. They use tools and techniques such as data mining, statistical analysis, and machine learning to analyze the data and provide insights to the organization.
  4. Business Analysts: Business analysts are responsible for understanding the business requirements of the organization and translating them into data requirements. They work closely with the data analysts and DBAs to ensure that the database is designed to meet the business requirements.
  5. End Users: End users are the people who use the DBMS to access and retrieve the data. They can be employees within the organization or external customers and partners who need access to the data.

Overall, a team of skilled personnel is required to manage and maintain a DBMS efficiently. Each member of the team plays a specific role and contributes to the successful operation of the DBMS.

Similar Reads

Pairs involved in Balanced Parentheses
Given a string of brackets, the task is to find the number of pairs of brackets involved in a balanced sequence in a given range. Examples : Input : ((())(() Range : 1 5 Range : 3 8 Output : 2 2 Explanation : In range 1 to 5 ((()), there are the two pairs. In range 3 to 8 ()) ((), there are the two pairs. Input : )()())) Range : 1 2 Range : 4 7 Out
14 min read
Database Management System - GATE CSE Previous Year Questions
Solving GATE Previous Year's Questions (PYQs) not only clears the concepts but also helps to gain flexibility, speed, accuracy, and understanding of the level of questions generally asked in the GATE exam, and that eventually helps you to gain good marks in the examination. Previous Year Questions help a candidate practice and revise for GATE, whic
5 min read
Federated database management system issues
What is a Federated Database Management System? A Federated Database Management System (FDBMS) is a type of distributed database management system that allows users to access and manipulate data stored in multiple databases. It is a system that integrates data from different sources, providing a single view of the data to users. This type of system
9 min read
Structure of Database Management System
Database Management System (DBMS) is software that allows access to data stored in a database and provides an easy and effective method of - Defining the information.Storing the information.Manipulating the information.Protecting the information from system crashes or data theft.Differentiating access permissions for different users. Data Theft: Wh
4 min read
Database Management System | Dependency Preserving Decomposition
Dependency Preservation: A Decomposition D = { R1, R2, R3...Rn } of R is dependency preserving wrt a set F of Functional dependency if (F1 ? F2 ? … ? Fm)+ = F+. Consider a relation R R ---> F{...with some functional dependency(FD)....} R is decomposed or divided into R1 with FD { f1 } and R2 with { f2 }, then there can be three cases: f1 U f2 =
4 min read
Introduction of DBMS (Database Management System) - Set 1
A Database Management System (DBMS) is a software system that is designed to manage and organize data in a structured manner. It allows users to create, modify, and query a database, as well as manage the security and access controls for that database. DBMS provides an environment to store and retrieve the data in coinvent and efficient manner. Key
9 min read
Advantages of Database Management System
Database Management System (DBMS) is a collection of interrelated data and a set of software tools/programs that access, process, and manipulate data. It allows access, retrieval, and use of that data by considering appropriate security measures. The Database Management system (DBMS) is really useful for better data integration and security. [capti
5 min read
Difference between Management Information System (MIS) and Decision Support System (DSS)
Decision Support System (DSS) is an interactive, flexible computer based information system or sub-system intended to help decision makers use communication technologies, data, documents to identify and solve problems, complete decision process tasks and make decision. Management Information System (MIS) consists of following three pillars: Managem
2 min read
How to pre populate database in Android using SQLite Database
Introduction : Often, there is a need to initiate an Android app with an already existing database. This is called prepopulating a database. In this article, we will see how to pre-populate database in Android using SQLite Database. The database used in this example can be downloaded as Demo Database. To prepopulate a SQLite database in an Android
7 min read
Difference between Database Administrator (DBA) and Database Engineer
1. Database Administrator (DBA) : A database administrator is responsible for management of a database (DB). His/her duties involve administration, performance tuning, optimization, backup and recovery of a database. The DBA is more of a management profile. The DBA also enhances the Logical Design of the database. He/she may be guided by the Databa
3 min read
Article Tags :