{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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 Document Right 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 Document Right 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 Document Right 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 Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}