15 Chapter 15 Database Administration Database Systems Design

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

15 Learning Objectives • That data are a valuable business asset that requires careful management • Why and how the database plays a critical role in an organization • That the introduction of a DBMS has important technological, managerial, and cultural organizational consequences Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 2

15 Learning Objectives • What the database administrator’s managerial and technical roles are • About several database administration tools • About various database administration strategies • How various database administration technical tasks are performed with Oracle Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 3

15 Data as a Corporate Asset Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 4

15 The Need for and Role of Databases in an Organization • Database’s predominant role is to support managerial decision making at all levels in the organization • DBMS must provide tools that give each level of management a different view of the data and support required level of decision making Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 5

15 A Summary of DBA Activities Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 6

15 Desired DBA Skills Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 7

15 DBA Activities and Services Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 8

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

15 Database Administration Tools (continued) • 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, 6 th Edition, Rob & Coronel 10

15 Developing a Database Administration Strategy • Critical step for any organization is to ensure its information system supports strategic plans for each of the company’s business areas • Database administration strategy must not conflict with information systems plans Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 11

15 Developing a Database Administration Strategy (continued) • Information engineering – Translates strategic company goals into the data and applications that will help company achieve those goals – Output of the IE process is an information systems architecture that serves as basis for planning, development, and control of future information systems Database Systems: Design, Implementation, & Management, 6 th Edition, Rob & Coronel 12

Summary 15 • 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, 6 th Edition, Rob & Coronel 13

15 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, 6 th Edition, Rob & Coronel 14