1 / 24

Database Users and Administrator

Database Users and Administrator. Database Users and Administrator. Primary goal of the database system is to retrieve information and store new information in the database. There are two types of users. Database Users Database Administrators. Database Users. There are four types of users.

cala
Télécharger la présentation

Database Users and Administrator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 ?

More Related