Explain Peoples who deal with databases

Explain Peoples who deal with databases, DBA, Database Designers, End User, Naïve User, Sophisticated users, Casual Users, system Analyst

Explain People who deal with databases

 

 Many persons are involved in the design, use and maintenance of any database. These persons can be classified into 2 types as below.

 

 Actors on the scene:

The people, whose jobs involve the day-to-day use of a database are called as 'Actors on the scene',

listed as below.

 

1.Database Administrators (DBA):

 

The DBA is responsible for authorizing access to the database, for

Coordinating and monitoring its use and for acquiring software and hardware resources as needed. These are the people, who maintain and design the database daily. DBA is responsible for the following issues.

 

a.   Design of the conceptual and physical schemas:

The DBA is responsible for interacting with the users of the system to understand what data is to be stored in the DBMS and how it is likely to be used.

The DBA creates the original schema by writing a set of  definitions and is    Permanently stored in the 'Data Dictionary'.

b.  Security and Authorization:

The DBA is responsible for ensuring the unauthorized data access is not permitted.

The granting of different types of authorization allows the DBA to regulate which parts of the database various users can access.

 

c.   Storage structure and Access method definition:

The DBA creates appropriate storage structures and access methods 

by writing a set of definitions, which are translated by the DDL compiler.

 

d.  Data Availability and Recovery from Failures:

The DBA must take steps to ensure that if the system fails, users can continue to access as much of the uncorrupted data as possible.

The DBA also work to restore the data to consistent state.

 

e.   Database Tuning:

The DBA is responsible for modifying the database to ensure adequate  Performance as requirements change.

 

f.   Integrity Constraint Specification:

The integrity constraints are kept in a special system structure that is consulted by the DBA whenever an update takes place in the system.

 

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.

 

3. End Users:

People who wish to store and use data in a database.

End users are the people whose jobs require access to the database for querying, updating and generating reports, listed as below.

 

a.   Casual End users:

These people occasionally access the database, but they may need     different information each time.

 

b.  Naive or Parametric End Users:

Their job function revolves around constantly querying and updating the database using standard types of queries and updates.

 

c.   Sophisticated End Users:

These include Engineers, Scientists, Business analyst and others familiarize to implement their applications to meet their complex requirements.

 

d.  Stand alone End users:

These people maintain personal databases by using ready-made program packages that provide easy to use menu based interfaces.

 

4.System Analyst:

These people determine the requirements of end users and develop specifications for transactions.

 

5.Application Programmers (Software Engineers):

These people can test, debug, document and maintain the specified transactions. 

 

b. Workers behind the scene:

Database Designers and Implementers:

These people who design and implement the DBMS modules and interfaces as a software package.

 

2.Tool Developers:

Include persons who design and implement tools consisting the packages for design, performance monitoring, and prototyping and test data generation.

 

3.Operators and maintenance personnel:

These re the system administration personnel who are responsible for the actual running and maintenance of the hardware and software environment for the database system.