Notes12 - 11/30/2011 Distributed Databases CS 245: Database...

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

View Full Document Right Arrow Icon
11/30/2011 1 CS 245 Notes 12 1 CS 245: Database System Principles Notes 12: Distributed Databases Hector Garcia-Molina CS 245 Notes 12 2 Distributed Databases data DBMS data DBMS data DBMS data DBMS Distributed Database System CS 245 Notes 12 3 Advantages of a DDBS •Modu la r i ty • Fault Tolerance • High Performance • Data Sharing • Low Cost Components CS 245 Notes 12 4 Issues • Data Distribution • Exploiting Parallelism • Concurrency and Recovery • Heterogeneity CS 245 Notes 12 5 Parallelism: Pipelining •E xamp le : –T 1 SELECT * FROM A WHERE cond 2 JOIN T 1 and B A B (with index) select join 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 1

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

View Full DocumentRight Arrow Icon
11/30/2011 2 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 CS 245 Notes 12 8 Join Processing • Example: JOIN A, B over attribute X
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 document was uploaded on 04/02/2012.

Page1 / 3

Notes12 - 11/30/2011 Distributed Databases CS 245: Database...

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