1 / 24

Chapter 8

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

astrid
Download Presentation

Chapter 8

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. Chapter 8 Database Administration Concepts of Database Management, 4th Edition, Pratt & Adamski

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

  3. Objectives • Discuss the DBA’s technical responsibilities for database design, testing, and performance tuning Concepts of Database Management, 4th Edition, Pratt & Adamski

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

  5. DBA Responsibilities Figure 8.1 Concepts of Database Management, 4th Edition, Pratt & Adamski

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

  7. Access Privileges for Sam Figure 8.2 Concepts of Database Management, 4th Edition, Pratt & Adamski

  8. Access Privileges for Paige Figure 8.3 Concepts of Database Management, 4th Edition, Pratt & Adamski

  9. Access Privileges for Valerie Figure 8.4 Concepts of Database Management, 4th Edition, Pratt & Adamski

  10. Attempted Security Violation by Brady Figure 8.5 Concepts of Database Management, 4th Edition, Pratt & Adamski

  11. Attempted Security Violation by Paige Figure 8.6 Concepts of Database Management, 4th Edition, Pratt & Adamski

  12. DBMS Supplies Security Features Figure 8.7 Concepts of Database Management, 4th Edition, Pratt & Adamski

  13. Supplemented Security Features Figure 8.8 Concepts of Database Management, 4th Edition, Pratt & Adamski

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

  15. Movement of Data to Archive Figure 8.9 Concepts of Database Management, 4th Edition, Pratt & Adamski

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

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

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

  19. Interaction Between Test and Production Systems Figure 8.11 Concepts of Database Management, 4th Edition, Pratt & Adamski

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

  21. Customer Table Figure 8.12 Concepts of Database Management, 4th Edition, Pratt & Adamski

  22. Split Customer Table Figure 8.13a Concepts of Database Management, 4th Edition, Pratt & Adamski

  23. Split Customer Table Figure 8.13b Concepts of Database Management, 4th Edition, Pratt & Adamski

  24. Including Part Descriptions in OrderLine Table Figure 8.14 Concepts of Database Management, 4th Edition, Pratt & Adamski

More Related