02010_ch15

02010_ch15 - Database Systems: Design, Implementation, and...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Systems: Design, Implementation, and Management Eighth Edition Chapter 15 Database Administration and Security
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 2 Objectives In this chapter, you will learn: Data are a valuable business asset requiring careful management How a database plays a critical role in an organization Introduction of a DBMS has technological, managerial, and cultural organizational consequences
Background image of page 2
th 3 Objectives (continued) In this chapter, you will learn: (continued) Database administrator’s managerial and technical roles Data security, database security, and the information security framework Several database administration tools and strategies How various database administration technical tasks are performed with Oracle
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 4 Data as a Corporate Asset Data are a valuable asset that require careful management Data are a valuable resource that translate into information Accurate, timely information triggers actions that enhance company’s position and generate wealth
Background image of page 4
th 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 6 The Need for and Role of Databases in an Organization Database’s predominant role is to support managerial decision making at all levels DBMS facilitates: Interpretation and presentation of data Distribution of data and information Preservation and monitoring of data Control over data duplication and use Three levels to organization management: Top, middle, operational
Background image of page 6
th 7 Introduction of a Database: Special Considerations Introduction of a DBMS is likely to have a profound impact Might be positive or negative, depending on how it is administered Three aspects to DBMS introduction: Technological Managerial Cultural One role of DBA department is to educate end users about system uses and benefits
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 8 The Evolution of the Database Administration Function Data administration has its roots in the old, decentralized world of the file system Advent of DBMS produced new level of data management sophistication DP department evolved into information systems (IS) department Data management became increasingly complex Development of database administration function
Background image of page 8
th 9 The Database Environment’s Human Component Even most carefully crafted database system cannot operate without human component Effective data administration requires both technical and managerial skills DA must set data administration goals DBA is focal point for data/user interaction Need for diverse mix of skills
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 10
Background image of page 10
th 11 The DBA’s Managerial Role DBA responsible for: Coordinating, monitoring, allocating resources Resources include people and data Defining goals and formulating strategic plans Interacts with end user by providing data and information Enforces
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 50

02010_ch15 - Database Systems: Design, Implementation, and...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online