ch5-p1 - Distributed Database Systems Chapter 5 Chapter 5...

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

View Full Document Right Arrow Icon
Distributed Database Systems Chapter 5 Chapter 5 Distributed Database Design DDB design --making decision on the placement of data across the network 51 Alternative Design Strategies 5.11 Top-down design process An iteration of five steps: 1. Requirement analysis 2. Conceptual design and view integration E-R representation and translation to RDB schema 3. Distribution design Data fragmentation and allocation 4. Physical design 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Distributed Database Systems Chapter 5 5. Tuning 2
Background image of page 2
Requirements Analysis System Requirements (Objectives) User input Conceptual Design View Design View Integration Access Information Global Conceptual Schema External Schema Definitions User Input Distribution Design Local Conceptual Schema Physical Design Schema Feedback Feedback Observation and Monitoring Distributed Database Systems Chapter 5 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Distributed Database Systems Chapter 5 5.1.2 Bottom-up design process Primarily for multidatabase applications 52 Distribution design issues l Why to fragment l How to fragment l Correctness of fragmentation l How to allocate l The information for fragmentation 5.21 Reasons for fragmentation To enhance intraquery concurrency To increase the throughput But extra cost for queries involving more than one segment residing at different sites 5.22 Fragmentation Alternatives 4
Background image of page 4
Distributed Database Systems Chapter 5 Horizontal, or vertical, or both. 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
Distributed Database Systems Chapter 5 E ENO ENAME TITLE E1 J.Doe Elec. Eng. E2 M.Smith Syst. Anal. E3 A.Lee Mach. Eng. E4 J.Miller Programmer E5 B.Casey Syst. Anal. E6 L.Chu Elec. Eng. E7 R.Davis Mach. Eng. E8
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/23/2009 for the course DBST 663 taught by Professor Tba during the Spring '09 term at MD University College.

Page1 / 16

ch5-p1 - Distributed Database Systems Chapter 5 Chapter 5...

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

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