Page 70 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

13 Database Compliance DBA: Ensures that the database system adheres to industry regulations and
compliance standards, such as GDPR or HIPAA.
14 Big Data DBA: Specializes in managing and optimizing large-scale databases used for big data analytics.
They handle distributed databases, NoSQL databases, and data processing frameworks.
15 NoSQL DBA: Manages NoSQL databases, which are used for handling unstructured or semi-structured data.
They specialize in platforms like MongoDB, Cassandra, and Redis.
Different types of Database Users

Database Administrator (DBA)
- Defines database schema and controls the three levels of the database.
- Creates new user accounts and manages access.
- Ensures database security and authorizes user access.
- Monitors performance, recovery, backup, and provides technical support.

- Responsible for resolving security breaches and performance issues.
- Performs Data Control Language (DCL) operations.
- Has a system or super user account in the DBMS.
- Handles hardware and software failures and repairs damage.
- Manages privileges and access permissions.
Naive / Parametric End Users
- Unsophisticated users who frequently use database applications.

- Lack in-depth DBMS knowledge.
- Commonly interact with databases to perform specific tasks.
- Examples: Railway ticket booking users, bank clerks.
System Analyst
- Analyzes requirements of parametric end users.

- Ensures end users’ needs are met.
- Acts as an intermediary between end users and the DBMS.
Sophisticated Users
- Familiar with databases.
- Can develop own database applications.
- Write SQL queries directly through the query processor.

- Often engineers, scientists, business analysts.
Database Designers
- Design database structures including tables, indexes, views, triggers, etc.
- Enforce constraints and relationships in the design.
- Understand requirements of different user groups.

- Create designs that satisfy diverse user needs.
Application Programmers
- Write code for application programs.
- Back-end programmers who develop software.
- Use programming languages like Visual Basic, C, etc.
- Design, debug, test, and maintain programs for users’ interaction with databases.

57

CITS : IT&ITES - Computer software application - Lesson 18 - 36