Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App

Related Articles

Personnel involved in Database Management System

Improve Article
Save Article
Like Article
Improve Article
Save Article
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.

My Personal Notes arrow_drop_up
Last Updated : 21 Apr, 2023
Like Article
Save Article
Similar Reads