ParallelDBMS - Outline Introduction Distributed DBMS...

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

View Full Document Right Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 7.1 Outline ± Introduction ± Distributed DBMS Architecture ± Distributed Database Design ± Distributed Query Processing ± Distributed Transaction Management ± Data Replication ² Parallel Database Systems z Database server approach z Parallel architectures z Parallel DBMS techniques z Parallel execution models ² Data Integration Systems ² Web Search/Querying ² Peer-to-Peer Data Management ² Data Stream Management
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 & Parallel DBMS M. Tamer Özsu Page 7.2 ± Large volume of data ¾ use disk and large main memory ± I/O bottleneck (or memory access bottleneck) z Speed(disk) << speed(ram) << speed(microprocessor) ± Predictions z (Micro-) processor speed growth : 50% per year z DRAM capacity growth : 4 × every three years z Disk throughput : 2 × in the last ten years ± Conclusion : the I/O bottleneck worsens The Database Problem
Background image of page 2
Distributed & Parallel DBMS M. Tamer Özsu Page 7.3 ± Increase the I/O bandwidth z Data partitioning z Parallel data access ± Origins (1980's): database machines z Hardware-oriented ¾ bad cost-performance ¾ failure z Notable exception : ICL's CAFS Intelligent Search Processor ± 1990's: same solution but using standard hardware components integrated in a multiprocessor z Software-oriented z Standard essential to exploit continuing technology improvements The Solution
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 & Parallel DBMS M. Tamer Özsu Page 7.4 ± High-performance with better cost-performance than mainframe or vector supercomputer ± Use many nodes, each with good cost- performance, communicating through network z Good cost via high-volume components z Good performance via bandwidth ± Trends z Microprocessor and memory (DRAM): off-the-shelf z Network (multiprocessor edge): custom ± The real chalenge is to parallelize applications to run with good load balancing Multiprocessor Objectives
Background image of page 4
Distributed & Parallel DBMS M. Tamer Özsu Page 7.5 Database Server Architecture network Application server Database server database Distributed DBMS layer DBMS functions Client interface Application DBMS server interface Client Client interface Application DBMS server interface
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 & Parallel DBMS M. Tamer Özsu Page 7.6 Distributed Database Servers network Application server Database servers application server interface DBMS functions Client interface Application DBMS server interface Client Client interface Application DBMS server interface DBMS functions Distributed DBMS layer Distributed DBMS layer
Background image of page 6
Distributed & Parallel DBMS M. Tamer Özsu Page 7.7 Objectives Of Database Servers Avoid the shortcomings of the traditional DBMS approach z Centralization of data and application management z General-purpose OS (not DB-oriented) By separating the functions between z Application server (or host computer) z Data server (or database computer or back-end computer)
Background image of page 7

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

View Full DocumentRight Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 7.8 Data Server Approach: Assessment ± Advantages z Integrated data control by the server (black box) z Increased performance by dedicated system z
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 41

ParallelDBMS - Outline Introduction Distributed DBMS...

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

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