Algorithm 8.1: Parallel Nested Loop (PNL) Input: R₁, R₂, ..., Rm: fragments of relation R S1, S2,..., Sn: fragments of relation S; JP: join predicate Output: T1, T2,..., Tn: result fragments begin end for i from 1 to m in parallel do | send R; to each node containing a fragment of S end for for j from 1 to n in parallel do R←UR₁; i=1 TjRAJP Sj end for {send R entirely to each S-node} {perform the join at each S-node} {R; from R-nodes; R is fully replicated at S-nodes}

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter3: Data Representation
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Algorithm 8.1: Parallel Nested Loop (PNL)
Input: R₁, R2, . . . , Rm: fragments of relation R
S1, S2,..., Sn: fragments of relation S;
JP: join predicate
Output: T1, T2, ..., Tn: result fragments
begin
end
for i from 1 to m in parallel do
send R; to each node containing a fragment of S
end for
for j from 1 to n in parallel do
R ← U₁1 R₁;
TjRAJP Sj
end for
{send R entirely to each S-node}
{perform the join at each S-node}
{R; from R-nodes; R is fully replicated at S-nodes}
Transcribed Image Text:Algorithm 8.1: Parallel Nested Loop (PNL) Input: R₁, R2, . . . , Rm: fragments of relation R S1, S2,..., Sn: fragments of relation S; JP: join predicate Output: T1, T2, ..., Tn: result fragments begin end for i from 1 to m in parallel do send R; to each node containing a fragment of S end for for j from 1 to n in parallel do R ← U₁1 R₁; TjRAJP Sj end for {send R entirely to each S-node} {perform the join at each S-node} {R; from R-nodes; R is fully replicated at S-nodes}
366
Node 1
R₁
R₁
R2
X
Node 3
S1
R₁
8 Parallel Database Systems
Node 2
R2
R2
Fig. 8.11 Example of parallel nested loop
X
Node 4
S₂
Transcribed Image Text:366 Node 1 R₁ R₁ R2 X Node 3 S1 R₁ 8 Parallel Database Systems Node 2 R2 R2 Fig. 8.11 Example of parallel nested loop X Node 4 S₂
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Quicksort
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning