chapter 8 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Chapter 8 PowerPoint Presentation
Download Presentation
Chapter 8

Loading in 2 Seconds...

play fullscreen
1 / 24

Chapter 8 - PowerPoint PPT Presentation


  • 122 Views
  • Uploaded on

Chapter 8. Database Administration. Objectives. Discuss the need for database administration (DBA) Explain the DBA’s responsibilities in formulating and enforcing database policies for access privileges, security, disaster planning, and archiving

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

PowerPoint Slideshow about 'Chapter 8' - astrid


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
chapter 8
Chapter 8

Database Administration

Concepts of Database Management, 4th Edition, Pratt & Adamski

objectives
Objectives
  • Discuss the need for database administration (DBA)
  • Explain the DBA’s responsibilities in formulating and enforcing database policies for access privileges, security, disaster planning, and archiving
  • Discuss the DBA’s administrative responsibilities for DBMS evaluation and selection, DBMS maintenance, data dictionary management, and training

Concepts of Database Management, 4th Edition, Pratt & Adamski

objectives1
Objectives
  • Discuss the DBA’s technical responsibilities for database design, testing, and performance tuning

Concepts of Database Management, 4th Edition, Pratt & Adamski

database administration dba
Database Administration (DBA)
  • Resource that supervises database and use of DBMS
  • DBA is usually a group
  • May refer to one person also called a database administrator

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide5

DBA Responsibilities

Figure 8.1

Concepts of Database Management, 4th Edition, Pratt & Adamski

policy formulation and implementation
Policy Formulation and Implementation
  • Access Privileges
    • Users access the database only in ways in which they are entitled
  • Security
    • Access restrictions ensure database is secure
    • Passwords, encryption, and views implement security
    • Effective password protection critical

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide7

Access Privileges for Sam

Figure 8.2

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide8

Access Privileges for Paige

Figure 8.3

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide9

Access Privileges for Valerie

Figure 8.4

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide10

Attempted Security Violation by Brady

Figure 8.5

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide11

Attempted Security Violation by Paige

Figure 8.6

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide12

DBMS Supplies Security Features

Figure 8.7

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide13

Supplemented Security Features

Figure 8.8

Concepts of Database Management, 4th Edition, Pratt & Adamski

policy formulation and implementation con t
Policy Formulation and Implementation (con’t.)
  • Disaster Planning
    • Protection against physical damage
    • Use DBMS backup and recovery tools with supplements where needed
    • Disaster recovery plan
  • Archiving
    • Place to keep corporate data
    • Mass-storage device used for archiving

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide15

Movement of Data to Archive

Figure 8.9

Concepts of Database Management, 4th Edition, Pratt & Adamski

policy formulation and implementation1
Policy Formulation and Implementation
  • DBMS Evaluation and Selection
    • Preparation of checklist
    • Evaluation of various DBMSs according to selected categories
    • Comparison of results
  • DBMS Maintenance
    • Configuration changes
    • Upgrades for new releases
    • Problem resolution

Concepts of Database Management, 4th Edition, Pratt & Adamski

policy formulation and implementation con t1
Policy Formulation and Implementation (con’t.)
  • Data Dictionary Management
    • Is essentially database catalog with wider range of information
    • Updates the data dictionary
    • Establishes naming conventions for tables, fields, etc.
    • Creates data integrity rules
  • Training
    • How to use DBMS and database

Concepts of Database Management, 4th Edition, Pratt & Adamski

technical functions
Technical Functions
  • Database Design
    • Establishes sound methodology for database design
    • Creates documentation standards
    • Manages changes
  • Testing
    • DBA controls production system
    • Grants privileges to programmers to modify and test software

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide19

Interaction Between Test and Production Systems

Figure 8.11

Concepts of Database Management, 4th Edition, Pratt & Adamski

technical functions con t
Technical Functions (con’t.)
  • Performance Tuning
    • DBA attempts to get best performance with funding constraints
    • Creating indexes, splitting tables, changing table design
    • Denormalization

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide21

Customer Table

Figure 8.12

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide22

Split Customer Table

Figure 8.13a

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide23

Split Customer Table

Figure 8.13b

Concepts of Database Management, 4th Edition, Pratt & Adamski

slide24

Including Part Descriptions

in OrderLine Table

Figure 8.14

Concepts of Database Management, 4th Edition, Pratt & Adamski