Database Users and Administrator

1. Database UsersandAdministrator

2. Database Users and Administrator • Primary goal of the database system is to retrieve information and store new information in the database

3. There are two types of users • Database Users • Database Administrators

4. Database Users

5. There are four types of users • Native users • Application Programmers • Sophisticated Users • Specialized Users

6. Native Users They are unsophisticated users who interact with the system by invoking one of the application program that have been written previously.

7. Application Programmers They are computer professionals who write application programs. Application programmers can choose from many tools to develop user interfaces.

8. Sophisticated Users They interact with the system without writing programs. Instead they write their requests in a database query language.

9. Specialized Users They are sophisticated users who write specialized database applications that do not fit in to the traditional data-processing frame work.

10. Database Administrator (DBA)

11. Roles & Responsibilities of Database Administrator

12. DBA DBA is the person or group that is responsible for supervising both the data base and the use of the DBMS

13. Roles of DBA • Policy Formulation and Implementation • Access privileges • Security • Disaster planning • Archives • Data Dictionary Management • Training • DBMS Support • DBMS evaluation and selection • DBMS responsibility • Data Base Design

14. Policy Formulation and Implementation DBA formulates policies and communicates these policies to users. Among these policies are those covering access privilege, security, disaster planning, and archives.

15. AccessPrivilege Access to every table and field in the database is not a necessity for every user. User A Access denide Access permitted

16. Security • Security refers to the prevention of unauthorized access to the database • Once access privilege have been specified and security features are in place, DBA draws up policies to explain the security privileges and then distributes these policies to authorized users.

17. Planning for Disaster • A database may be harmed by some physical problems or by some natural disasters. • For this the DBA’s responsibility is to establish and implement backup and recovery procedures.

18. Archives • This tells that data need to be kept in the database for only a limited time. • A data archive is a place where a record of certain corporate data is kept

19. Data Dictionary Management • Data dictionary contains a wider range of information, including at the very least, information on tables, indexes, and programs. • The creation and distribution of appropriate reports from the data dictionary is another of DBA”s responsibility.

20. DBMS Support • DBA is responsible for all the aspects of a DBMS within an organization, including the selection and maintenance of the system.

21. DBMS Evaluation and Selection • DBA is responsible for the evaluation and selection of the DBMS. In order to over see this responsibility, it sets up a check list. • DBA must evaluate each prospective purchase of a DBMS in terms of all the categories.

22. Responsibility for DBMS • DBA installs the DBMS in a way that is suitable for the organization. • If the DBMS configuration need to be changed, DBA makes the changes.

23. Database Design • DBA is in charge of database design at both the information level and the physical level. • It is also in charge of evaluating changes in requirements to determine whether a change in the database design is warranted. If so, DBA makes the changes and reports it to affected users.

24. Questions ?