{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

hoffer_mdbm9e_IM_13 (1)

hoffer_mdbm9e_IM_13 (1) - Chapter 13 199 Chapter 13 Data...

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

View Full Document Right Arrow Icon
Chapter 13 Chapter 13 Data and Database Administration Chapter Overview The purpose of this chapter is to introduce students to the principles and tools for the administration of data. Data and database administration assume even greater importance as organizations distribute their data and processing across the enterprise. The chapter emphasizes the changing roles and approaches of data and database administration. The chapter continues to emphasize the critical importance of data and database management in managing data as a corporate asset. It includes the major issues of data security, concurrency control, and backup and recovery that occupy database administrators’ attention on an ongoing basis. Chapter Objectives Specific learning objectives are included at the beginning of the chapter. From an instructor’s point of view, the objectives of this chapter are to: 1. Ensure that the students understand the importance of data administration and its relationship to information resource management. 2. Develop an understanding of the changes that are occurring in the data administrator and database administrator roles. 3. Understand the problem of lost updates and the use of both pessimistic and optimistic concurrency control mechanisms. 4. Define the major functions and components of the principal data management software: database management systems and information repositories. 5. Emphasize the problems of database security, and gain an understanding of techniques used to enhance database security. 6. Provide a sound understanding of database recovery including possible situations requiring recovery and the available procedures and facilities to use when recovery is necessary. 7. Understand areas such as installation decisions, management of I/O contention, and so forth that can be addressed when tuning a database. 199
Background image of page 1

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

View Full Document Right Arrow Icon
Modern Database Management, Ninth Edition Key Terms Aborted transaction Database security Restore/rerun After-image Deadlock Shared lock (S lock, read lock) Authorization rules Deadlock prevention Backup facilities Deadlock resolution Smart card Backward recovery (rollback) Encryption System catalog Exclusive lock (X lock, write lock) Transaction Before-image Forward recovery (rollforward) Transaction boundaries Checkpoint facility Transaction log Concurrency control Heartbeat query Two-phase locking protocol Data administration Inconsistent read problem User-defined procedures Data archiving Information Repository Dictionary System (IRDS) Versioning Data dictionary Journalizing facilities Database administration Locking Database change log Locking level (lock granularity) Database destruction Open-source DBMS Database recovery Recovery manager Classroom Ideas 1. If possible, schedule a classroom visit by a data administrator or database administrator from a local company or organization. Discuss the agenda in advance, and allow plenty of time for questions. 2.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 21

hoffer_mdbm9e_IM_13 (1) - Chapter 13 199 Chapter 13 Data...

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

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