1 / 45

Chapter 15

Chapter 15. Database Administration Database Systems: Design, Implementation, and Management, Sixth Edition, Rob and Coronel. In this chapter, you will learn:. That data are a valuable business asset that requires careful management

lolita
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 Database Systems: Design, Implementation, and Management, Sixth Edition, Rob and Coronel

  2. In this chapter, you will learn: • 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. In this chapter, you will learn: (continued) • 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 • Data are accepted as a valuable asset requiring careful management • Data are now well understood as a valuable resource to be translated into information • If information is accurate and timely, its use is likely to enhance company’s competitive position and generate wealth Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  5. Fig 15.1 The Data-Information-Decision-Making Cycle Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

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

  7. Introduction of a Database: Special Considerations • Having a computerized database management system does not guarantee that the data will be properly used to provide best solutions required by managers Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  8. Introduction of a Database: Special Considerations (continued) • Introduction of a DBMS is likely to have a profound impact, which might be positive or negative, depending on how it is administered • Three important aspects • Technological: DBMS software and hardware • Managerial: Administrative functions • Cultural: Corporate resistance to change Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  9. The Evolution of the Database Administration Function • Data administration has its roots in the old, decentralized world of the file system • Advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into an information systems (IS) department • Data management became an increasingly complex job, thus leading to development of the database administration function Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  10. The IS Department Internal Organization Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  11. The Placement of the DBA Function Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  12. A DBA Functional Organization Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  13. Multiple Database Administrators in an Organization Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  14. The Database Environment’s Human Component • Even the most carefully crafted database system cannot operate without a human component • Effective data administration requires both technical and managerial skills • DA must set data administration goals • DBA is the focal point for data/user interaction • Need for diverse mix of skills Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  15. Contrasting DA and DBA Activities and Characteristics Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

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

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

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

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

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

  21. An Example of a CASE Tool: Visio Professional Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

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

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

  24. Forces Affecting the Development of the ISA Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  25. The DBA at Work: Using Oracle for Database Administration • Execution of tasks tends to be DBMS-and operating-system specific • Brief introduction to the way some typical DBA tasks would be performed in Oracle Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  26. The Oracle Enterprise Manager Interface Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  27. Oracle Edit Local Preferred Credentials Window Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  28. Oracle RDBMS Services Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  29. The Oracle Storage Manager Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  30. Creating a New Tablespace Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  31. The Oracle Schema Manager Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  32. The Oracle Security Manager Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  33. The Create User Dialog Box Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  34. The Oracle Instance Manager Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  35. Creating a New Database with the Database Configuration Assistant Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  36. Selecting the New Database Template Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  37. Naming the Database Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  38. Selecting the Database Operation Mode Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  39. Specifying Initialization Parameters Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  40. Specifying Storage Parameters Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  41. Database Creation Options Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  42. Summary of Database Creation Options Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

  43. Database Creation Progress Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

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

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