Chapter 15

1. Chapter 15 Database Administration Database Systems: Design, Implementation, and Management, Sixth Edition, Rob and Coronel

2. 15.5 The Database Environment’s Human Component • Even the most carefully crafted database system cannot operate without a human component • Effective data administration requires both technical and managerial skills • DA (data administrator) is responsible for the consolidation and consistency of both manual and computerized data • DBA is the focal point for data/user interaction • Need for diverse mix of skills Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

3. Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

4. Data Administrator • DA (data administrator) must set data administration goals, defined by • Data sharability and time availability • Data consistency and integrity • Data security and privacy • Extent and character of data use Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

5. Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

6. Personnel management, interactions with the end-user community The use of DB, production, development, and use of application programs Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

7. The DBA’s Managerial Role Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

8. End-User Support • User requirement gathering • Conflict and problem resolution • Finding solutions to information needs • Ensuring quality and integrity of application and data • Building end-user confidence • Managing the training and support of DBMS users Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

9. Policies, Procedures, and Standards • Policies are general statements of direction or action that communicate and support DBA goals • Standards describe the minimum requirements of a given DBA activity • Procedures are written instructions that describe a series of steps to be followed during the performance of a given activity Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

10. Data Security, Privacy, and Integrity • Authorization management defines procedures to protect and guarantee DB security and integrity • User access management, view definition, DBMS utility access control, DBMS usage monitoring, etc. Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

11. Data Backup and Recovery • Disaster management includes are the DBA activities to secure data availability after a physical disaster or a DB integrity failure • The backup and recovery include at least: • Periodic data and application backups • Proper backup identification • Convenient and safe backup storage • Physical protection of both hardware and software • Personal access control to the software of a DB installation • Insurance coverage for the data in the DB Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

12. The DBA’s Technical Role • DBMS and utilities evaluation, selection, and installation (p. 729) • Design and implementation of databases and applications • Testing and evaluation of databases and applications • Operation of the DBMS, utilities, and applications • Training and supporting users • Maintenance of the DBMS, utilities, and applications Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

13. 16.6 Database Administration Tools • Two main types of data dictionaries: • Integrated • Standalone • Main function of data dictionary: store description of all objects that interact with the database Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

14. Database Administration Tools (continued) • Data dictionary makes it possible to manage use and allocation of all organization’s information, regardless of whether it has roots in database data • Metadata stored in data dictionary are often basis for monitoring database use and assignment of access rights to database users Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

15. Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

16. Summary • Data management is critical for any organization • Data should be treated as corporate asset with monetary value • DBMS is most commonly used electronic tool for corporate data management • Impact of the DBMS on the organization’s managerial and cultural framework must be carefully examined • Data administration function was developed in response to changes in data management fostered by technological advances in computer systems Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

17. Summary (continued) • Database administrator (DBA) is responsible for corporate database management • Broader data management activity is handled by data administrator (DA) • DA is more managerially oriented than the more technically oriented DBA • Development of data administration strategy is closely related to the company’s mission and objectives • Implementing the overall company strategy is a crucial process influenced by managerial, technological, and cultural issues Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel