Data Base Administration

ISBN-13: 9781468438710 / Angielski / Miękka / 2012 / 250 str.

Opis

In modem organizations, data has been added to the classical economic assets of land, labor, and capital. Data on company products, finances, and operations are gathered into data bases that are used to support management reporting and decision making. Effective use of these data bases requires control over their design and development and coordination among the various users. The exercise of these management functions is called data base administration (DBA). DBA is an evolutionary area. In many organizations, it was formed as a response to the problems created by the installation of sophisticated systems for data base management. As a result, the practice of DBA has been strongly influ- enced by its technological and organizational environment. The size, organiza- tional position, staffing, and defined role of DBA vary from firm to firm. How- ever, certain fundamental tasks and responsibilities are, or should be, recognized as the province of DBA. To date, literature on the DBA function is sparse. Most texts on data base management systems (Date, 1975; Kroenke, 1977; Martin, 1978; Sprowls, 1976; Tsichritzis and Lochovsky, 1977)* discuss DBA as one aspect of that technology.

Spis treści

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.