hoffer_mdbm9e_IM_14 - Modern Database Management Ninth...

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

View Full Document Right Arrow Icon
Modern Database Management, Ninth Edition Chapter 14 Distributed Databases Chapter Overview Please note that the material for this chapter is based upon the Web version of Chapter 14, not the abbreviated version of Chapter 14 in the text. The purpose of this chapter is to discuss distributed database management. The trend toward distributed databases is being driven by the continued evolution of distributed database management systems software, the increasing importance of workgroup computing, and the globalization of commerce. This chapter, along with Chapter 13 on data and database administration, provides thorough coverage of database concurrent access controls. Chapter Objectives Specific student learning objectives are included at the beginning of each chapter. From an instructor’s point of view, the objectives of this chapter are to: 1. Discuss the various options that are available for distributing data in organizations. 2. Discuss the potential advantages and risks associated with distributed databases. 3. Enable the student to compare distributed database design strategies with respect to reliability, expandability, communications overhead costs, manageability, and data consistency. 4. Discuss the four types of transparency: location, replication, failure, and concurrency. 5. Consider both the need for and the accomplishment of query optimization. Key Terms Asynchronous distributed database Global transaction Semijoin Commit protocol Local autonomy Synchronous distributed database Concurrency transparency Local transaction Decentralized database Location transparency Timestamping Distributed database Replication transparency Transaction manager Failure transparency Two-phase commit 220
Background image of page 1

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

View Full DocumentRight Arrow Icon
Modern Database Management, Ninth Edition Classroom Ideas 1. Assign your students the task of looking for examples of distributed database applications in the press. Discuss the issues in these examples based on material in the text. 2. Discuss the major options for distributing databases. Ask your students to help build a list of the advantages and disadvantages for each of these approaches. 3. Discuss the architecture of a distributed DBMS (Figures 14-2 and 14-3). Walk through the steps for both a local and remote database request. 4. Conduct a discussion of the four types of transparency: location, replication, failure, and concurrency. Relate this discussion to the database shown in Figure 14-10. Comment on what support (if any) is provided for each type of transparency by the DBMS your students are using in the course. 5. Explain locking, deadlock, and timestamping in a distributed database environment. 6. Discuss the problem of query optimization in a distributed database environment using Table 14-2. This table shows the dramatic differences in query processing times depending on the strategy used. 7. Emphasize that the concepts illustrated in this chapter are not necessarily established
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.

This note was uploaded on 11/02/2011 for the course IDS 410 taught by Professor Staff during the Spring '08 term at Ill. Chicago.

Page1 / 17

hoffer_mdbm9e_IM_14 - Modern Database Management Ninth...

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

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