Notes12 (1)

Notes12 (1) - CS245:DatabaseSystem Principles...

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

View Full Document Right Arrow Icon
CS 245 Notes 12 1 CS 245: Database System  Principles Notes 12: Distributed Databases Hector Garcia-Molina
Background image of page 1

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

View Full DocumentRight Arrow Icon
CS 245 Notes 12 2 Distributed Databases data DBMS data DBMS data DBMS data DBMS Distributed Database System
Background image of page 2
CS 245 Notes 12 3 Advantages of a DDBS Modularity Fault Tolerance High Performance Data Sharing Low Cost Components
Background image of page 3

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

View Full DocumentRight Arrow Icon
CS 245 Notes 12 4 Issues Data Distribution Exploiting Parallelism Concurrency and Recovery Heterogeneity
Background image of page 4
CS 245 Notes 12 5 Parallelism: Pipelining Example: T 1    SELECT *          FROM A WHERE cond T 2    JOIN T 1  and B A B (with index) select join
Background image of page 5

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

View Full DocumentRight Arrow Icon
CS 245 Notes 12 6 Parallelism: Concurrent  Operations Example: SELECT * FROM A WHERE cond A  where A.x < 10 select select A  where 10   A.x < 20 select A  where 20   A.x merge data location is important. ..
Background image of page 6
CS 245 Notes 12 7 Join Processing Example:  JOIN A, B over attribute X A 1 A 2 B 1 B 2 A.x < 10 A.x   10 B.x < 10 B.x   10 join strategy
Background image of page 7

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

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

This note was uploaded on 02/21/2011 for the course CS 245 taught by Professor Dr.hector during the Winter '02 term at SUNY Buffalo.

Page1 / 13

Notes12 (1) - CS245:DatabaseSystem Principles...

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

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