Database users and administrator
1 / 24

Database Users and Administrator - PowerPoint PPT Presentation

  • Updated On :

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Database Users and Administrator' - cala

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Database users and administrator l.jpg

Database UsersandAdministrator

Database users and administrator2 l.jpg
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 l.jpg
There are two types of users

  • Database Users

  • Database Administrators

There are four types of users l.jpg
There are four types of users

  • Native users

  • Application Programmers

  • Sophisticated Users

  • Specialized Users

Native users l.jpg
Native Users

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

Application programmers l.jpg
Application Programmers

They are computer professionals who write application programs.

Application programmers can choose from many tools to develop user interfaces.

Sophisticated users l.jpg
Sophisticated Users

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

Specialized users l.jpg
Specialized Users

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

Database administrator dba l.jpg

Database Administrator (DBA)

Roles responsibilities of database administrator l.jpg

Roles & Responsibilities of Database Administrator

Slide12 l.jpg

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

Roles of dba l.jpg
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

Policy formulation and implementation l.jpg
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.

Access privilege l.jpg

Access to every table and field in the database is not a necessity for every user.

User A

Access denide

Access permitted

Security l.jpg

  • 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.

Planning for disaster l.jpg
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.

Archives l.jpg

  • 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

Data dictionary management l.jpg
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.

Dbms support l.jpg
DBMS Support

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

Dbms evaluation and selection l.jpg
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.

Responsibility for dbms l.jpg
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.

Database design l.jpg
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.