hoffer_mdbm9e_IM_14

hoffer_mdbm9e_IM_14 - Modern Database Management Ninth...

Info icon This 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
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 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.
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern