Data Base Administration

I · The Organization of Data Base Administration.- 1 · Managing the Data Resource.- 1.1. The Traditional Approach to Data Management.- 1.2. The Data Base Approach.- 1.3. Criteria for Using the Data Base Approach.- 1.4. Implications for Management.- 2 · The DBA Function.- 2.1. An Overview of the DBA function.- 2.2. The History of the DBA function.- 2.3. The Nature of DBA Tasks.- 2.4. DBA Organization and Staffing.- 2.5. DBA in Practice.- 3 · DBA within the Organization.- 3.1. DBA Interfaces.- 3.2. The DBA and Data Processing.- 3.3. The Data Processing Organization.- 3.4. Placement of the DBA.- 3.5. Other Factors Affecting Organizational Position.- 4 · DBA Organization and Staff.- 4.1. DBA Skills Inventory.- 4.2. Internal Organization of DBA.- 5 · Organizational Dynamics.- 5.1. The Evolution of the DBA function.- 5.2. Conflicts in the DBA’s Role.- 5.3. Power and the DBA.- II · Data Base Planning.- 6 · Components of Data Base Planning.- 6.1. The Planning Process.- 6.2. Data Base Goals.- 6.3. Data Base Plans.- 6.4. Summary.- 7 · Evaluation and Selection of Data Base Management Systems.- 7.1. DBMS Features.- 7.3. Methods of Evaluation.- 7.4. The DBA’s Role.- III · Data Base Design.- 8 · The Data Base Design Process.- 8.1. Overview of the Data Base Design Process.- 8.2. Trade-Offs in Data Base Design.- 8.3. Constraints of the DBMS.- 8.4. The DBA’s Role.- 9 · Logical Data Base Design.- 9.1. The Objectives of Logical Design.- 9.2. Basic Concepts.- 9.3. Steps in the Logical Design Process.- 9.4. The DBA’s Role in Logical Design.- 10 · Physical Data Base Design.- 10.1. The Objectives of Physical Design.- 10.2. Basic Concepts.- 10.3. Two Illustrations of Cost-Performance Trade-Offs.- 10.4. Steps in the Physical Design Process.- 10.5. Other Issues in Physical Design.- 10.6. The DBA’s Role in Physical Design.- IV · Data Base Operation and Control.- 11 · Maintaining Data Base Integrity.- 11.1. Sources of Error.- 11.2. Techniques for Maintaining Integrity.- 11.3. Integrity Features in DBMS Packages.- 11.4. The DBA’s Role in Maintaining Data Base Integrity.- 12 · Controlling Data Base Access.- 12.1. Threats to Data Base Security.- 12.2. Methods for Ensuring Data Security.- 12.3. DBMS Security Features.- 12.4. Components of Data Base Security Policy.- 12.5. The Implications of Privacy.- 13 · Monitoring Data Base Performance.- 13.1. Causes of Imbalance.- 13.2. Measures of Performance.- 13.3. Performance Tools.- 13.4. Resolution of Performance Problems.- V · Managing The User Interface.- 14 · Data Administration.- 14.1. Types of Metadata.- 14.2. Uses of Metadata.- 14.3. The Role of Data Dictionary/Directory Systems.- 15 · Data Base Standards.- 15.1. Conventions for Data Element Naming.- 15.2. Standards for Data Base Application Programs.- 15.3. Data Base Documentation.- 15.4. The Development of Data Base Applications.- 15.5. The DBA and Data Base Standards.- VI · Case Histories.- 16 · The DBA in Practice.- 16.1. Company X: Getting Started.- 16.2. Company Y: Balancing Technical and Communications Skills.- 16.3. Company Z: DBA as “Storage Cop”.- 16.4. Observations.- Appendix A · Data Base Management System Packages.- Model 204.- Appendix B · Data Dictionary/Directory Packages.- Data Catalogue 2.- The Model 204 Data Dictionary.