Database Administration by mikemed


									       Chapter 13
   Database Administration

      Database Systems:
  Design, Implementation, and
Management, Seventh Edition, Rob
          and Coronel              1
Creating a New Database

                          2   2
Creating a New Database

                          3   3
Creating a New Database

                          4   4
Creating a New Database

                          5   5
Creating a New Database

                          6   6
Creating a New Database (continued)

                                  7   7
Creating a New Database

                          8   8
Creating a New Database (continued)

                                  9   9
Creating a New Database

                          10 10
Creating a New Database

                          11 11
Creating a New Database

                          12 12
• Data management is critical activity for
  any organization
• Data should be treated as corporate asset
• DBMS is most commonly used electronic
  tool for corporate data management
• Impact of DBMS on organization’s
  managerial and cultural framework must
  be carefully examined

                                         13 13
       Summary (continued)

• Development of data administration function is
  based on evolution from departmental data
  processing to more centralized electronic data
  processing (EDP) department to more formal
  “data as a corporate asset” information systems
  (IS) department
• Database administrator (DBA) is responsible for
  managing corporate database
• Broader data management activity is handled by
  data administrator (DA)
                                                14 14
        Summary (continued)
• DA is more managerially oriented than more
  technically oriented DBA
• Managerial services of DBA function include:
  – Supporting end-user community
  – Defining and enforcing policies, procedures, and
    standards for database function
  – Ensuring data security, privacy, and integrity
  – Providing data backup and recovery services
  – Monitoring distribution and use of data in database

                                                      15 15
        Summary (continued)
• Technical role requires DBA to be involved in at
  – Evaluating, selecting, and installing DBMS
  – Designing and implementing databases and
  – Testing and evaluating databases and applications
  – Operating DBMS, utilities, and applications
  – Training and supporting users
  – Maintaining DBMS, utilities, and applications

                                                    16 16
        Summary (continued)
• Development of data administration strategy is
  closely related to company’s mission and objectives
• To help translate strategic plans into operational
  plans, DBA has access to an arsenal of database
  administration tools
   – Tools include data dictionary and computer-aided software
     engineering (CASE) tools
• Some database administration functions are
  performed using Oracle RDBMS
   – Several tasks are performed by a typical Oracle DBA using
     Oracle database administrator tools

                                                                 17 17

To top