1 / 14

Chapter 15

Chapter 15. Database Administration. 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

charity-carlson
Download Presentation

Chapter 15

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 15 Database Administration

  2. 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, 6th Edition, Rob & Coronel

  3. 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, 6th Edition, Rob & Coronel

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

  5. The Need for and Role of Databasesin 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, 6th Edition, Rob & Coronel

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

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

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

  9. 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, 6th Edition, Rob & Coronel

  10. 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, 6th Edition, Rob & Coronel

  11. 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, 6th Edition, Rob & Coronel

  12. 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, 6th Edition, Rob & Coronel

  13. 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

  14. 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

More Related