Given:
Primary-Key relation, CUSTOMERS, R(NM,AGE,CTY,CD)
`-primary_key, non-clustered.
Foreign-key relation, PURCHASES, S(PO,NM,AMT,CTY)
R (CUSTOMERS)
rid NM AG CTY CD rid NM AG CTY CD rid NM AG CTY CD
0 hu 54 ffs N34 42 ih 14 wap Y12 84 fn 18 ffs N12
1 re 16 bis Y21 43 ii 17 gfs M43 85 bn 22 fgo M23
2 iq 7 bis M2 44 gn 17 wap Y21 86 da 35 gfs Y32
3 oi 25 mhd N21 45 qv 14 wap M2 87 jn 53 fgo Y12
4 fu 32 min N12 46 eq 34 ffs N21 88 mx 22 ffs M43
5 nn 12 min M23 47 os 17 dls N12 89 qq 77 gfs Y21
6 ez 38 min Y32 48 oo 99 fgo M23 90 kl 36 gfs M2
7 aa 54 fgo Y12 49 ri 34 ffs Y32 91 iy 23 fgo N21
8 fl 14 fgo M43 50 fm 17 dls Y12 92 nb 65 fgo N12
9 ar 75 bis Y23 51 an 14 min M43 93 kb 22 min M23
10 fx 82 bis M24 52 ou 15 zap Y23 94 ej 22 wap Y32
11 ls 99 wap N21 53 qr 55 fgo M24 95 sp 22 wap Y12
12 sd 81 fgo N12 54 dr 17 fgo N21 96 ak 23 mhd M43
13 su 67 gfs M23 55 cr 18 wap N12 97 rm 23 fgo Y23
14 ke 78 fgo Y32 56 dk 15 ffs M23 98 jo 37 gfs M24
15 fc 64 ffs Y12 57 ij 18 mhd Y32 99 em 78 gfs N21
16 op 77 fgo M43 58 mn 15 gfs Y12 100 oq 23 ffs N12
17 kz 55 gfs Y21 59 fe 45 ffs M43 101 en 65 fgo M23
18 sg 17 dls M2 60 lf 18 wap Y12 102 hs 53 fgo Y32
19 do 82 fgo N21 61 rq 15 dls M43 103 lz 36 ffs Y12
20 ng 34 ffs N12 62 pj 15 min Y21 104 gc 23 dls M43
21 nz 14 gfs M23 63 gg 15 gfs M2 105 nm 54 bis N34
22 gi 54 fgo Y32 64 is 35 ffs N21 106 lu 23 min Y21
23 lm 7 ffs Y12 65 jr 15 dls N12 107 dt 24 ffs M2
24 ob 18 fgo M43 66 jc 15 wap M23 108 ss 78 gfs N21
25 be 17 fgo Y23 67 el 55 fgo Y32 109 hj 65 fgo N12
26 aq 54 fgo M24 68 hf 22 fgo Y12 110 hz 53 fgo M23
27 qk 34 ffs N21 69 sf 15 ffs M43 111 hd 37 gfs Y32
28 cp 14 dls N12 70 ao 47 min Y23 112 ax 24 fgo Y12
29 oy 82 fgo M23 71 bd 15 wap M24 113 nq 64 bis M43
30 ge 17 zap Y32 72 jj 17 min N21 114 cz 24 wap Y23
31 gv 15 fgo Y12 73 mo 17 mhd N12 115 rz 24 min M24
32 lk 54 fgo M43 74 ja 17 dls M23 116 eo 67 fgo N21
33 tf 12 ffs Y32 75 rr 36 ffs Y32 117 gm 26 fgo N12
34 av 17 wap Y12 76 ea 17 min Y12 118 bc 26 ffs M23
35 ot 14 wap M43 77 am 17 min M43 119 az 53 fgo Y32
36 kd 55 fgo Y23 78 mf 17 gfs Y32 120 pm 63 bis Y12
37 ie 44 ffs M24 79 pb 17 wap Y12 121 dx 81 gfs M43
38 iw 99 fgo N21 80 qx 18 wap M43 122 mg 26 fgo Y21
39 oa 17 fgo N12 81 nd 64 fgo Y23 123 ad 24 fgo M2
40 js 52 ffs M23 82 ix 77 gfs M24 124 ev 26 mhd N21
41 le 17 dls Y32 83 tc 53 fgo N21 125 pd 24 wap N12
rid NM AG CTY CD rid NM AG CTY CD rid NM AG CTY CD
126 me 26 fgo M23 168 ra 56 bis M2 210 ki 34 wap N34
127 rf 24 fgo Y32 169 jt 25 wap N21 211 hw 34 dls Y21
128 mh 24 fgo Y12 170 mr 25 min N12 212 eg 52 ffs M2
129 ac 7 fgo M43 171 pl 64 fgo M23 213 qc 34 mhd N21
130 lj 74 fgo Y23 172 bf 25 wap Y32 214 ks 41 wap N12
131 ir 24 ffs M24 173 kv 53 bis Y12 215 rd 34 min M23
132 dq 26 fgo N21 174 ib 76 fgo M43 216 bm 51 bis Y32
133 fb 53 fgo N12 175 at 25 ffs Y23 217 ce 39 fgo Y12
134 ln 24 wap M23 176 jq 26 fgo M24 218 no 34 min M43
135 mm 26 wap Y32 177 ji 26 min N21 219 hm 34 mhd Y23
136 fv 24 min Y12 178 pa 52 ffs N12 220 qa 57 wap M24
137 ny 26 fgo M43 179 qp 76 fgo M23 221 iu 34 wap N21
138 gp 24 mhd Y32 180 ds 26 dls Y32 222 gq 28 bis N12
139 fk 26 fgo Y12 181 kp 47 ffs Y12 223 fz 47 bis M23
140 of 74 fgo M43 182 pi 26 min M43 224 bo 46 bis Y32
141 gx 25 ffs Y23 183 cf 53 bis Y32 225 sy 34 bis Y12
142 ig 26 fgo M24 184 kn 26 fgo Y12 226 al 51 bis M43
143 io 54 bis N21 185 dy 26 mhd M43 227 pg 37 bis Y21
144 ew 53 bis N12 186 pc 26 fgo Y23 228 qh 47 bis M2
145 aw 26 zap M23 187 lc 26 ffs M24 229 ap 36 bis N21
146 sh 25 wap Y32 188 ic 77 fgo N21 230 lb 35 bis N12
147 rt 75 fgo Y12 189 bz 26 ffs N12 231 bi 44 bis M23
148 jk 26 min M43 190 ml 81 fgo M23 232 ft 34 bis Y32
149 pn 25 ffs Y21 191 jp 81 fgo Y32 233 qd 36 bis Y12
150 co 26 fgo M2 192 qu 26 ffs Y12 234 sw 34 min M43
151 gz 25 dls N21 193 rw 26 mhd M43 235 kc 46 bis Y23
152 nj 26 wap N12 194 du 28 wap Y21 236 ns 45 bis M24
153 eh 37 ffs M23 195 sa 28 min M2 237 ik 31 bis N21
154 po 44 ffs Y32 196 mi 28 dls N21 238 fa 34 bis N12
155 od 42 ffs Y12 197 or 51 ffs N12 239 dc 34 bis M23
156 oz 25 dls M43 198 sb 53 bis M23 240 ht 47 bis Y32
157 au 26 dls Y23 199 jm 28 fgo Y32 241 rg 35 bis Y12
158 se 26 ffs M24 200 fo 31 wap Y12 242 mv 37 bis M43
159 ox 75 fgo N21 201 oc 31 dls M43 243 mt 36 bis Y32
160 bh 25 mhd N12 202 so 51 ffs Y23 244 ef 36 bis Y12
161 ry 26 min M23 203 cs 68 fgo M24 245 kk 34 fgo M43
162 jv 25 wap Y32 204 lg 31 zap N21 246 ms 44 min Y23
163 qf 26 min Y12 205 jy 52 bis N12 247 om 34 min M24
164 md 25 zap M43 206 ho 34 min M23 248 ne 34 fgo N21
165 sj 25 fgo Y12 207 hn 52 bis Y32 249 pt 22 gfs N12
166 gl 36 wap M43 208 mw 51 ffs Y12 250 cx 34 wap M23
167 eb 25 min Y21 209 ll 34 dls M43 251 la 44 fgo Y32
rid NM AG CTY CD rid NM AG CTY CD rid NM AG CTY CD
252 bw 34 fgo Y12 294 ia 45 gfs N12 336 ee 44 fgo M23
253 tb 26 gfs M43 295 gh 36 fgo M23 337 nk 53 gfs Y32
254 go 26 gfs Y21 296 hp 36 min Y32 338 ha 44 wap Y12
255 qs 44 fgo M2 297 ov 36 fgo Y12 339 kt 53 gfs M43
256 rv 25 gfs N21 298 lq 34 gfs M43 340 fi 44 fgo Y23
257 fy 34 fgo N12 299 et 36 wap Y21 341 nl 47 mhd M24
258 fd 53 ffs M23 300 sl 36 fgo M2 342 rj 47 dls N21
259 bu 34 fgo Y32 301 nh 36 wap N21 343 iv 47 zap N12
260 ci 45 dls Y12 302 pp 36 dls N12 344 ex 47 min M23
261 dp 25 gfs M43 303 gy 63 ffs M23 345 li 56 gfs Y32
262 kw 45 min Y23 304 sz 36 fgo Y32 346 ah 47 fgo Y12
263 pe 28 gfs M24 305 dl 36 dls Y12 347 cu 56 gfs M43
264 es 34 fgo N21 306 jx 36 mhd M43 348 td 47 fgo Y32
265 ag 34 wap N12 307 hb 36 zap Y23 349 dd 47 min Y12
266 qo 45 zap M23 308 jd 36 fgo M24 350 cb 47 min M43
267 ip 34 fgo Y32 309 bl 37 min N21 351 lv 51 min Y23
268 ay 28 gfs Y12 310 jz 37 min N12 352 ps 51 fgo M24
269 if 35 wap M43 311 cw 54 ffs M23 353 ow 54 gfs N21
270 hg 46 dls Y12 312 sn 37 dls Y32 354 iz 51 fgo N12
271 mj 53 ffs M43 313 ba 37 fgo Y12 355 bg 63 gfs M23
272 qt 35 dls Y21 314 mk 37 wap M43 356 dh 51 fgo Y32
273 ql 53 ffs M2 315 sc 37 fgo N34 357 hl 64 gfs Y12
274 ek 46 zap N21 316 pr 37 zap Y21 358 nc 67 gfs M43
275 lo 35 fgo N12 317 dw 37 wap M2 359 he 51 fgo Y21
276 ch 53 ffs M23 318 gs 37 min N21 360 ei 51 dls M2
277 qy 31 gfs Y32 319 il 42 min N12 361 ka 51 min N21
278 my 46 dls Y12 320 eu 43 gfs M23 362 gd 51 wap N12
279 ok 35 min M43 321 lh 42 fgo Y32 363 pq 52 wap M23
280 ab 34 gfs Y23 322 fp 42 fgo Y12 364 hc 52 fgo Y32
281 fw 35 min M24 323 jw 44 gfs M43 365 fr 74 gfs Y12
282 pu 46 fgo N21 324 qz 42 mhd Y23 366 er 52 wap M43
283 oh 34 gfs N12 325 ct 42 wap M24 367 sm 52 fgo Y23
284 sq 46 fgo M23 326 qe 43 min N21 368 jf 75 gfs M24
285 lr 47 mhd Y32 327 hq 43 min N12 369 kj 52 zap N21
286 cm 44 gfs Y12 328 rn 51 gfs M23 370 nf 52 dls N12
287 cn 35 fgo M43 329 ni 43 fgo Y32 371 bk 52 min M23
288 ma 54 ffs Y32 330 qb 52 gfs Y12 372 sx 52 min Y32
289 ae 35 dls Y12 331 ta 43 fgo M43 373 mu 52 fgo Y12
290 nx 35 zap M43 332 by 43 dls Y21 374 fj 35 gfs M43
291 sk 44 gfs Y23 333 bv 52 gfs M2 375 aj 77 gfs Y12
292 bx 36 fgo M24 334 km 43 fgo N21 376 on 47 bis M43
293 bj 36 min N21 335 nw 44 wap N12 377 gu 26 bis Y21
rid NM AG CTY CD rid NM AG CTY CD rid NM AG CTY CD
378 gr 53 min M2 420 rs 54 wap M43 462 kx 76 min M23
379 ko 53 dls N21 421 kh 64 dls Y23 463 ff 22 dls Y32
380 hv 12 ffs N12 422 qi 54 fgo M24 464 nt 76 ffs Y12
381 jb 14 ffs M23 423 rp 14 fgo N21 465 nu 77 ffs M43
382 hx 53 wap Y32 424 pz 64 fgo N12 466 lt 25 min Y23
383 qn 53 wap Y12 425 qw 17 fgo M23 467 ky 17 min M24
384 cq 17 ffs M43 426 sv 64 min Y32 468 df 39 min N21
385 np 53 min Y23 427 ey 54 min Y12 469 gb 77 ffs N12
386 ld 14 ffs M24 428 kq 54 wap M43 470 ck 44 zap M23
387 dj 14 ffs N21 429 og 54 wap Y12 471 fg 33 wap Y32
388 nr 53 fgo N12 430 dg 23 bis M43 472 di 22 bis Y12
389 cy 7 fgo M23 431 nv 55 dls Y21 473 rl 62 zap M43
390 qg 53 min Y32 432 id 26 dls M2 474 hi 78 wap N34
391 kr 12 fgo Y12 433 bp 55 ffs N21 475 pw 42 dls Y21
392 pv 55 fgo M43 434 hh 31 ffs N12 476 bq 38 ffs M2
393 lx 14 fgo Y32 435 mz 55 wap M23 477 na 78 zap N21
394 cl 55 fgo Y12 436 fh 49 zap Y32 478 gw 17 bis N12
395 dv 53 fgo M43 437 pk 17 bis Y12 479 ph 81 min M23
396 fq 56 wap Y23 438 sr 55 wap M43 480 qj 12 bis Y32
397 gf 14 fgo M24 439 hy 64 zap Y23 481 gt 81 min Y12
398 im 56 min N21 440 ku 64 mhd M24 482 bb 25 dls M43
399 ed 25 bis N12 441 qm 38 dls N21 483 it 82 dls Y23
400 ca 53 wap M23 442 cg 64 ffs N12 484 af 31 ffs M24
401 mp 25 bis Y32 443 bt 64 zap M23 485 rh 79 ffs N21
402 pf 53 mhd Y12 444 ly 15 bis Y32 486 ol 82 min N12
403 oe 56 wap M43 445 st 65 mhd Y12 487 mc 22 wap M23
404 jh 25 bis Y21 446 px 52 ffs M43 488 gk 31 ffs Y32
405 je 54 wap M2 447 kf 65 ffs Y32 489 lp 36 wap Y12
406 ju 63 fgo N21 448 br 49 dls Y12 490 as 82 ffs M43
407 ro 17 fgo N12 449 dz 15 bis M43 491 db 3 mhd Y21
408 rc 54 min M23 450 py 67 wap Y23 492 rx 17 bis M2
409 si 63 zap M23 451 kg 67 ffs M24 493 ru 82 wap N21
410 mq 63 min Y32 452 bs 23 wap N21 494 jg 26 mhd N12
411 hr 26 bis Y12 453 hk 67 wap N12 495 ai 99 wap M23
412 jl 24 bis M43 454 in 74 min M23 496 de 31 min Y32
413 te 54 dls Y21 455 rb 74 min Y32 497 ga 26 ffs Y12
414 ec 63 min M2 456 cv 74 mhd Y12 498 cd 12 bis M43
415 dm 54 wap N21 457 gj 75 dls M43 499 rk 22 wap Y23
416 ep 64 dls N12 458 lw 17 bis Y21
417 fs 54 mhd M23 459 dn 75 zap M2
418 cc 54 min Y32 460 mb 75 dls N21
419 oj 24 bis Y12 461 cj 19 wap N12
DV(S.NM)... _______ S (PURCHASES)_____ ... ___________________
vid rid vid rid rid PO NM AMT CTY rid PO NM AMT CTY
13 9 224 2 0 3 jo 14 bis 29 29 ab 154 min
13 1 280 55 1 1 su 143 ffs 30 31 jo 17 wap
13 35 280 42 2 2 bo 7 wap 31 32 jo 15 ffs
13 32 280 16 3 5 ab 18 dls 32 33 su 214 fgo
17 24 280 29 4 4 bo 17 dls 33 34 li 12 wap
17 44 280 3 5 6 jo 54 bis 34 35 na 8 gfs
20 17 345 33 6 7 na 34 gfs 35 36 su 14 wap
20 43 345 7 7 8 li 127 min 36 37 cy 143 wap
20 23 354 37 8 9 na 154 min 37 38 iz 164 fgo
20 56 354 27 9 11 su 17 bis 38 39 di 99 mhd
73 13 354 21 10 10 di 15 bis 39 40 mo 17 wap
73 18 354 11 11 12 iz 243 ffs 40 42 mo 52 dls
73 39 354 47 12 13 di 12 wap 41 41 hi 6 fgo
73 40 354 50 13 14 mo 17 dls 42 43 ab 14 fgo
73 14 389 36 14 15 mo 14 dls 43 44 ng 17 bis
73 53 389 49 15 16 hi 53 dls 44 45 kz 17 ffs
73 52 472 12 16 17 ab 211 wap 45 46 jo 67 wap
98 19 472 38 17 18 ng 99 mhd 46 47 bo 3 dls
98 0 472 10 18 20 mo 17 bis 47 51 iz 17 dls
98 4 472 48 19 19 jo 52 bis 48 49 di 24 dls
98 31 472 51 20 21 bo 17 fgo 49 50 cy 53 wap
98 45 472 22 21 22 iz 14 wap 50 48 iz 15 wap
98 30 474 41 22 23 di 5 wap 51 52 di 17 bis
98 25 474 54 23 24 ng 17 mhd 52 53 mo 17 bis
224 5 474 15 24 25 kz 14 ffs 53 54 mo 44 fgo
224 28 477 8 25 26 jo 34 wap 54 55 hi 36 wap
224 46 477 6 26 27 bo 17 wap 55 56 ab 123 fgo
224 26 477 34 27 30 iz 34 bis 56 57 ng 111 mhd
224 20 28 28 bo 76 dls
DV(S.NM) in list form: 13,17,20,73,98,224,280,345,354,389,472,474,477
DV(S.NM) in bit-vector form (bits only):
0000 0000 0000 0100 0100 1000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0100 0000 0000 0000 0000 0000 0010 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 1000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 1000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 1010 0100 0000 0000 0000 0000 0000
As an initial example of the use of DVs, let's look at RjoinS on NM.
(Note that the file Record-Map (RM) is just an ordered list of the tuples containing
participating records (which result from applying the JV 1-bit positions to the DVI indexes)
and is created to minimize paging at 1.6 and 4.6. If the DVI indexes happen to be
a clustered index on A, then the TVs are unnecessary.)
_____ #1# _____
DV(R.A)|_____| - - -> AND <- - - - - |_____|DV(S.A)
v
.------.
|__JV__|
. - - - - #1.2- - - -' ` - - -#4.2 - .
:/ _R______ :/ _S______
/ | | | #2# / | | | |
/ | | |>- - - -- . / | | | |
DVI | | | . DVI | | | |
\ | | | #1.6 . \ | |A| |
\ |A|______|<---. . \ | | | |
`. . . \ | | | |
. . . \ |____|_|_|
#1.4. . . #4.4 .' ^ .
. .____________' . .___________v : .
`->|RM(RjoinS.NM| . |RM(RjoinS.NM| -' .
. #4.6 .#4.8
. .
.< - - - - - - - - - -'
v
h(A) __OUT___
. .- ->|________|
. .--------.
.-R0|>k(A)-> | __R1____ __S1____
. |Internal| | || |
. | Hash | ->|________||________|
. | Table | '- -> ` - - ` - ->.
. |________| #3# '#5# __R2____ __S2____ .
.-R1|________|- - ' | || | .
.-R2|________|- - - - ->|________||________| .
. . ` - - ` - ->:
. . .
. ________ __RB____ __SB____ .
`>RB|________|- - - - ->| || | .
|________||________| .
` - - ` - ->:
#6# #8# .
__IN____ :
|________| < - - - - - - - - - - - - - - -
.
k'(A)
. .--R0----. _OUT____
#7# `->| | |________|
#9# | | - > - - - - - - - '
|________|
In this first example, the JV is identical to DV(S.NM) since DV(R.NM) is all 1-bits.
Therefore JV = DV(S.NM) in list form: 13,17,20,73,98,224,280,345,354,389,472,474,477
This is also RM(RjoinS.NM) since we used R(NM,rid) as the DVT for these RVs (that is, the vids are the R.rids)
Therefore we need to read only these 13 records from R.
We know we need to read all records from S since S.NM is a foreign key to R.NM.
*******************************
Assume we have been allocated 160 bytes of main memory to do the join.
Assume each disk page contains 30 bytes (three 10-byte records).
Set B = 1, that is, we will have the following buffers:
IN (30 bytes)
OUT (30 bytes)
R1 (30 bytes)
R0 (70 bytes) (thus, the internal hash table will have 7 record buckets)
Assume the hash function h is Mod2 applied to the sum of the letter sequence numbers indicated with '; e.g.,
a'=0 f'=5 k'=10 p'=15 u'=20 z'=25
b'=1 g'=6 l'=11 q'=16 v'=21
c'=2 h'=7 m'=12 r'=17 w'=22
d'=3 i'=8 n'=13 s'=18 x'=23
e'=4 j'=9 o'=14 t'=19 y'=24
Assume hash function k is Mod7 applied to the sum of the letter sequence numbers indicated with ';
Read the first participating page of R (5th page, containing records 12,13 and 14):
RM on pg, with records
.----------------------. V V VVVVVVVVVVV
|0: R0 13 4 12, 13, 14 <-- page currently in IN-buffer
|1: | 17 5 15, 16, 17
|2: | 20 6 18, 19, 20
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| R1 354 118 354,355,356
| | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|----------------------| 477 159 477,478,479
|12 sd 81 fgo N12 IN
|13 su 67 gfs M23 | <-- h(su)=Mod2(s'+u')=Mod2(18+20)=(Mod2(38)=0, copied to R0 at k(su)=Mod7(38)=3
|14 ke 78 fgo Y32 |
|======================|
| OUT
| |
| |
`----------------------'
Read next participant page to IN:
RM on pg, with records
.----------------------. V V VVVVVVVVVVV
|0: R0 13 4 12, 13, 14
|1: | 17 5 15, 16, 17 <-- page currently in IN-buffer
|2: | 20 6 18, 19, 20
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| kz 55 gfs Y21 R1 354 118 354,355,356
| | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
|15 fc 64 ffs Y12 |
|16 op 77 fgo M43 |
|17 kz 55 gfs Y21 |<- h(kz)=Mod2(k'+z')=Mod2(10+25)=(Mod2(35)=1, copied to R1.
|======================|
| OUT
| |
| |
`----------------------'
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 <- z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| kz 55 gfs Y21 R1 354 118 354,355,356
| ng 34 ffs N12 | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
|18 sg 17 dls M2 |
|19 do 82 fgo N21 |
|20 ng 34 ffs N12 | <- h(ng)==Mod2(n'g')=Mod2(13+6)=Mod2(19)=1, copied to R1.
|======================|
| OUT
| |
| |
`----------------------'
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74 <-
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| kz 55 gfs Y21 R1 354 118 354,355,356
| ng 34 ffs N12 | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
|72 jj 17 min N21 |
|73 mo 17 mhd N12 | <- h(mo)=Mod2(m'+o')=Mod2(12+14)=(Mod2(26)=0, copied to R0 at k(mo)=Mod7(26)=5
|74 ja 17 dls M23 |
|======================|
| OUT
| |
| |
`----------------------'
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98 <-
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| kz 55 gfs Y21 R1 354 118 354,355,356
| ng 34 ffs N12 | 389 129 387,388,389
| jo 37 gfs M24 | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
|96 ak 23 mhd M43 |
|97 rm 23 fgo Y23 |
|98 jo 37 gfs M24 | <- h(jo)=Mod2(j'o')=Mod2(9+14)=Mod2(23)=1, copied to R1
|======================|
| OUT
| |
| |
`----------------------'
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226 <-
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| bo 46 bix Y32 R1 354 118 354,355,356
| | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
| 224 bo 46 bis Y32 | <- h(bo)=Mod2(b'o')=Mod2(1+14)=Mod2(15)=1, copied to R1 (after R1 is
| 225 sy 34 bis Y12 | flushed to a temporary file (also called R1) to make room).
| 226 al 51 bis M43 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: | 280 93 279,280,281 <-
|----------------------| 345 115 345,346,347
| bo 46 bix Y32 R1 354 118 354,355,356
| ab 34 gfs Y23 | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
| 279 ok 35 min M43 |
| 280 ab 34 gfs Y23 | <- h(ab)=Mod2(a'b')=Mod2(0+1)=Mod2(1)=1, copied to R1.
| 281 fw 35 min M24 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347 <-
| bo 46 bix Y32 R1 354 118 354,355,356
| ab 34 gfs Y23 | 389 129 387,388,389
| li 56 gfs Y32 | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
| 345 li 56 gfs Y32 | <- h(li)=Mod2(l'+i')=Mod2(11+8)=Mod2(19)=1, copied to R1.
| 346 ah 47 fgo Y12 |
| 347 cu 56 gfs M43 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| R1 354 118 354,355,356 <-
| | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
| 354 iz 51 fgo N12 | <- h(iz)=Mod2(=Mod2(8+25)=Mod2(33)=1, copied to R1 (after flushing R1).
| 355 bg 63 gfs M23 |
| 356 dh 51 fgo Y32 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: cy 7 fgo M23 | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| R1 354 118 354,355,356
| | 389 129 387,388,389 <-
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
| 387 dj 14 ffs N21 |
| 388 nr 53 fgo N12 |
| 389 cy 7 fgo M23 | <- h(cy)=Mod2(c'+y')=Mod2(2+24)=Mod2(26)=0 copied to R0 at k(cy)=Mod7(26)=5,
|======================| Collision! Open Addressing specifies 6.
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: cy 7 fgo M23 | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| di 22 bis Y12 R1 354 118 354,355,356
| | 389 129 387,388,389
| | 472 157 471,472,473 <-
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479
| 471 fg 33 wap Y32 |
| 472 di 22 bis Y12 | <- h(di)=Mod2(d'+i')=Mod2(3+8)=Mod2(11)=1.
| 473 rl 62 zap M43 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: cy 7 fgo M23 | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| di 22 bis Y12 R1 354 118 354,355,356
| hi 78 wap N34 | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476 <-
|-------------------IN-| 477 159 477,478,479
| 474 hi 78 wap N34 | <- h(hi)=Mod2(h'i')=Mod2(7+8)=Mod2(15)=1.
| 475 pw 42 dls Y21 |
| 476 bq 38 ffs M2 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
Read next participant page to IN: a'=0 f'=5 k'=10 p'=15 u'=20
RM on pg, with records b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. V V VVVVVVVVVVV c'=2 h'=7 m'=12 r'=17 w'=22
|0: R0 13 4 12, 13, 14 d'=3 i'=8 n'=13 s'=18 x'=23
|1: | 17 5 15, 16, 17 e'=4 j'=9 o'=14 t'=1 y'=24
|2: | 20 6 18, 19, 20 z'=25
|3: su 67 gfs M23 | 73 24 72, 73, 74
|4: | 98 32 96, 97, 98
|5: mo 17 mdh N12 | 224 74 224,225,226
|6: cy 7 fgo M23 | 280 93 279,280,281
|----------------------| 345 115 345,346,347
| R1 354 118 354,355,356
| | 389 129 387,388,389
| | 472 157 471,472,473
|______________________| 474 158 474,475,476
|-------------------IN-| 477 159 477,478,479 <-
| 477 na 78 zap N21 | <- h(na)=Mod2(n'+a')=Mod2(13+0)=Mod2(13)=1, copied to R1, then R1
| 478 gw 17 bis N12 | is flushed to prepare memory for Build-phase on S.
| 479 ph 81 min M23 |
|======================|
| OUT
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
| di 22 bis Y12 |
| hi 78 wap N34 |
| na 78 zap N21 |
********************************************** BUILD PHASE OF S ************************
Read first page of S (all pages participates) to IN: a'=0 f'=5 k'=10 p'=15 u'=20
b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: | e'=4 j'=9 o'=14 t'=1 y'=24
|2: | z'=25
|3: su 67 gfs M23 |
|4: |
|5: mo 17 mdh N12 |
|6: cy 7 fgo M23 |
|----------------------|
| 3 jo 14 bis R1
| 2 bo 7 wap |
| |
|______________________|
|-------------------IN-|
| 0 3 jo 14 bis | <- h(jo)=Mod2(j'+o')=Mod2(9+14) =Mod2(23)=1, copy to R1.
| 1 1 su 143 ffs | <- h(su)=Mod2(s'+u')=Mod2(18+20)=Mod2(38)=0, search at k(38)=Mod7(38)=3.
| 2 2 bo 7 wap | <- h(bo)=Mod2(b'+o')=Mod2(1+14) =Mod2(15)=1, copy to R1.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|su 67 gfs M23 143 ffs|
| | .Temp_File_R1__________.
| | | kz 55 gfs Y21 |
`----------------------' | ng 34 ffs N12 |
| jo 37 gfs M24 |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
| di 22 bis Y12 |
| hi 78 wap N34 |
| na 78 zap N21 |
Read next page of S to IN: a'=0 f'=5 k'=10 p'=15 u'=20
b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: | e'=4 j'=9 o'=14 t'=1 y'=24
|2: | z'=25
|3: su 67 gfs M23 |
|4: |
|5: mo 17 mdh N12 |
|6: cy 7 fgo M23 |
|----------------------R1
| 2 bo 7 wap |
| 5 ab 18 dls |
| 6 jo 54 bis |
|______________________|
|-------------------IN-|
| 3 5 ab 18 dls | <- h(ab)=Mod2(a'+b')=Mod2(0+1) =Mod2(1)=0; copy to R1.
| 4 4 bo 17 dls | <- h(bo)=Mod2(b'+o')=Mod2(1+14) =Mod2(15)=1; flush R1; copy to R1.
| 5 6 jo 54 bis | <- h(jo)=Mod2(j'+o')=Mod2(9+14) =Mod2(23)=1, copy to R1.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|su 67 gfs M23 143 ffs|
| | .Temp_File_R1__________. .Temp_File_S1__________.
| | | kz 55 gfs Y21 | | 3 jo 14 bis |
`----------------------' | ng 34 ffs N12 | | 2 bo 7 wap |
| jo 37 gfs M24 | | 5 ab 18 dls |
| bo 46 bix Y32 |
| ab 34 gfs Y23 |
| li 56 gfs Y32 |
| di 22 bis Y12 |
| hi 78 wap N34 |
| na 78 zap N21 |
Read next page of S to IN: a'=0 f'=5 k'=10 p'=15 u'=20
b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: | e'=4 j'=9 o'=14 t'=1 y'=24
|2: | z'=25
|3: su 67 gfs M23 |
|4: |
|5: mo 17 mdh N12 |
|6: cy 7 fgo M23 |
|----------------------R1
| 7 na 34 gfs |
| 8 li 127 min |
| 9 na 154 min |
|______________________|
|-------------------IN-|
| 6 7 na 34 gfs | <- h(na)=Mod2(n'+a')=Mod2(13+0)=Mod2(13)=1, flush R1; copied to R1.
| 7 8 li 127 min | <- h(li)=Mod2(l'+i')=Mod2(11+8)=Mod2(19)=1, copied to R1.
| 8 9 na 154 min | <- h(na)=Mod2(n'+a')=Mod2(13+0)=Mod2(13)=1, copied to R1.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|su 67 gfs M23 143 ffs|
| | .Temp_File_R1__________. .Temp_File_S1__________.
| | | kz 55 gfs Y21 | | 3 jo 14 bis |
`----------------------' | ng 34 ffs N12 | | 2 bo 7 wap |
| jo 37 gfs M24 | | 5 ab 18 dls |
| bo 46 bix Y32 | | 2 bo 7 wap |
| ab 34 gfs Y23 | | 5 ab 18 dls |
| li 56 gfs Y32 | | 6 jo 54 bis |
| di 22 bis Y12 |
| hi 78 wap N34 |
| na 78 zap N21 |
Read next page of S to IN: a'=0 f'=5 k'=10 p'=15 u'=20
b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: | e'=4 j'=9 o'=14 t'=1 y'=24
|2: | z'=25
|3: su 67 gfs M23 |
|4: |
|5: mo 17 mdh N12 |
|6: cy 7 fgo M23 |
|----------------------R1
| 10 di 15 bis |
| 12 iz 243 ffs |
| |
|______________________|
|-------------------IN-|
| 9 11 su 17 bis | <- h(su)=Mod2(s'+u')=Mod2(18+20)=Mod2(38)=0, search k(38)=Mod7(38)=3; concatenate to OUT.
|10 10 di 15 bis | <- h(di)=Mod2(d'+i')=Mod2(3+8)=Mod2(11)=1; flush R1; copy to R1.
|11 12 iz 243 ffs | <- h(iz)=Mod2(=Mod2(8+25)=Mod2(33)=1, copied to R1.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|su 67 gfs M23 143 ffs |
|su 67 gfs M23 17 bis | .Temp_File_R1__________. .Temp_File_S1_________.
| | | kz 55 gfs Y21 | | 3 jo 14 bis |
`----------------------' | ng 34 ffs N12 | | 2 bo 7 wap |
| jo 37 gfs M24 | | 5 ab 18 dls |
| bo 46 bix Y32 | | 2 bo 7 wap |
| ab 34 gfs Y23 | | 5 ab 18 dls |
| li 56 gfs Y32 | | 6 jo 54 bis |
| di 22 bis Y12 | | 7 na 34 gfs |
| hi 78 wap N34 | | 8 li 127 min |
| na 78 zap N21 | | 9 na 154 min |
Read next page of S to IN: a'=0 f'=5 k'=10 p'=15 u'=20
b'=1 g'=6 l'=11 q'=16 v'=21
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: | e'=4 j'=9 o'=14 t'=1 y'=24
|2: | z'=25
|3: su 67 gfs M23 |
|4: |
|5: mo 17 mdh N12 |
|6: cy 7 fgo M23 |
|----------------------R1
| 10 di 15 bis |
| 12 iz 243 ffs |
| |
|______________________|
|-------------------IN-|
12 13 di 12 wap | <- h(di)=Mod2(d'+i')=Mod2(3+8)=Mod2(11)=1.
13 14 mo 17 dls | <- h(mo)=Mod2(m'+o')=Mod2(12+14)=(Mod2(26)=0, search at k(mo)=Mod7(26)=5, concat to OUT.
14 15 mo 14 dls | <- h(mo)=Mod2(m'+o')=Mod2(12+14)=(Mod2(26)=0, search at 5, flush OUT; concat to OUT.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|mo 17 mdh N12 14 dls|
| | .Temp_File_R1__________. .Temp_File_S1_________.
| | | kz 55 gfs Y21 | | 3 jo 14 bis |
`----------------------' | ng 34 ffs N12 | | 2 bo 7 wap |
| jo 37 gfs M24 | | 5 ab 18 dls |
._RESULT_FILE__________. | bo 46 bix Y32 | | 2 bo 7 wap |
|su 67 gfs M23 143 ffs | | ab 34 gfs Y23 | | 5 ab 18 dls |
|su 67 gfs M23 17 bis | | li 56 gfs Y32 | | 6 jo 54 bis |
|mo 17 mdh N12 17 dls | | di 22 bis Y12 | | 7 na 34 gfs |
| hi 78 wap N34 | | 8 li 127 min |
| na 78 zap N21 | | 9 na 154 min |
Etc. until the entire S file has been processed in Phase 1.
***********************************
Then begin Phase-2 with building R1:
.Temp_File_R1__________. .Temp_File_S1_________.
| kz 55 gfs Y21 | | 3 jo 14 bis |
| ng 34 ffs N12 | | 2 bo 7 wap |
| jo 37 gfs M24 | | 5 ab 18 dls |
| bo 46 bix Y32 | | 2 bo 7 wap |
| ab 34 gfs Y23 | | 5 ab 18 dls |
| li 56 gfs Y32 | | 6 jo 54 bis |
| di 22 bis Y12 | | 7 na 34 gfs |
| hi 78 wap N34 | | 8 li 127 min |
| na 78 zap N21 | | 9 na 154 min |
| . |
| . |
| . |
k(ab)=Mod11(a'+b')
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: jo 37 gfs M24 | e'=4 j'=9 o'=14 t'=1 y'=24
|2: kz 55 gfs Y21 | z'=25
|3: |
|4: |
|5: |
|6: |
|7: |
|8: ng 34 ffs N12 |
|9: |
10: |
|______________________|
|-------------------IN-|
| kz 55 gfs Y21 |<- h(kz)=Mod11(k'+z')=Mod11(10+25)=Mod11(35)=2, copy to slot 2.
| ng 34 ffs N12 |<- h(ng)=Mod11(n'+g')=Mod11(13+6) =Mod11(19)=8, copy to slot 8.
| jo 37 gfs M24 |<- h(jo)=Mod11(j'+o')=Mod11(9+14) =Mod11(23)=1, copy to slot 1.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
| |
| |
| |
`----------------------'
Read next page of R1 to IN:
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: | d'=3 i'=8 n'=13 s'=18 x'=23
|1: jo 37 gfs M24 | e'=4 j'=9 o'=14 t'=1 y'=24
|2: kz 55 gfs Y21 | z'=25
|3: bo 46 bix Y32 |
|4: ab 34 gfs Y23 |
|5: |
|6: |
|7: |
|8: ng 34 ffs N12 |
|9: li 56 gfs Y32 |
10: |
|______________________|
|-------------------IN-|
| bo 46 bix Y32 | <- h(bo)=Mod11(b'+o')=Mod11(1+14) =Mod11(15)=1; collision! Open-adr specifies 3.
| ab 34 gfs Y23 | <- h(ab)=Mod11(a'+b')=Mod11(0+1) =Mod11(1)=1; collision! Open-adr specifies 4.
| li 56 gfs Y32 | <- h(li)=Mod11(l'+i')=Mod11(11+8) =Mod11(19)=8, collision! Open-adr specifies 9.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
| |
| |
| |
`----------------------'
Read next page of R1 to IN:
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: di 22 bis Y12 | d'=3 i'=8 n'=13 s'=18 x'=23
|1: jo 37 gfs M24 | e'=4 j'=9 o'=14 t'=1 y'=24
|2: kz 55 gfs Y21 | z'=25
|3: bo 46 bix Y32 |
|4: ab 34 gfs Y23 |
|5: hi 78 wap N34 |
|6: na 78 zap N21 |
|7: |
|8: ng 34 ffs N12 |
|9: li 56 gfs Y32 |
10: |
|______________________|
|-------------------IN-|
| di 22 bis Y12 | <- h(di)=Mod11(d'+i')=Mod11(3+8) =Mod11(11)=0; copy to slot 0.
| hi 78 wap N34 | <- h(hi)=Mod11(h'+i') =Mod11(7+8)=Mod11(15)=4; collision! Open-Adr specifies 5.
| na 78 zap N21 | <- h(na)=Mod11(n'+a')=Mod11(13+0)=Mod11(13)=2, collision! Open-Adr specifies 6.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
| |
| |
| |
`----------------------'
Begin the Probe Phase on S1:
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: di 22 bis Y12 | d'=3 i'=8 n'=13 s'=18 x'=23
|1: jo 37 gfs M24 | e'=4 j'=9 o'=14 t'=1 y'=24
|2: kz 55 gfs Y21 | z'=25
|3: bo 46 bix Y32 |
|4: ab 34 gfs Y23 |
|5: hi 78 wap N34 |
|6: na 78 zap N21 |
|7: |
|8: ng 34 ffs N12 |
|9: li 56 gfs Y32 |
10: |
|______________________|
|-------------------IN-|
| 3 jo 14 bis | <- h(jo)=Mod11(j'+o')=Mod11(9+14) =Mod11(23)=1, search R0 at 1; concat to OUT.
| 2 bo 7 wap | <- h(bo)=Mod11(b'+o')=Mod11(1+14) =Mod11(15)=1; search R0 at 1; found at 3; concat to OUT.
| 5 ab 18 dls | <- h(ab)=Mod11(a'+b')=Mod11(0+1) =Mod11(1)=1; search R0 at 1; found at 4; concat to OUT.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|jo 37 gfs M24 14 bis|
|bo 46 bix Y32 7 wap|
|ab 34 gfs Y23 18 dls|
`----------------------'
Read next page of S1:
.----------------------. c'=2 h'=7 m'=12 r'=17 w'=22
|0: di 22 bis Y12 | d'=3 i'=8 n'=13 s'=18 x'=23
|1: jo 37 gfs M24 | e'=4 j'=9 o'=14 t'=1 y'=24
|2: kz 55 gfs Y21 | z'=25
|3: bo 46 bix Y32 |
|4: ab 34 gfs Y23 |
|5: hi 78 wap N34 |
|6: na 78 zap N21 |
|7: |
|8: ng 34 ffs N12 |
|9: li 56 gfs Y32 |
10: |
|______________________|
|-------------------IN-|
| 2 bo 7 wap | <- h(bo)=Mod11(b'+o')=Mod11(1+14) =Mod11(15)=1; search R0 at 1; found at 3; flush OUT; concat to OUT.
| 5 ab 18 dls | <- h(ab)=Mod11(a'+b')=Mod11(0+1) =Mod11(1)=1; search R0 at 1; found at 4; concat to OUT.
| 6 jo 54 bis | <- h(jo)=Mod11(j'+o')=Mod11(9+14) =Mod11(23)=1, search R0 at 1; concat to OUT.
|======================OUT
NM AGE R.CTY CD AMT S.CTY
|bo 46 bix Y32 7 wap|
|ab 34 gfs Y23 18 dls|
|jo 37 gfs M24 54 bis|
`----------------------'
._RESULT_FILE__________.
NM AGE R.CTY CD AMT S.CTY
|su 67 gfs M23 143 ffs |
|su 67 gfs M23 17 bis |
|mo 17 mdh N12 17 dls |
| . |
| . |
| . |
|jo 37 gfs M24 14 bis|
|bo 46 bix Y32 7 wap|
|ab 34 gfs Y23 18 dls|
Etc, until all of S1 is probed. Done.
**********************************************************************************
For completeness and comparison purposes, additional information on the value surrogate
structures is given here:
DV(R.NM) is unnecessary since it is a string of 500 1-bits, however for completeness, here it is:
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111 1111
DV(S.NM) in bit-vector form (with every 4th position number appended above the position):
0 4 8 12 16 20 24 28 32 36 40 44 48 52 56 60
0000 0000 0000 0100 0100 1000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
64 68 72 76 80 84 88 92 96 100 104 108 112 116 120 124
0000 0000 0100 0000 0000 0000 0000 0000 0010 0000 0000 0000 0000 0000 0000 0000
128 132 136 140 144 148 152 156 160 164 168 172 176 180 184 188
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
192 196 200 204 208 212 216 220 224 228 232 236 240 244 248 252
0000 0000 0000 0000 0000 0000 0000 0000 1000 0000 0000 0000 0000 0000 0000 0000
256 260 264 268 272 276 280 284 288 292 296 300 304 308 312 316
0000 0000 0000 0000 0000 0000 1000 0000 0000 0000 0000 0000 0000 0000 0000 0000
320 324 328 332 336 340 344 348 352 356 360 364 368 372 376 380
0000 0000 0000 0000 0000 0000 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000
384 388 392 396 400 404 408 412 416 420 424 428 432 436 440 444
0000 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
448 452 456 460 464 468 472 476 480 484 488 492 496
0000 0000 0000 0000 0000 0000 1010 0100 0000 0000 0000 0000 0000
DV(R.NM) in list form: 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,
25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,
55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,
85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,
115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,
145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,
175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,
205,206,207,208,209,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,
325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,
355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,
385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400 401,402,403,404,405,406,407,408,409,410,411,412,413,414,
415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,
445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474.
475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499
***********************************************************************************
Supoose the next month the PURCHASE file is T below:
DV(T.NM)... _______ T (PURCHASES)_____ ... ___________________
vid rid vid rid rid PO NM AMT CTY rid PO NM AMT CTY
22 58 194 3 0 88 ac 7 fgo 43 86 rf 24 fgo
27 17 195 4 1 474 ec 63 mhd 44 472 jl 24 bis
53 31 196 29 2 76 gm 26 fgo 45 85 me 26 fgo
54 8 238 62 3 254 du 28 wap 46 479 oj 24 bis
107 40 239 23 4 255 sa 28 min 47 333 ql 53 ffs
109 73 241 77 5 448 nr 53 gfs 48 90 ir 24 ffs
110 80 245 83 6 83 ev 26 ffs 49 72 nq 128 bis
111 71 267 78 7 233 kv 35 bis 50 407 cu 56 gfs
112 36 269 42 8 154 dr 95 fgo 51 84 pd 24 fgo
113 49 273 47 9 98 de 31 min 52 337 qy 31 gfs
115 75 275 35 10 79 pm 63 wap 53 551 db 3 mhd
117 2 277 52 11 466 ju 63 fgo 54 242 pi 26 min
118 33 318 13 12 473 te 54 dls 55 230 mr 96 min
119 28 328 24 13 541 gt 81 min 56 237 ji 26 min
120 10 337 15 14 512 bs 23 wap 57 464 jh 185 bis
121 21 345 41 15 397 nk 53 gfs 58 22 gi 54 fgo
122 26 347 50 16 471 hr 26 bis 59 243 cf 53 bis
123 61 370 32 17 27 qk 34 ffs 60 544 af 31 ffs
124 6 377 65 18 482 qi 54 fgo 61 82 ad 24 fgo
125 51 378 39 19 539 ph 81 min 62 298 fa 34 bis
126 45 388 5 20 451 kr 12 fgo 63 470 mq 63 min
127 43 389 67 21 80 dx 81 fgo 64 253 rw 26 mhd
128 22 391 20 22 87 mh 24 fgo 65 437 gu 26 fgo
129 0 394 37 23 299 dc 34 bis 66 240 ds 26 dls
131 48 404 57 24 388 rn 51 gfs 67 449 cy 7 fgo
132 70 406 11 25 116 au 26 dls 68 225 sj 25 fgo
133 76 409 84 26 81 mg 26 gfs 69 245 dy 26 mhd
134 38 410 63 27 244 kn 26 fgo 70 91 dq 26 fgo
135 72 411 16 28 78 az 53 fgo 71 70 hd 126 gfs
157 25 412 44 29 25 mi 28 dls 72 94 mm 26 wap
160 74 413 12 30 475 dm 54 wap 73 68 hj 124 fgo
165 68 414 1 31 153 qr 55 fgo 74 119 bh 25 mhd
168 82 415 30 32 430 nf 52 dls 75 74 rz 24 min
170 55 419 46 33 77 bc 26 ffs 76 92 fb 400 fgo
173 7 422 18 34 554 jg 26 mhd 77 559 rk 22 wap
177 56 452 14 35 335 lo 35 fgo 78 56 ip 34 fgo
178 79 479 19 36 71 ax 127 fgo 79 238 pa 26 ffs
180 66 484 60 37 454 cl 55 fgo 80 69 hz 125 fgo
182 54 491 53 38 93 ln 24 wap 81 557 ga 26 ffs
183 59 494 34 39 438 gr 53 min 82 43 ra 32 bis
184 27 496 9 40 66 dt 24 ffs 83 305 kk 34 fgo
185 69 497 81 41 405 li 56 gfs 84 469 si 63 zap
193 64 42 329 if 177 wap
DV(T,NM) in bit form is:
0000 0000 0000 0000 0000 0010 0001 0000 0000 0000 0000 0000 0000 0110 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0001 0111 1101 0111 1111 1111
1101 1111 0000 0000 0000 0000 0000 0100 1000 0100 1010 0100 0110 1011 1100 0000
0110 1000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0011 0100 0100 0000 0000
0000 0000 0001 0100 0101 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000 0010
0000 0000 1000 0000 0100 0000 0101 0000 0000 0000 0000 0000 0010 0000 0110 0000
0000 1101 0010 0000 0000 1010 0111 1111 0001 0010 0000 0000 0000 0000 0000 0000
0000 1000 0000 0000 0000 0000 0000 0001 0000 1000 0001 0010 1100
DV(T,NM) in list form is:
22 27 53 54 107 109 110 111 112 113 115 117 118 119 120 121 122 123 124 125 126 127
128 129 131 132 133 134 135 157 160 165 168 170 173 177 178 180 182 183 184 185 193
194 195 196 238 239 241 245 267 269 273 275 277 318 328 337 345 347 370 377 378 388
389 391 394 404 406 409 410 411 412 413 414 415 419 422 452 479 484 491 494 496 497
**********************************************************************************
For completeness and comparison purposes, additional information on the value surrogate
structures is given here:
DV(T.NM) in bit-vector form (with every 4th position number appended above the position):
0 4 8 12 16 20 24 28 32 36 40 44 48 52 56 60
0000 0000 0000 0000 0000 0010 0001 0000 0000 0000 0000 0000 0000 0110 0000 0000
64 68 72 76 80 84 88 92 96 100 104 108 112 116 120 124
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0001 0111 1101 0111 1111 1111
128 132 136 140 144 148 152 156 160 164 168 172 176 180 184 188
1101 1111 0000 0000 0000 0000 0000 0100 1000 0100 1010 0100 0110 1011 1100 0000
192 196 200 204 208 212 216 220 224 228 232 236 240 244 248 252
0110 1000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0011 0100 0100 0000 0000
256 260 264 268 272 276 280 284 288 292 296 300 304 308 312 316
0000 0000 0001 0100 0101 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000 0010
320 324 328 332 336 340 344 348 352 356 360 364 368 372 376 380
0000 0000 1000 0000 0100 0000 0101 0000 0000 0000 0000 0000 0010 0000 0110 0000
384 388 392 396 400 404 408 412 416 420 424 428 432 436 440 444
0000 1101 0010 0000 0000 1010 0111 1111 0001 0010 0000 0000 0000 0000 0000 0000
448 452 456 460 464 468 472 476 480 484 488 492 496
0000 1000 0000 0000 0000 0000 0000 0001 0000 1000 0001 0010 1100
**********************************************************************************
Walk through the JOIN, RjoinT.NM.
Walk through the JOIN, SjoinT.NM (to examine which customers are repeat customers in consecutive months).
*********************************************************************************
The following is an even better method involving Domain Vectors.
It involves the three queries:
1. "name, city of customers sold to this month" (for mailing out a flyer)
Q1: RjoinS.NM[NM,CTY]
In SQL: SELELCT NM,CITY
FROM R,S
WHERE R.NM=S.NM;
2. "names starting with "m", city, po-# of sales" (billing purposes).
Q2: RjoinS.NM{NM=m*}[NM,CTY,PO]
In SQL: SELELCT NM,CITY,PO
FROM R,S
WHERE R.NM=S.NM and NM LIKE 'm%';
Note that % is a wild card in a character string replacing an arbitrary number of characters.
And that _ is a wild card in a character string replacing a single abitrary character.
Note also that one uses the keyword "LIKE" rather than an = sign for this construct.
3. "names of the young kids & sales amounts" for a datamining "what if" conjecture
"registered kids under 8 who spend $s".
Q3: R{AGE<8}joinS.NM[NM,AMT]
In SQL: SELELCT NM,AMT
FROM R,S
WHERE R.NM=S.NM and AGE < 8;
Note R[rid,NM] IS the NM-domain-vector-table (DVT) which assigns surrogate
values (bitvector positions) to each NM value.
Note: For each name, the value-surrogate or value identifier (vid)
is the R-rid and therefore the domain vector index, DVI(R.NM), would be
the identity (tautology table) vid rid It has no info and is not necessary.
0 0
1 1
2 2
...
Primary Key Relation Foreign Key Relation
R (RETAIL-CUSTOMERS) DVI(S.NM) S (SALES)
2 2 2 3 2 2 3
2 2 2 3 3 vid Srid Srid PO NM AMT CTY
rid NM AGE CTY CD 13 9 0 3 jo 14 bis
0 hu 54 ffs N34 13 1 1 1 su 143 ffs
1 re 16 bis Y21 13 35 2 2 bo 7 wap
2 iq 7 bis M2 13 32 3 5 ma 18 dls
3 oi 25 mhd N21 17 24 4 4 jo 17 dls
4 fu 32 min N12 17 44 5 6 jo 54 bis
5 nn 12 min M23 20 17 6 7 na 34 gfs
6 ez 38 min Y32 20 43 7 8 li 127 min
7 aa 54 fgo Y12 20 23 8 9 na 154 min
8 fl 14 fgo M43 20 56 9 11 su 17 bis
9 ar 75 bis Y23 73 13 10 10 di 15 bis
10 fx 82 bis M24 73 18 11 12 iz 243 ffs
11 ls 99 wap N21 73 39 12 13 di 12 wap
12 sd 81 fgo N12 73 40 13 14 mo 17 dls
13 su 67 gfs M23 73 14 14 15 mo 14 dls
14 ke 78 fgo Y32 73 53 15 16 hi 53 dls
15 fc 64 ffs Y12 73 52 16 17 ab 211 wap
16 op 77 fgo M43 98 19 17 18 ng 99 mhd
17 kz 55 gfs Y21 98 0 18 20 mo 17 bis
18 sg 17 dls M2 98 4 19 19 jo 52 bis
19 do 82 fgo N21 98 31 20 21 bo 17 fgo
20 ng 34 ffs N12 98 45 21 22 iz 14 wap
21 nz 14 gfs M23 98 30 22 23 di 5 wap
22 gi 54 fgo Y32 98 25 23 24 ng 17 mhd
23 lm 7 ffs Y12 224 5 24 25 kz 14 ffs
24 ob 18 fgo M43 224 28 25 26 jo 34 wap
25 be 17 fgo Y23 224 46 26 27 bo 17 wap
26 aq 54 fgo M24 224 26 27 30 iz 34 bis
27 qk 34 ffs N21 224 20 28 28 bo 76 dls
28 cp 14 dls N12 224 2 29 29 ma 154 min
29 oy 82 fgo M23 280 55 30 31 jo 17 wap
30 ge 17 zap Y32 280 42 31 32 jo 15 ffs
31 gv 15 fgo Y12 280 16 32 33 su 214 fgo
32 lk 54 fgo M43 288 29 33 34 li 12 wap
33 tf 12 ffs Y32 288 3 34 35 na 8 gfs
34 av 17 wap Y12 345 33 35 36 su 14 wap
35 ot 14 wap M43 345 7 36 37 cy 143 wap
36 kd 55 fgo Y23 354 37 37 38 iz 164 fgo
37 ie 44 ffs M24 354 27 38 39 di 99 mhd
38 iw 99 fgo N21 354 21 39 40 mo 17 wap
39 oa 17 fgo N12 354 11 40 42 mo 52 dls
40 js 52 ffs M23 354 47 41 41 hi 6 fgo
41 le 17 dls Y32 354 50 42 43 ab 14 fgo
42 ih 14 wap Y12 389 36 43 44 ng 17 bis
43 ii 17 gfs M43 389 49 44 45 kz 17 ffs
44 gn 17 wap Y21 472 12 45 46 jo 67 wap
45 qv 14 wap M2 472 38 46 47 bo 3 dls
46 eq 34 ffs N21 472 10 47 51 iz 17 dls
47 os 17 dls N12 472 48 48 49 di 24 dls
48 oo 99 fgo M23 472 51 49 50 cy 53 wap
49 ri 34 ffs Y32 472 22 50 48 iz 15 wap
50 fm 17 dls Y12 474 41 51 52 di 17 bis
51 an 14 min M43 474 54 52 53 mo 17 bis
52 ou 15 zap Y23 474 15 53 54 mo 44 fgo
53 qr 55 fgo M24 477 8 54 55 hi 36 wap
54 dr 17 fgo N21 477 6 55 56 ab 123 fgo
55 cr 18 wap N12 477 34 56 57 ng 111 mhd
56 dk 15 ffs M23
57 ij 18 mhd Y32 QL(S,Q1 QL(S,Q2) QL(S,Q3) QL(R,Q1 QL(R,Q2 QL(R,Q3)
58 mn 15 gfs Y12 0 73 389 13 2 58
59 fe 45 ffs M43 1 288 17 23 73
60 lf 18 wap Y12 2 20 129 78
61 rq 15 dls M43 3 QI(S,Q2) 73 389 88
62 pj 15 min Y21 4 vid Srid 98 491 122
63 gg 15 gfs M2 5 73 13 QI(S,Q3) 224 126
64 is 35 ffs N21 6 73 18 vid Srid 280 128
65 jr 15 dls N12 7 73 39 389 36 288 135
66 jc 15 wap M23 8 73 40 389 49 345 164
67 el 55 fgo Y32 9 73 14 354 170
68 hf 22 fgo Y12 10 73 53 389 190
69 sf 15 ffs M43 11 73 52 472 196
70 ao 47 min Y23 12 288 29 474 208
71 bd 15 wap M24 13 288 3 477 242
72 jj 17 min N21 14 243
73 mo 17 mhd N12 15 246
73 mo 17 mhd N12 15 246
74 ja 17 dls M23 16 Q2: RjoinS.NM{NM=m*}[NM,CTY,PO] 271
75 rr 36 ffs Y32 17 278
76 ea 17 min Y12 18 For Q2, using QI's: 288
77 am 17 min M43 19 Number QI(S,Q2) rows in desc 314
78 mf 17 gfs Y32 20 vid-multiplicity order 373
79 pb 17 wap Y12 21 (QI'(v#,vid,Srid) ) and build R using 401
80 qx 18 wap M43 22 that ordering: 73 1 410
81 nd 64 fgo Y23 23 288 2 435
82 ix 77 gfs M24 24 (this tells you memory needs for R0 also)460
83 tc 53 fgo N21 25 Rrid.v#-NM---AGE-CTY-CD---R0.-AUX----. 487
84 fn 18 ffs N12 26 73| 1 mo 17 mhd N12 | |
85 bn 22 fgo M23 27 288| 2 ma 54 ffs Y32 | |
86 da 35 gfs Y32 28 |-IN--------------------| |
87 jn 53 fgo Y12 29 | | |
88 mx 22 ffs M43 30 | | |
89 qq 77 gfs Y21 31 | | |
90 kl 36 gfs M2 32 |OUT--------------------| |
91 iy 23 fgo N21 33 | | |
92 nb 65 fgo N12 34 | | |
93 kb 22 min M23 35 | | |
94 ej 22 wap Y32 36 `----------------------' --------
95 sp 22 wap Y12 37
96 ak 23 mhd M43 38 Sort QI'[v#,Srid] on Srid = QI".
97 rm 23 fgo Y23 39
98 jo 37 gfs M24 40 v# Srid
99 em 78 gfs N21 41 2 3
100 oq 23 ffs N12 42 1 13
101 en 65 fgo M23 43 1 14
102 hs 53 fgo Y32 44 1 18
103 lz 36 ffs Y12 45 2 29
104 gc 23 dls M43 46 1 39
105 nm 54 bis N34 47 1 40
106 lu 23 min Y21 48 1 52
107 dt 24 ffs M2 49 1 53
108 ss 78 gfs N21 50
109 hj 65 fgo N12 51
110 hz 53 fgo M23 52
111 hd 37 gfs Y32 53 Probe S using Q":
112 ax 24 fgo Y12 54
113 nq 64 bis M43 55
114 cz 24 wap Y23 56
115 rz 24 min M24
116 eo 67 fgo N21 -R0---------------------.-AUX----.
117 gm 26 fgo N12 | 1 mo 17 mhd N12 | v# Srid|
118 bc 26 ffs M23 | 2 ma 54 ffs Y32 | 2 3 | <--
119 az 53 fgo Y32 |--IN--------------------| 1 13 |
120 pm 63 bis Y12 | 3 5 ma 18 dls | 1 14 |
121 dx 81 gfs M43 | 4 4 bo 17 dls | 1 18 |
122 mg 26 fgo Y21 | 5 6 jo 54 bis | 2 29 |
123 ad 24 fgo M2 |-OUT--------------------| 1 39 |
124 ev 26 mhd N21 | ma mhd 5 | 1 40 |
125 pd 24 wap N12 | | 1 52 |
126 me 26 fgo M23 | | 1 53 |
127 rf 24 fgo Y32 `----------------------' --------
128 mh 24 fgo Y12
129 ac 7 fgo M43
130 lj 74 fgo Y23
131 ir 24 ffs M24
132 dq 26 fgo N21
133 fb 53 fgo N12
134 ln 24 wap M23
135 mm 26 wap Y32
136 fv 24 min Y12 -R0---------------------.-AUX----.
137 ny 26 fgo M43 | 1 mo 17 mhd N12 | v# Srid|
138 gp 24 mhd Y32 | 2 ma 54 ffs Y32 | 2 3 |
139 fk 26 fgo Y12 |--IN--------------------| 1 13 | <--
140 of 74 fgo M43 | 12 13 di 12 wap | 1 14 |
141 gx 25 ffs Y23 | 13 14 mo 17 dls | 1 18 |
142 ig 26 fgo M24 | 14 15 mo 14 dls | 2 29 |
143 io 54 bis N21 |-OUT--------------------| 1 39 |
144 ew 53 bis N12 | ma ffs 5 | 1 40 |
145 aw 26 zap M23 | mo mhd 14 | 1 52 |
146 sh 25 wap Y32 | mo mhd 15 | 1 53 |
147 rt 75 fgo Y12 `----------------------' --------
148 jk 26 min M43
149 pn 25 ffs Y21
150 co 26 fgo M2
151 gz 25 dls N21
152 nj 26 wap N12
153 eh 37 ffs M23
154 po 44 ffs Y32
155 od 42 ffs Y12
156 oz 25 dls M43 -R0---------------------.-AUX----.
157 au 26 dls Y23 | 1 mo 17 mhd N12 | v# Srid|
158 se 26 ffs M24 | 2 ma 54 ffs Y32 | 2 3 |
159 ox 75 fgo N21 |--IN--------------------| 1 13 |
160 bh 25 mhd N12 | 18 20 mo 17 bis | 1 14 |
161 ry 26 min M23 | 19 19 jo 52 bis | 1 18 | <--
162 jv 25 wap Y32 | 20 21 bo 17 fgo | 2 29 |
163 qf 26 min Y12 |-OUT--------------------| 1 39 |
164 md 25 zap M43 | mo mhd 20 | 1 40 |
165 sj 25 fgo Y12 | | 1 52 |
166 gl 36 wap M43 | | 1 53 |
167 eb 25 min Y21 `----------------------' --------ma ffs
168 ra 56 bis M2 `- - - > |mo mhd
169 jt 25 wap N21 flush |mo mhd
170 mr 25 min N12 |
171 pl 64 fgo M23 |
172 bf 25 wap Y32 |
173 kv 53 bis Y12 |
174 ib 76 fgo M43 |
175 at 25 ffs Y23 `-.______.-'
176 jq 26 fgo M24 -R0---------------------.-AUX----.
177 ji 26 min N21 | 1 mo 17 mhd N12 | v# Srid|
178 pa 52 ffs N12 | 2 ma 54 ffs Y32 | 2 3 |
179 qp 76 fgo M23 |--IN--------------------| 1 13 |
180 ds 26 dls Y32 | 27 30 iz 34 bis | 1 14 |
181 kp 47 ffs Y12 | 28 28 bo 76 dls | 1 18 |
182 pi 26 min M43 | 29 29 ma 154 min | 2 29 | <--
183 cf 53 bis Y32 |-OUT--------------------| 1 39 |
184 kn 26 fgo Y12 | mo mhd 20 | 1 40 |
185 dy 26 mhd M43 | ma ffs 29 | 1 52 |
186 pc 26 fgo Y23 | | 1 53 |
187 lc 26 ffs M24 `----------------------' --------ma ffs
188 ic 77 fgo N21 `- - - > |mo mhd
189 bz 26 ffs N12 |mo mhd
190 ml 81 fgo M23 |
191 jp 81 fgo Y32 |
192 qu 26 ffs Y12 |
193 rw 26 mhd M43 |
194 du 28 wap Y21 |
195 sa 28 min M2 `-.______.-'
196 mi 28 dls N21 -R0---------------------.-AUX----.
197 or 51 ffs N12 | 1 mo 17 mhd N12 | v# Srid|
198 sb 53 bis M23 | 2 ma 54 ffs Y32 | 2 3 |
199 jm 28 fgo Y32 |--IN--------------------| 1 13 |
200 fo 31 wap Y12 | 39 40 mo 17 wap | 1 14 |
201 oc 31 dls M43 | 40 42 mo 52 dls | 1 18 |
202 so 51 ffs Y23 | 41 41 hi 6 fgo | 2 29 |
203 cs 68 fgo M24 |-OUT--------------------| 1 39 | <--
204 lg 31 zap N21 | mo mhd 42 | 1 40 |
205 jy 52 bis N12 | | 1 52 |
206 ho 34 min M23 | | 1 53 |
207 hn 52 bis Y32 `----------------------' --------ma ffs
208 mw 51 ffs Y12 `- - - > |mo mhd
209 ll 34 dls M43 flush |mo mhd
210 ki 34 wap N34 |mo mhd
211 hw 34 dls Y21 |ma ffs
212 eg 52 ffs M2 |mo mhd
213 qc 34 mhd N21 |
214 ks 41 wap N12 |
215 rd 34 min M23 `-.______.-'
216 bm 51 bis Y32 -R0---------------------.-AUX----.
217 ce 39 fgo Y12 | 1 mo 17 mhd N12 | v# Srid|
218 no 34 min M43 | 2 ma 54 ffs Y32 | 2 3 |
219 hm 34 mhd Y23 |--IN--------------------| 1 13 |
220 qa 57 wap M24 | 51 52 di 17 bis | 1 14 |
221 iu 34 wap N21 | 52 53 mo 17 bis | 1 18 |
222 gq 28 bis N12 | 53 54 mo 44 fgo | 2 29 |
223 fz 47 bis M23 |-OUT--------------------| 1 39 |
224 bo 46 bis Y32 | mo mhd 42 | 1 40 |
225 sy 34 bis Y12 | mo mhd 53 | 1 52 | <--
226 al 51 bis M43 | mo mhd 54 | 1 53 |
227 pg 37 bis Y21 `----------------------' --------ma ffs
228 qh 47 bis M2 `- - - > |mo mhd
229 ap 36 bis N21 flush |mo mhd
230 lb 35 bis N12 |mo mhd
231 bi 44 bis M23 |ma ffs
232 ft 34 bis Y32 RESULT===> |mo mhd
233 qd 36 bis Y12 |mo mhd
234 sw 34 min M43 |mo mhd
235 kc 46 bis Y23 mo mhd
236 ns 45 bis M24
237 ik 31 bis N21 What about INSERTS wrt maintaining vidI?
238 fa 34 bis N12
239 dc 34 bis M23 58 ms 26 wap
240 ht 47 bis Y32
241 rg 35 bis Y12 as Srid 57:
242 mv 37 bis M43 1. For Referential Integrity, look up rg in R,
243 mt 36 bis Y32 yielding Rrid=246 and AGE<8 is not true (free!)
244 ef 36 bis Y12
245 kk 34 fgo M43 2. Since we know that ms starts with m, we know
246 ms 44 min Y23 qsw should be 110. Installl 246 110 57 in vidI.
247 om 34 min M24
248 ne 34 fgo N21 The cost is just the standard cost of
249 pt 22 gfs N12 installing one entry in an index. in this
250 cx 34 wap M23 sense the additional cost is zero.
251 la 44 fgo Y32
252 bw 34 fgo Y12
253 tb 26 gfs M43
254 go 26 gfs Y21 What about DELETES?
255 qs 44 fgo M2 Deleting from S just requires the usual marking
256 rv 25 gfs N21 of file and index entries as deleted (or keeping
257 fy 34 fgo N12 "deleted" list somewhere).
258 fd 53 ffs M23
259 bu 34 fgo Y32 Deleting from R: ref integ check to S, is
260 ci 45 dls Y12 quicker - the Rrid can simply be dropped on the
261 dp 25 gfs M43 vidI, if found, deleted denied (nothing to do)
262 kw 45 min Y23 or cascaded (removal of vidI is immediate and
263 pe 28 gfs M24 the Srids point to Srecords to be marked).
264 es 34 fgo N21
265 ag 34 wap N12 Assuming ref integ violations will be denied
266 qo 45 zap M23 (not cascaded) there is a net overhead reduction.
267 ip 34 fgo Y32
268 ay 28 gfs Y12
269 if 35 wap M43
270 hg 46 dls Y12
271 mj 53 ffs M43
272 qt 35 dls Y21
273 ql 53 ffs M2
274 ek 46 zap N21 UPDATES?
275 lo 35 fgo N12
276 ch 53 ffs M23 Update to R or S on NM is treated as deleted
277 qy 31 gfs Y32 followed by insert.
278 my 46 dls Y12
279 ok 35 min M43 Update to R on a nonprime attr: Check the select
280 ab 34 gfs Y23 clauses for all accelerated queries. If that
281 fw 35 min M24 tuple changes the truth value of any, make the
282 pu 46 fgo N21 qsw change in vidI - by dropping Rrid on vidI.
283 oh 34 gfs N12 (added cost <= 1 vidI access).
284 sq 46 fgo M23
285 lr 47 mhd Y32 Update to S on nonprime attr: Check select
286 cm 44 gfs Y12 clauses, if truth value changes, update qsw.
287 cn 35 fgo M43 (this is free).
288 ma 54 ffs Y32
289 ae 35 dls Y12
290 nx 35 zap M43
291 sk 44 gfs Y23
292 bx 36 fgo M24
293 bj 36 min N21
294 ia 45 gfs N12
295 gh 36 fgo M23
296 hp 36 min Y32 vI(T.NM) T (PURCHASES-2nd day)
297 ov 36 fgo Y12 vid qsw rid rid PO NM AMT CTY
298 lq 34 gfs M43 3 0 0 0 3 oi 45 min
299 et 36 wap Y21 4 0 13 1 16 op 122 ffs
300 sl 36 fgo M2 6 0 6 2 482 bb 381 ffs
301 nh 36 wap N21 8 0 5 3 466 it 12 fgo
302 pp 36 dls N12 9 0 15 4 224 bo 288 ffs
303 gy 63 ffs M23 9 0 12 5 8 fl 143 ffs
304 sz 36 fgo Y32 16 0 1 6 6 ez 25 ffs
305 dl 36 dls Y12 17 1 11 7 466 lt 112 dls
306 jx 36 mhd M43 20 1 14 8 467 ky 59 fgo
307 hb 36 zap Y23 224 1 4 9 468 df 224 wap
308 jd 36 fgo M24 330 0 16 10 469 gb 456 gfs
309 bl 37 min N21 331 0 17 11 17 kz 42 fgo
310 jz 37 min N12 466 0 7 12 9 ar 97 gfs
311 cw 54 ffs M23 466 0 3 13 4 fu 196 fgo
312 sn 37 dls Y32 467 0 8 14 20 ng 38 mhd
313 ba 37 fgo Y12 468 0 9 15 9 ar 88 gfs
314 mk 37 wap M43 469 0 10 16 330 qb 44 ffs
315 sc 37 fgo N34 482 0 2 17 331 ta 666 fgo
316 pr 37 zap Y21
317 dw 37 wap M2 Q4: NM, AMT if purchased item both days.
318 gs 37 min N21 S |X|(NM) T [NM,AMT]
319 il 42 min N12
320 eu 43 gfs M23 QL(Q4) TL(S,Q4) QI(S,Q4) TL(T,Q4) QI(T,Q4)
321 lh 42 fgo Y32 vid Srid v# vid Srid Trid v# vid Trid
322 fp 42 fgo Y12 17 2 1 17 24 4 1 17 11
323 jw 44 gfs M43 20 20 1 17 44 11 2 20 14
324 qz 42 mhd Y23 224 24 2 20 56 14 3 224 4
325 ct 42 wap M24 26 2 20 43
326 qe 43 min N21 28 3 224 46
327 hq 43 min N12 43 3 224 26
328 rn 51 gfs M23 44 3 224 2
329 ni 43 fgo Y32 46 3 224 20
330 qb 52 gfs Y12 56 3 224 28
331 ta 43 fgo M43
332 by 43 dls Y21
333 bv 52 gfs M2
334 km 43 fgo N21
335 nw 44 wap N12
336 ee 44 fgo M23 For Q4, using QI's: Since QI(T,Q4) is smaller,
337 nk 53 gfs Y32 build with T. Number QI(T,Q4) rows in desc
338 ha 44 wap Y12 vid-multiplicity order
339 kt 53 gfs M43 (QI'(v#,vid,Trid) ) and build R using
340 fi 44 fgo Y23 that ordering:
341 nl 47 mhd M24
342 rj 47 dls N21
343 iv 47 zap N12 -R0--NM- -AMT-----------.-AUX----.
344 ex 47 min M23 1 kz 42 |QI(T,Q4)|
345 li 56 gfs Y32 2 | v# Trid|
346 ah 47 fgo Y12 3 | 1 11 | <--
347 cu 56 gfs M43 |-IN--------------------| 2 14 |
348 td 47 fgo Y32 9 468 df 224 wap | 3 4 |
349 dd 47 min Y12 10 469 gb 456 gfs | |
350 cb 47 min M43 11 17 kz 42 fgo | |
351 lv 51 min Y23 |OUT--------------------| |
352 ps 51 fgo M24
353 ow 54 gfs N21
354 iz 51 fgo N12
355 bg 63 gfs M23
356 dh 51 fgo Y32 -R0--NM- -AMT-----------.-AUX----.
357 hl 64 gfs Y12 1 kz 42 |QI(T,Q4)|
358 nc 67 gfs M43 2 ng 38 | v# Trid|
359 he 51 fgo Y21 3 | 1 11 |
360 ei 51 dls M2 |-IN--------------------| 2 14 | <--
361 ka 51 min N21 12 9 ar 97 gfs | 3 4 |
362 gd 51 wap N12 13 4 fu 196 fgo | |
363 pq 52 wap M23 14 20 ng 38 mhd | |
364 hc 52 fgo Y32
365 fr 74 gfs Y12
366 er 52 wap M43
367 sm 52 fgo Y23 -R0--NM- -AMT-----------.-AUX----.
368 jf 75 gfs M24 1 kz 42 |QI(T,Q4)|
369 kj 52 zap N21 2 ng 38 | v# Trid|
370 nf 52 dls N12 3 bo 288 | 1 11 |
371 bk 52 min M23 |-IN--------------------| 2 14 |
372 sx 52 min Y32 3 466 it 12 fgo | 3 4 | <--
373 mu 52 fgo Y12 4 224 bo 288 ffs | |
374 fj 35 gfs M43 5 8 fl 143 ffs | |
375 aj 77 gfs Y12
376 on 47 bis M43 Sort QI'(S,Q4)[v#,Srid] on Srid = QI'':
377 gu 26 min N21 Q''
378 gr 53 dls N12 v# Srid
379 ko 53 dls N21 3 2
380 hv 12 ffs N12 3 20
381 jb 14 ffs M23 1 24
382 hx 53 wap Y32 3 26
383 qn 53 wap Y12 3 28
384 cq 17 ffs M43 2 43
385 np 53 min Y23 1 44
386 ld 14 ffs M24 3 46
387 dj 14 ffs N21 2 56
388 nr 53 fgo N12
389 cy 7 fgo M23
390 qg 53 min Y32
391 kr 12 fgo Y12 Probe S using Q'':
392 pv 55 fgo M43
393 lx 14 fgo Y32
394 cl 55 fgo Y12
395 dv 53 fgo M43
396 fq 56 wap Y23 -v#--NM- -AMT-----------.-Q''----.
397 gf 14 fgo M24 | 1 kz 42 | v# Srid|
398 im 56 min N21 | 2 ng 38 | 3 2 | <--
399 ed 25 bis N12 | 3 bo 288 | 3 20 |
400 ca 53 wap M23 |--IN--------------------| 1 24 |
401 mp 25 bis Y32 | 0 3 jo 14 bis | 3 26 |
402 pf 53 mhd Y12 | 1 1 su 143 ffs | 3 28 |
403 oe 56 wap M43 | 2 2 bo 7 wap | 2 43 |
404 jh 25 bis Y21 |-NM-SAMT-TAMT-----------| 1 44 |
405 je 54 wap M2 |bo 7 288 | 3 46 |
406 ju 63 fgo N21 | | 2 56 |
407 ro 17 fgo N12 | | |
408 rc 54 min M23 `--------------------------------
409 si 63 zap M23
410 mq 63 min Y32
411 hr 26 bis Y12
412 jl 24 bis M43
413 te 54 dls Y21
414 ec 63 min M2
415 dm 54 wap N21
416 ep 64 dls N12 -v#--NM- -AMT-----------.-Q''----.
417 fs 54 mhd M23 | 1 kz 42 | v# Srid|
418 cc 54 min Y32 | 2 ng 38 | 3 2 |
419 oj 24 bis Y12 | 3 bo 288 | 3 20 | <--
420 rs 54 wap M43 |--IN--------------------| 1 24 |
421 kh 64 dls Y23 | 18 20 mo 17 bis | 3 26 |
422 qi 54 fgo M24 | 19 19 jo 52 bis | 3 28 |
423 rp 14 fgo N21 | 20 21 bo 17 fgo | 2 43 |
424 pz 64 fgo N12 |-NM-SAMT-TAMT-----------| 1 44 |
425 qw 17 fgo M23 |bo 7 288 | 3 46 |
426 sv 64 min Y32 |bo 17 288 | 2 56 |
427 ey 54 min Y12 | | |
428 kq 54 wap M43 `--------------------------------
429 og 54 wap Y12
430 dg 23 bis M43
431 nv 55 dls Y21
432 id 26 dls M2
433 bp 55 ffs N21
434 hh 31 ffs N12
435 mz 55 wap M23
436 fh 49 zap Y32 -v#--NM- -AMT-----------.-Q''----.
437 pk 17 bis Y12 | 1 kz 42 | v# Srid|
438 sr 55 wap M43 | 2 ng 38 | 3 2 |
439 hy 64 zap Y23 | 3 bo 288 | 3 20 |
440 ku 64 mhd M24 |--IN--------------------| 1 24 | <--
441 qm 38 dls N21 | 24 25 kz 14 ffs | 3 26 | <--
442 cg 64 ffs N12 | 25 26 jo 34 wap | 3 28 |
443 bt 64 zap M23 | 26 27 bo 17 wap | 2 43 |
444 ly 15 bis Y32 |-NM-SAMT-TAMT-----------| 1 44 |
445 st 65 mhd Y12 |bo 17 288 | 3 46 |
446 px 52 ffs M43 | | 2 56 |
447 kf 65 ffs Y32 | | |
448 br 49 dls Y12 `--------------------------------
449 dz 15 bis M43 `- - - -flush -> |bo 7 288
450 py 67 wap Y23 |bo 17 288
451 kg 67 ffs M24 |kz 14 42
452 bs 23 wap N21 |
453 hk 67 wap N12 |
454 in 74 min M23 |
455 rb 74 min Y32 |
456 cv 74 mhd Y12 -v#--NM- -AMT-----------.-Q''----.
457 gj 75 dls M43 | 1 kz 42 | v# Srid|
458 lw 17 bis Y21 | 2 ng 38 | 3 2 |
459 dn 75 zap M2 | 3 bo 288 | 3 20 |
460 mb 75 dls N21 |--IN--------------------| 1 24 |
461 cj 19 wap N12 | 27 30 iz 34 bis | 3 26 |
462 kx 76 min M23 | 28 28 bo 76 dls | 3 28 | <--
463 ff 22 dls Y32 | 29 29 ma 154 min | 2 43 |
464 nt 76 ffs Y12 |-NM-SAMT-TAMT-----------| 1 44 |
465 nu 77 ffs M43 |bo 17 288 | 3 46 |
466 lt 25 min Y23 |bo 76 288 | 2 56 |
467 ky 17 min M24 | | |
468 df 39 min N21 `--------------------------------
469 gb 77 ffs N12 bo 7 288
470 ck 44 zap M23 |bo 17 288
471 fg 33 wap Y32 |kz 14 42
472 di 22 bis Y12 |
473 rl 62 zap M43 |
474 hi 78 wap N34 |
475 pw 42 dls Y21 |
476 bq 38 ffs M2 -v#--NM- -AMT-----------.-Q''----.
477 na 78 zap N21 | 1 kz 42 | v# Srid|
478 gw 17 bis N12 | 2 ng 38 | 3 2 |
479 ph 81 min M23 | 3 bo 288 | 3 20 |
480 qj 12 bis Y32 |--IN--------------------| 1 24 |
481 gt 81 min Y12 | 42 43 ab 14 fgo | 3 26 |
482 bb 25 dls M43 | 43 44 ng 17 bis | 3 28 |
483 it 82 dls Y23 | 44 45 kz 17 ffs | 2 43 | <--
484 af 31 ffs M24 |-NM-SAMT-TAMT-----------| 1 44 | <--
485 rh 79 ffs N21 |kz 17 42 | 3 46 |
486 ol 82 min N12 | | 2 56 |
487 mc 22 wap M23 | | |
488 gk 31 ffs Y32 `--------------------------------
489 lp 36 wap Y12 `- - - -flush -> |bo 7 288
490 as 82 ffs M43 |bo 17 288
491 db 3 mhd Y21 |kz 14 42
492 rx 17 bis M2 |bo 17 288
493 ru 82 wap N21 |bo 76 288
494 jg 26 mhd N12 |ng 17 38
495 ai 99 wap M23 |
496 de 31 min Y32 -v#--NM- -AMT-----------.-Q''----.
497 ga 26 ffs Y12 | 1 kz 42 | v# Srid|
498 cd 12 bis M43 | 2 ng 38 | 3 2 |
499 rk 22 wap Y23 | 3 bo 288 | 3 20 |
|--IN--------------------| 1 24 |
| 45 46 jo 67 wap | 3 26 |
| 46 47 bo 3 dls | 3 28 |
| 47 51 iz 17 dls | 2 43 |
|-NM-SAMT-TAMT-----------| 1 44 |
|kz 17 42 | 3 46 | <--
|bo 3 288 | 2 56 |
| | |
`--------------------------------
bo 7 288
|bo 17 288
|kz 14 42
|bo 17 288
|bo 76 288
|ng 17 38
|
-v#--NM- -AMT-----------.-Q''----.
| 1 kz 42 | v# Srid|
| 2 ng 38 | 3 2 |
| 3 bo 288 | 3 20 |
|--IN--------------------| 1 24 |
| 54 55 hi 36 wap | 3 26 |
| 55 56 ab 123 fgo | 3 28 |
| 56 57 ng 111 mhd | 2 43 |
|-NM-SAMT-TAMT-----------| 1 44 |
|kz 17 42 | 3 46 |
|bo 3 288 | 2 56 | <--
|ng 111 38 | |
`--------------------------------
`- - - -flush -> |bo 7 288
|bo 17 288
|kz 14 42
|bo 17 288
|bo 76 288
|ng 17 38
|kz 17 42
bo 3 288
ng 111 38
********************************************************************
********************************************************************
********************************************************************
********************************************************************
Here is an example worked through for an alternative application of
this Domain Vector Concept to accelerating queries:
DV(S.NM) (as a list, not vector)
13
17
20
73
98
224
R0__280
288
345
354
389
472
474
R1__477
R|X|S.NM
ASSUME: 190 bytes main memory One page = 30 bytes.
m'= number of record-slots for R0..RB, n = number of record in R|XS.NM
Mem mgmt: IN,OUT,DV-buf,R1,..,RB=1pg, rest for R0.
1. JV=DV(S.MN)
2. Determine B: m'=10, n=14, bfr=d=3
Condition defining B:
B=0 if n<=m', else
B=1 if m' 20
|IN------------| 73
sg 17 dls M2 98
do 82 fgo N21 224
ng 34 ffs N12 <- 280
|OUT-----------| |
mo sums to 26
2. Mod(7) = 5 (open addr'ing)
---------------------M-.
|0: kz 55 gfs Y21 R0
|1: |
|2: |
|3: su 67 gfs M23 |
|4: |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1------------.DVbuf--|
| | 13
| | 17
| | 20
|IN------------| -> 73
jj 17 min N21 98
mo 17 mhd N12 <- 224
ja 17 dls M23 280
jo sums to 23
2. Mod(7) = 2
---------------------M-.
|0: kz 55 gfs Y21 R0
|1: |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1------------.DVbuf--|
| | 13
| | 17
| | 20
|IN------------| 73
ak 23 mhd M43 -> 98
rm 23 fgo Y23 224
jo 37 gfs M24 <- 280
bo sums to 15
2. Mod(7) = 1
---------------------M-.
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1------------.DVbuf--|
| | 13
| | 17
| | 20
|IN------------| 73
gq 28 bis N12 98
fz 47 bis M23 -> 224
bo 46 bis Y32 <- 280
ab sums to 1
2. Mod(7) = 1
---------------------M-.
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1------------.DVbuf--|
| | 13
| | 17
| | 20
|IN------------| 73
ok 35 min M43 98
ab 34 gfs Y23 <- 224
fw 35 min M24 -> 280
6. Process the file S.
i. Read SOV0(R.NM)
ii. Read 1st S-pg
iii.hash:
jo sums to 23
Mod(7) = 2
su sums to 38
Mod(7) = 3
bo sums to 15
Mod(7) = 1
(no collisions)
iv. Concat & output.
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1------------.DVbuf-----.
| |11101100 |
| |01000110 |
| |11111001 |
|IN------------|11101011 |
3 jo 14 bis 10010001 |
1 su 143 ffs 10111110 |
2 bo 7 wap 00001101 1|
|OUT------------------------
jo 37 gfs M24 3 14 bis
su 67 gfs M23 1 143 ffs
bo 46 bis Y32 2 7 wap
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
5 ma 18 dls | ->01100
| |01000110
| |11111001
|IN----------------|11101011
5 ma 18 dls |10010001
4 bo 17 dls |10111110
6 jo 54 bis |00001101
|OUT_______________|1 ------
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
(pg was flushed to result)
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
9 na 154 min | ->00
(pg was flushed) |01000110
|11111001
|IN----------------|11101011
7 na 34 gfs |10010001
8 li 127 min |10111110
9 na 154 min |00001101
|OUT_______________|1 ------
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
9 na 154 min | vvv
10 di 15 bis | 1000110
12 iz 243 ffs |11111001
|IN----------------|11101011
11 su 17 bis |10010001
10 di 15 bis |10111110
12 iz 243 ffs |00001101
|OUT_______________|1 ------
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
su 67 gfs M23 11 17 bis
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
13 di 12 wap | vvv
(pg was flushed | 0110
|11111001
|IN----------------|11101011
13 di 12 wap |10010001
14 mo 17 dls |10111110
15 mo 14 dls |00001101
|OUT_______________|1 ------
su 67 gfs M23 11 17 bis
mo 17 mhd N12 14 17 dls
mo 17 mhd N12 15 14 dls
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
13 di 12 wap | v
16 hi 53 dls |vv 0
|11111001
|IN----------------|11101011
16 hi 53 dls |10010001
17 ab 211 wap |10111110
18 ng 99 mhd |00001101
|OUT_______________|1 ------
(page output to result file)
ab 34 gfs Y23 17 211 wap
ng 34 ffs N12 18 99 mhd
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
13 di 12 wap |
16 hi 53 dls | vvv
| 111001
|IN----------------|11101011
20 mo 17 bis |10010001
19 jo 52 bis |10111110
21 bo 17 fgo |00001101
|OUT_______________|1 ------
(pg output to result file)
jo 37 gfs M24 19 52 bis
bo 46 bis Y32 21 17 fgo
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
(pg output to S1 |
23 di 5 wap | vvv
| 001
|IN----------------|11101011
22 iz 14 wap |10010001
23 di 5 wap |10111110
24 ng 17 mhd |00001101
|OUT_______________|1 ------
jo 37 gfs M24 19 52 bis
bo 46 bis Y32 21 17 fgo
ng 34 ffs N12 24 17 mhd
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
23 di 5 wap |
|
|vvv
|IN----------------|11101011
25 kz 14 ffs |10010001
26 jo 34 wap |10111110
27 bo 17 wap |00001101
|OUT_______________|1 ------
(pg output to result file)
kz 55 gfs Y21 25 14 ffs
jo 37 gfs M24 26 34 wap
bo 46 bis Y32 27 17 wap
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
23 di 5 wap |
30 iz 34 bis |
29 ma 154 min | vvv
|IN----------------| 01011
30 iz 34 bis |10010001
28 bo 76 dls |10111110
29 ma 154 min |00001101
|OUT_______________|1 ------
(pg output to result file)
bo 46 bis Y32 28 76 dls
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
23 di 5 wap |
30 iz 34 bis |
29 ma 154 min |v vv
|IN----------------| 11
31 jo 17 wap |10010001
32 jo 15 ffs |10111110
33 su 214 fgo |00001101
|OUT_______________|1 ------
(pg output to result file)
su 67 gfs M23 33 214 fgo
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
(pg output to S1 |
34 li 12 wap |
35 na 8 gfs |
|IN----------------| vvv
34 li 12 wap | 0010001
35 na 8 gfs |10111110
36 su 14 wap |00001101
|OUT_______________|1 ------
su 67 gfs M23 33 214 fgo
su 67 gfs M23 36 14 wap
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
(pg output to S1 |
38 iz 164 fgo |
39 di 99 mhd |
|IN----------------| vvv
37 cy 143 wap | 0001
38 iz 164 fgo |10111110
39 di 99 mhd |00001101
|OUT_______________|1 ------
su 67 gfs M23 33 214 fgo
su 67 gfs M23 36 14 wap
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
38 iz 164 fgo |
39 di 99 mhd |
41 hi 6 fgo |
|IN----------------|vv v
40 mo 17 wap | 1
42 mo 52 dls |10111110
41 hi 6 fgo |00001101
|OUT_______________|1 ------
(pg output to result file)
mo 17 mhd N12 42 52 dls
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
38 iz 164 fgo |
39 di 99 mhd |
41 hi 6 fgo |
|IN----------------|
43 ab 14 fgo | vvv
44 ng 17 bis | 111110
45 kz 17 ffs |00001101
|OUT_______________|1 ------
(pg output to result file)
kz 55 gfs Y21 45 17 ffs
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
(pg output to S1 |
51 iz 17 dls |
|
|IN----------------|
46 jo 67 wap | vvv
47 bo 3 dls | 110
51 iz 17 dls |00001101
|OUT_______________|1 ------
kz 55 gfs Y21 45 17 ffs
jo 37 gfs M24 46 67 wap
bo 46 bis Y32 47 3 dls
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
(pg output to S1 |
48 iz 15 wap |
|
|IN----------------|
49 di 24 dls |
50 cy 53 wap |vvv
48 iz 15 wap |00001101
|OUT_______________|1 ------
kz 55 gfs Y21 45 17 ffs
jo 37 gfs M24 46 67 wap
bo 46 bis Y32 47 3 dls
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
48 iz 15 wap |
52 di 17 bis |
|
|IN----------------|
52 di 17 bis |
53 mo 17 bis | vvv
54 mo 44 fgo | 01101
|OUT_______________|1 ------
(pg output to result file)
mo 17 mhd N12 53 17 bis
mo 17 mhd N12 54 44 fgo
|0: kz 55 gfs Y21 R0
|1: bo 46 bis Y32 |
|2: jo 37 gfs M24 |
|3: su 67 gfs M23 |
|4: ab 34 gfs Y23 |
|5: ng 34 ffs N12 |
|6: mo 17 mhd N12 |
|R1-----------------DVbu--.
48 iz 15 wap |
52 di 17 bis |
55 hi 36 wap |
|IN----------------|
55 hi 36 wap |
56 ab 123 fgo |v vv
57 ng 111 mhd | 01
|OUT_______________|1 ------
(pg output to result file)
ng 34 ffs N12 57 111 mhd
(flush last S1 & result pgs)
S1 5 ma 18 dls
7 na 34 gfs
8 li 127 min
9 na 154 min
10 di 15 bis
12 iz 243 ffs
13 di 12 wap
16 hi 53 dls
22 iz 14 wap
23 di 5 wap
30 iz 34 bis
29 ma 154 min
34 li 12 wap
35 na 8 gfs
37 cy 143 wap
38 iz 164 fgo
39 di 99 mhd
41 hi 6 fgo
51 iz 17 dls
49 di 24 dls
50 cy 53 wap
48 iz 15 wap
52 di 17 bis
55 hi 36 wap
Process R1:
ma sums to 12
Mod(7) = 5
---------------------M-.
|0: R0
|1: |
|2: |
|3: |
|4: |
|5: ma 54 ffs Y32 |
|6: |
|R1------------.DVbuf--|
DV(R.NM)
288 <--
345
|IN----------------.354
ma 54 ffs Y32 |389
ae 35 dls Y12 |472
nx 35 zap M43 |474
|OUT---------------'477
li sums to 19
Mod(7) = 5
---------------------M-.
|0: R0
|1: |
|2: |
|3: |
|4: |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345 <--
|IN----------------.354
li 56 gfs Y32 |389
ah 47 fgo Y12 |472
cu 56 gfs M43 |474
|OUT---------------'477
iz sums to 33 (Note: 3rd
Mod(7) = 5 collision)
---------------------M-.
|0: iz 51 fgo N12 R0
|1: |
|2: |
|3: |
|4: |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354 <--
iz 51 fgo N12 |389
bg 63 gfs M23 |472
dh 51 fgo Y32 |474
|OUT---------------'477
cy sums to 26 (Note: 4th
Mod(7) = 5 collision)
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: |
|3: |
|4: |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
dj 14 ffs N21 |389 <--
nr 53 fgo N12 |472
cy 7 fgo M23 |474
|OUT---------------'477
di sums to 11
Mod(7) = 4
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: |
|3: |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
fg 33 wap Y32 |389
di 22 bis Y12 |472 <--
rl 62 zap M43 |474
|OUT---------------'477
hi sums to 15 (Note: 5th
Mod(7) = 1 collision)
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
hi 78 wap N34 |389
pw 42 dls Y21 |472
bq 38 ffs M2 |474 <--
|OUT---------------'477
na sums to 13 (Note: 6th
Mod(7) = 6 collision)
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
na 78 zap N21 |389
gw 17 bis N12 |472
ph 81 min M23 |474
477 <--
6. Process the file S1.
i. Read 1st S1-pg
ii. hash:
ma sums to 12
Mod(7) = 5
na sums to 13
Mod(7) = 6
li sums to 19
Mod(7) = 5
iii.Concat & output.
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
5 ma 18 dls |
7 na 34 gfs |
8 li 127 min |
|OUT---------------'
ma 54 ffs Y32 5 18 dls
na 78 zap N21 7 34 gfs
li 56 gfs Y32 8 127 min
Second page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
10 di 15 bis |
12 iz 243 ffs |
13 di 12 wap |
|OUT---------------'
di 22 bis Y12 10 15 bis
iz 51 fgo N12 12 243 ffs
di 22 bis Y12 13 12 wap
Third page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
16 hi 53 dls |
22 iz 14 wap |
23 di 5 wap |
|OUT---------------'
hi 78 wap N34 16 53 dls
iz 51 fgo N12 22 14 wap
di 22 bis Y12 23 5 wap
4th page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
23 di 5 wap |
30 iz 34 bis |
29 ma 154 min |
|OUT---------------'
di 22 bis Y12 23 5 wap
iz 51 fgo N12 30 34 bis
ma 54 ffs Y32 29 154 min
5th page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
34 li 12 wap |
35 na 8 gfs |
37 cy 143 wap |
|OUT---------------'
li 56 gfs Y32 34 12 wap
na 78 zap N21 35 8 gfs
cy 7 fgo M23 37 143 wap
6th page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
38 iz 164 fgo |
39 di 99 mhd |
41 hi 6 fgo |
|OUT---------------'
iz 51 fgo N12 38 164 fgo
di 22 bis Y12 39 99 mhd
hi 78 wap N34 41 6 fgo
7th page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
51 iz 17 dls |
49 di 24 dls |
50 cy 53 wap |
|OUT---------------'
iz 51 fgo N12 51 17 dls
di 22 bis Y12 49 24 dls
cy 7 fgo M23 50 53 wap
8th page of S1:
---------------------M-.
|0: iz 51 fgo N12 R0
|1: cy 7 fgo M23 |
|2: hi 78 wap N34 |
|3: na 78 zap N21 |
|4: di 22 bis Y12 |
|5: ma 54 ffs Y32 |
|6: li 56 gfs Y32 |
|IN--------------------|
48 iz 15 wap |
52 di 17 bis |
55 hi 36 wap |
|OUT---------------'
iz 51 fgo N12 48 15 wap
di 22 bis Y12 52 17 bis
hi 78 wap N34 55 36 wap
DONE!!!!!
RESULT:
jo 37 gfs M24 3 14 bis
su 67 gfs M23 1 143 ffs
bo 46 bis Y32 2 7 wap
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
su 67 gfs M23 11 17 bis
mo 17 mhd N12 14 17 dls
mo 17 mhd N12 15 14 dls
ab 34 gfs Y23 17 211 wap
ng 34 ffs N12 18 99 mhd
mo 17 mhd N12 20 17 bis
jo 37 gfs M24 19 52 bis
bo 46 bis Y32 21 17 fgo
ng 34 ffs N12 24 17 mhd
kz 55 gfs Y21 25 14 ffs
jo 37 gfs M24 26 34 wap
bo 46 bis Y32 27 17 wap
bo 46 bis Y32 28 76 dls
jo 37 gfs M24 31 17 wap
jo 37 gfs M24 32 15 ffs
su 67 gfs M23 33 214 fgo
su 67 gfs M23 36 14 wap
mo 17 mhd N12 40 17 wap
mo 17 mhd N12 42 52 dls
ab 34 gfs Y23 43 14 fgo
ng 34 ffs N12 44 17 bis
kz 55 gfs Y21 45 17 ffs
jo 37 gfs M24 46 67 wap
bo 46 bis Y32 47 3 dls
mo 17 mhd N12 53 17 bis
mo 17 mhd N12 54 44 fgo
ab 34 gfs Y23 56 123 fgo
ng 34 ffs N12 57 111 mhd
ma 54 ffs Y32 5 18 dls
na 78 zap N21 7 34 gfs
li 56 gfs Y32 8 127 min
di 22 bis Y12 10 15 bis
iz 51 fgo N12 12 243 ffs
di 22 bis Y12 13 12 wap
hi 78 wap N34 16 53 dls
iz 51 fgo N12 22 14 wap
di 22 bis Y12 23 5 wap
di 22 bis Y12 23 5 wap
iz 51 fgo N12 30 34 bis
ma 54 ffs Y32 29 154 min
li 56 gfs Y32 34 12 wap
na 78 zap N21 35 8 gfs
cy 7 fgo M23 37 143 wap
iz 51 fgo N12 38 164 fgo
di 22 bis Y12 39 99 mhd
hi 78 wap N34 41 6 fgo
iz 51 fgo N12 51 17 dls
di 22 bis Y12 49 24 dls
cy 7 fgo M23 50 53 wap
iz 51 fgo N12 48 15 wap
di 22 bis Y12 52 17 bis
hi 78 wap N34 55 36 wap
Starting over but this time
replacing both hash functions
(h and k):
DV(S.NM)
13
17
20
73
98
224
R0__280
288
345
354
389
472
474
R1__477
R|X|S.NM
|||=#bytes ||=#tuples |=#pgs
|||M|||=190, |||I/O-pg|||=30
m'=#rec-slots for R0..RB,
n =#recs in R|XS.NM
d =#recs/pg
Mem: IN,OUT,DV-buf,R1,..,RB=1pg,
rest R0
1. JV=DV(S.MN)
2. Determine B: m'=10, n=14, d=3
Condition defining B:
B=0 if n<=m', else
B=1 if m' 0 9
0 1
0 35
0 32
vid=17-> 1 24
1 44
vid=20-> 2 17
2 43
2 23
2 56
vid=73-> 3 13
3 18
3 39
3 40
3 14
3 53
3 52
vid=98-> 4 19
4 0
4 5
4 31
4 45
4 30
4 25
vid=224- 5 28
5 46
5 26
5 20
5 2
5 4
vid=280- 6 55
6 42
6 16
Sort on S-rid:
SOT0(S.A)
slot S-rid
4 0
0 1
5 2
5 4
4 5
0 9
3 13
3 14
6 16
2 17
3 18
4 19
5 20
2 23
1 24
4 25
5 26
5 28
4 30
4 31
0 32
0 35
3 39
3 40
6 42
2 43
1 44
4 45
5 46
3 52
3 53
6 55
2 56
Construct SOT1(S.A):
slot S-rid
vid=288-> 0 29
0 3
vid=345-> 1 33
1 7
vid=354-> 2 37
2 27
2 21
2 11
2 47
2 50
vid=389-> 3 36
3 49
vid=472-> 4 12
4 38
4 10
4 48
4 51
4 22
vid=474-> 5 41
5 54
5 15
vid=477-> 6 8
6 6
6 34
Sort: SOT1(S.A)
slot S-rid
0 3
6 6
1 7
6 8
4 10
2 11
4 12
5 15
2 21
4 22
2 27
0 29
1 33
6 34
3 36
2 37
4 38
5 41
2 47
4 48
3 49
2 50
4 51
5 54
Write TEMP file:
(for S-pg 1-5)
.------------pg1.
| slot S-rid |
SOT0 4 0 |
| 0 1 |
| 5 2 |
| 5 4 |
| 4 5 |
| 0 9 |
| 3 13 |
| 3 14 |
SOV1 |
| 00010011 |
| 1011100 |
----------------'
Note:
Don't need SOV1.
B>=4, saves to use SOBV
instead of SOVi's.
(for S-pg 6-10)
.------------pg2.
| slot S-rid |
SOT0 6 16 |
| 2 17 |
| 3 18 |
| 4 19 |
| 5 20 |
| 2 23 |
| 1 24 |
| 4 25 |
| 5 26 |
| 5 28 |
----------------
(for S-pg 11-15)
.------------pg3.
| slot S-rid |
SOT0 4 30 |
| 4 31 |
| 0 32 |
| 0 35 |
| 3 39 |
| 3 40 |
| 6 42 |
| 2 43 |
| 1 44 |
| |
----------------
(for S-pg 16-19).
.------------pg4.
| slot S-rid |
| 4 45 |
| 5 46 |
| 3 52 |
| 3 53 |
| 6 55 |
| 2 56 |
| |
`---------------'
Next write SOT1:
.------------pg1.
| slot S-rid |
| 0 3 |
| 6 6 |
| 1 7 |
| 6 8 |
| 4 10 |
| 2 11 |
| 4 12 |
| 5 15 |
| 2 21 |
| |
| |
`---------------'
SOT1 replaces k hash
during PROBE phase of R1-S1
.------------pg2.
| slot S-rid |
| 4 22 |
| 2 27 |
| 0 29 |
| 1 33 |
| 6 34 |
| 3 36 |
| 2 37 |
| 4 38 |
| 5 41 |
| |
| |
`---------------'
.------------pg3.
| slot S-rid |
| 2 47 |
| 3 49 |
| 2 50 |
| 4 51 |
| 5 54 |
| |
| |
| |
| |
| |
| |
`---------------'
5. Build R0 of R:
|0: su 67 gfs M23
|1:
|2:
|3:
|4:
|5:
|6:
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
sd 81 fgo N12 98
su 67 gfs M23 224
ke 78 fgo Y32 280
|OUT-----------|
| |
| |
|0: su 67 gfs M23
|1: kz 55 gfs Y21
|2:
|3:
|4:
|5:
|6:
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
fc 64 ffs Y12 98
op 77 fgo M43 224
kz 55 gfs Y21 280
|OUT-----------|
| |
| |
|0: su 67 gfs M23
|1: kz 55 gfs Y21
|2: ng 34 ffs N12
|3:
|4:
|5:
|6:
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
sg 17 dls M2 98
do 82 fgo N21 224
ng 34 ffs N12 280
|OUT-----------|
| |
| |
|0: su 67 gfs M23
|1: kz 55 gfs Y21
|2: ng 34 ffs N12
|3: mo 17 mhd N12
|4:
|5:
|6:
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
jj 17 min N21 98
mo 17 mhd N12 224
ja 17 dls M23 280
|OUT-----------|
| |
| |
|0: su 67 gfs M23
|1: kz 55 gfs Y21
|2: ng 34 ffs N12
|3: mo 17 mhd N12
|4: jo 37 gfs M24
|5:
|6:
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
ak 23 mhd M43 98
rm 23 fgo Y23 224
jo 37 gfs M24 280
|OUT-----------|
| |
| |
|0: su 67 gfs M23
|1: kz 55 gfs Y21
|2: ng 34 ffs N12
|3: mo 17 mhd N12
|4: jo 37 gfs M24
|5: bo 46 bis Y32
|6:
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
gq 28 bis N12 98
fz 47 bis M23 224
bo 46 bis Y32 280
|OUT-----------|
| |
| |
|0: su 67 gfs M23
|1: kz 55 gfs Y21
|2: ng 34 ffs N12
|3: mo 17 mhd N12
|4: jo 37 gfs M24
|5: bo 46 bis Y32
|6: ab 34 gfs Y23
|R1------------.DVbuf
| | 13
| | 17
| | 20
|IN------------| 73
ok 35 min M43 98
ab 34 gfs Y23 224
fw 35 min M24 280
|OUT-----------|
6. Probe the file S.
i. Read 1st pg of TEMP0.
ii. Read 1st req S-pg
(rids 0,1,2)
iii.
Concatenate matches (by slot#)
and output. (Note that all 3
match from this page and that
SOV1 is unnecessary since SOT0
tells us that SOV1-pos'
4,7,8,9,11,12,13 are 1's - if
B>1, then we need SOVi's)
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 1 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join...
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
-----R1 -----------.slot-rid
| | 4 0
| | 0 1
| | 5 2
|IN-------------rid| 5 4
3 jo 14 bis 0 4 5
1 su 143 ffs 1 0 9
2 bo 7 wap 2 3 13
|OUT------------ 3 14
jo 37 gfs M24 3 14 bis
su 67 gfs M23 1 143 ff
bo 46 bis Y32 2 7 wap
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 2 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join...
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1-----------------slot-rid-
3 5 ma 18 dls 4 0
| | 0 1
| | 5 2
|IN-------------rid| 5 4 <-
5 ma 18 dls 3 4 5
4 bo 17 dls 4 0 9
6 jo 54 bis 5 3 13
|OUT_______________| 3 14
(pg output to result file)
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 3 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1-----------------slot-rid-
pg written to S1 | 4 0
8 9 na 154 min 0 1
| 5 2
|IN-------------rid| 5 4
7 na 34 gfs 6 4 5
8 li 127 min 7 0 9
9 na 154 min 8 3 13
|OUT_______________| 3 14
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 4 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1-----------------slot-rid-
8 9 na 154 min 4 0 |
10 10 di 15 bis 0 1 D
11 12 iz 243 ffs 5 2 V
|IN-------------rid| 5 4 b
11 su 17 bis 9 4 5 u
10 di 15 bis 10 0 9 f
12 iz 243 ffs 11 3 13 |
|OUT_______________| 3 14 |
bo 46 bis Y32 4 17 dls |
jo 37 gfs M24 6 54 bis |
su 67 gfs M23 11 17 bis |
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 5 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1-----------------slot-rid-
(pg written to S | 4 0 |
12 13 di 12 wap 0 1 D
| 5 2 V
|IN-------------rid| 5 4 b
13 di 12 wap 12 4 5 u
14 mo 17 dls 13 0 9 f
15 mo 14 dls 14 3 13 |
|OUT_______________| 3 14 |
su 67 gfs M23 11 17 bis |
mo 17 mhd N12 14 17 dls |
mo 17 mhd N12 15 14 dls |
|0: su 67 gfs M23 Read new SOT0-pg
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 6 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 6 16
12 13 di 12 wap 2 17
15 16 hi 53 dls 3 18
| 4 19
|IN-------------rid| 5 20
16 hi 53 dls 15 2 23
17 ab 211 wap 16 1 24
18 ng 99 mhd 17 4 25
|OUT_______________| 5 26
(page output to resu 5 27
ab 34 gfs Y23 17 211 wap
ng 34 ffs N12 18 99 mhd
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 7 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1----------------- 6 16
12 13 di 12 wap 2 17
15 16 hi 53 dls 3 18
| 4 19
|IN-------------rid| 5 20
20 mo 17 bis 18 2 23
19 jo 52 bis 19 1 24
21 bo 17 fgo 20 4 25
|OUT_______________| 5 26
(pg output to result 5 28 |
jo 37 gfs M24 19 52 bis |
bo 46 bis Y32 21 17 fgo |
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 8 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1----------------- 6 16
(pg output to S1 | 2 17 |
22 23 di 5 wap 3 18 D
| 4 19 V
|IN-------------rid| 5 20 b
22 iz 14 wap 21 2 23 u
23 di 5 wap 22 1 24 f
24 ng 17 mhd 23 4 25 |
|OUT_______________| 5 26 |
jo 37 gfs M24 19 5 28 |
bo 46 bis Y32 21 17 fgo |
ng 34 ffs N12 24 17 mhd |
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 9 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1----------------- 6 16
22 23 di 5 wap 2 17 |
| 3 18 D
| 4 19 V
|IN-------------rid| 5 20 b
25 kz 14 ffs 24 2 23 u
26 jo 34 wap 25 1 24 f
27 bo 17 wap 26 4 25 |
|OUT_______________| 5 26 |
(pg output to result 5 28 |
kz 55 gfs Y21 25 14 ffs |
jo 37 gfs M24 26 34 wap |
bo 46 bis Y32 27 17 wap
|0: su 67 gfs M23 R0
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 10 of S,
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |
|R1----------------- 6 16
22 23 di 5 wap 2 17 |
27 30 iz 34 bis 3 18 D
29 29 ma 154 min 4 19 V
|IN-------------rid| 5 20 b
30 iz 34 bis 27 2 23 u
28 bo 76 dls 28 1 24 f
29 ma 154 min 29 4 25 |
|OUT_______________| 5 26 |
(pg output to result 5 28
bo 46 bis Y32 28 76 dls
|0: su 67 gfs M23 Read 3rd SOV0-pg
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 11 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 30
22 23 di 5 wap 4 31
27 30 iz 34 bis 0 32
29 29 ma 154 min 0 35
|IN-------------rid| 3 39
31 jo 17 wap 30 3 40
32 jo 15 ffs 31 6 42
33 su 214 fgo 32 2 43
|OUT_______________| 1 44
(pg output to result file)
su 67 gfs M23 33 214 fgo
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 12 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 30
(pg output to S1 | 4 31
33 34 li 12 wap 0 32
34 35 na 8 gfs 0 35
|IN-------------rid| 3 39
34 li 12 wap 33 3 40
35 na 8 gfs 34 6 42
36 su 14 wap 35 2 43
|OUT_______________| 1 44
su 67 gfs M23 33 214 fgo
su 67 gfs M23 36 14 wap
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 13 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 30
(pg output to S1 | 4 31
37 38 iz 164 fgo 0 32
38 39 di 99 mhd 0 35
|IN-------------rid| 3 39
37 cy 143 wap 36 3 40
38 iz 164 fgo 37 6 42
39 di 99 mhd 38 2 43
|OUT_______________| 1 44
su 67 gfs M23 33 214 fgo
su 67 gfs M23 36 14 wap
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 14 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 30
37 38 iz 164 fgo 4 31
38 39 di 99 mhd 0 32
41 41 hi 6 fgo 0 35
|IN-------------rid| 3 39
40 mo 17 wap 39 3 40
42 mo 52 dls 40 6 42
41 hi 6 fgo 41 2 43
|OUT_______________| 1 44
(pg output to result file)
mo 17 mhd N12 42 52 dls
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 15 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 30
37 38 iz 164 fgo 4 31
38 39 di 99 mhd 0 32
41 41 hi 6 fgo 0 35
|IN-------------rid| 3 39
43 ab 14 fgo 42 3 40
44 ng 17 bis 43 6 42
45 kz 17 ffs 44 2 43
|OUT_______________| 1 44
(pg output to result file)
kz 55 gfs Y21 45 17 ffs
|0: su 67 gfs M23 Read 4th SOV0-pg
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 16 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 45
(pg output to S1 | 5 46
47 51 iz 17 dls 3 52
| 3 53
|IN-------------rid| 6 55
46 jo 67 wap 45 2 56
47 bo 3 dls 46
51 iz 17 dls 47
|OUT_______________|________
kz 55 gfs Y21 45 17 ffs
jo 37 gfs M24 46 67 wap
bo 46 bis Y32 47 3 dls
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 17 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 45
(pg output to S1 | 5 46
50 48 iz 15 wap 3 52
| 3 53
|IN-------------rid| 6 55
49 di 24 dls 48 2 56
50 cy 53 wap 49
48 iz 15 wap 50
|OUT_______________|________
kz 55 gfs Y21 45 17 ffs
jo 37 gfs M24 46 67 wap
bo 46 bis Y32 47 3 dls
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 18 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 45
50 48 iz 15 wap 5 46
51 52 di 17 bis 3 52
| 3 53
|IN-------------rid| 6 55
52 di 17 bis 51 2 56
53 mo 17 bis 52
54 mo 44 fgo 53
|OUT_______________|________
(pg output to result file)
mo 17 mhd N12 53 17 bis
mo 17 mhd N12 54 44 fgo
|0: su 67 gfs M23
|1: kz 55 gfs Y21 | Read page
|2: ng 34 ffs N12 | 19 of S.
|3: mo 17 mhd N12 | R0/R1 ??,
|4: jo 37 gfs M24 | join/R1'ed
|5: bo 46 bis Y32 |
|6: ab 34 gfs Y23 |____
|R1----------------- 4 45
50 48 iz 15 wap 5 46
51 52 di 17 bis 3 52
54 55 hi 36 wap 3 53
|IN-------------rid| 6 55
55 hi 36 wap 54 2 56
56 ab 123 fgo 55
57 ng 111 mhd 56
|OUT_______________|________
(pg output to result file)
ng 34 ffs N12 57 111 mhd
(flush last S1 & result pgs)
S-rid
S1 3 5 ma 18 dls
6 7 na 34 gfs
7 8 li 127 min
8 9 na 154 min
10 10 di 15 bis
11 12 iz 243 ffs
12 13 di 12 wap
15 16 hi 53 dls
21 22 iz 14 wap
22 23 di 5 wap
27 30 iz 34 bis
29 29 ma 154 min
33 34 li 12 wap
34 35 na 8 gfs
36 37 cy 143 wap
37 38 iz 164 fgo
38 39 di 99 mhd
41 41 hi 6 fgo
47 51 iz 17 dls
48 49 di 24 dls
49 50 cy 53 wap
50 48 iz 15 wap
51 52 di 17 bis
54 55 hi 36 wap
Process R1:
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: |
|2: |
|3: |
|4: |
|5: |
|6: |
|R1------------.DVbuf--|
DV(S.NM)
288 <--
345
|IN----------------.354
ma 54 ffs Y32 |389
ae 35 dls Y12 |472
nx 35 zap M43 |474
|OUT---------------'477
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: li 56 gfs Y32 |
|2: |
|3: |
|4: |
|5: |
|6: |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345 <--
|IN----------------.354
li 56 gfs Y32 |389
ah 47 fgo Y12 |472
cu 56 gfs M43 |474
|OUT---------------'477
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: li 56 gfs Y32 |
|2: iz 51 fgo N12 |
|3: |
|4: |
|5: |
|6: |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354 <--
iz 51 fgo N12 |389
bg 63 gfs M23 |472
dh 51 fgo Y32 |474
|OUT---------------'477
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: li 56 gfs Y32 |
|2: iz 51 fgo N12 |
|3: cy 7 fgo M23 |
|4: |
|5: |
|6: |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
dj 14 ffs N21 |389 <--
nr 53 fgo N12 |472
cy 7 fgo M23 |474
|OUT---------------'477
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: li 56 gfs Y32 |
|2: iz 51 fgo N12 |
|3: cy 7 fgo M23 |
|4: di 22 bis Y12 |
|5: |
|6: |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
fg 33 wap Y32 |389
di 22 bis Y12 |472 <--
rl 62 zap M43 |474
|OUT---------------'477
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: li 56 gfs Y32 |
|2: iz 51 fgo N12 |
|3: cy 7 fgo M23 |
|4: di 22 bis Y12 |
|5: hi 78 wap N34 |
|6: |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
hi 78 wap N34 |389
pw 42 dls Y21 |472
bq 38 ffs M2 |474 <--
|OUT---------------'477
---------------------M-.
|0: ma 54 ffs Y32 R0
|1: li 56 gfs Y32 |
|2: iz 51 fgo N12 |
|3: cy 7 fgo M23 |
|4: di 22 bis Y12 |
|5: hi 78 wap N34 |
|6: na 78 zap N21 |
|R1------------.DVbuf--|
| | DV(S.NM)
| | 288
| | 345
|IN----------------.354
na 78 zap N21 |389
gw 17 bis N12 |472
ph 81 min M23 |474
477 <--
6. Process the file S1.
i. Read SOT1,pg 1
ii. Concat and output
---------------------M-.SOT1----
|0: ma 54 ffs Y32 |slot S-rid
|1: li 56 gfs Y32 | 0 3
|2: iz 51 fgo N12 | 6 6
|3: cy 7 fgo M23 | 1 7
|4: di 22 bis Y12 | 6 8
|5: hi 78 wap N34 | 4 10
|6: na 78 zap N21 | 2 11
Srid-IN ---------------| 4 12
3 5 ma 18 dls 5 15
6 7 na 34 gfs 2 21
7 8 li 127 min 4 22
|OUT----------------------------
ma 54 ffs Y32 5 18 dls
na 78 zap N21 7 34 gfs
li 56 gfs Y32 8 127 min
Second page of S1:
---------------------M-.SOT1----
|0: ma 54 ffs Y32 |slot S-rid
|1: li 56 gfs Y32 | 0 3
|2: iz 51 fgo N12 | 6 6
|3: cy 7 fgo M23 | 1 7
|4: di 22 bis Y12 | 6 8
|5: hi 78 wap N34 | 4 10
|6: na 78 zap N21 | 2 11
Srid-IN ---------------| 4 12
8 9 na 154 min 5 15
10 10 di 15 bis 2 21
11 12 iz 243 ffs 4 22
|OUT---------------'
di 22 bis Y12 10 15 bis
iz 51 fgo N12 12 243 ffs
di 22 bis Y12 13 12 wap
Third page of S1:
---------------------M-.SOT1----
|0: ma 54 ffs Y32 |slot S-rid
|1: li 56 gfs Y32 | 0 3
|2: iz 51 fgo N12 | 6 6
|3: cy 7 fgo M23 | 1 7
|4: di 22 bis Y12 | 6 8
|5: hi 78 wap N34 | 4 10
|6: na 78 zap N21 | 2 11
Srid-IN ---------------| 4 12
12 13 di 12 wap 5 15
15 16 hi 53 dls 2 21
21 22 iz 14 wap
|OUT---------------'
hi 78 wap N34 16 53 dls
iz 51 fgo N12 22 14 wap
di 22 bis Y12 23 5 wap
4th page of S1:
Read SOT1-pg2.
---------------------M-.SOT1----
|0: iz 51 fgo N12 |slot S-rid
|1: cy 7 fgo M23 | 4 22
|2: hi 78 wap N34 | 2 27
|3: na 78 zap N21 | 0 29
|4: di 22 bis Y12 | 1 33
|5: ma 54 ffs Y32 | 6 34
|6: li 56 gfs Y32 | 3 36
Srid-IN ---------------| 2 37
22 23 di 5 wap 4 38
27 30 iz 34 bis 5 41
29 29 ma 154 min
|OUT---------------'
di 22 bis Y12 23 5 wap
iz 51 fgo N12 30 34 bis
ma 54 ffs Y32 29 154 min
5th page of S1:
---------------------M-.SOT1----
|0: iz 51 fgo N12 R0slot S-rid
|1: cy 7 fgo M23 | 4 22
|2: hi 78 wap N34 | 2 27
|3: na 78 zap N21 | 0 29
|4: di 22 bis Y12 | 1 33
|5: ma 54 ffs Y32 | 6 34
|6: li 56 gfs Y32 | 3 36
Srid-IN ---------------| 2 37
33 34 li 12 wap 4 38
34 35 na 8 gfs 5 41
36 37 cy 143 wap
|OUT---------------'
li 56 gfs Y32 34 12 wap
na 78 zap N21 35 8 gfs
cy 7 fgo M23 37 143 wap
6th page of S1:
---------------------M-.SOT1----
|0: iz 51 fgo N12 R0slot S-rid
|1: cy 7 fgo M23 | 4 22
|2: hi 78 wap N34 | 2 27
|3: na 78 zap N21 | 0 29
|4: di 22 bis Y12 | 1 33
|5: ma 54 ffs Y32 | 6 34
|6: li 56 gfs Y32 | 3 36
Srid-IN ---------------| 2 37
37 38 iz 164 fgo 4 38
38 39 di 99 mhd 5 41
41 41 hi 6 fgo
|OUT---------------'
iz 51 fgo N12 38 164 fgo
di 22 bis Y12 39 99 mhd
hi 78 wap N34 41 6 fgo
7th page of S1:
Read SOT1-pg3.
---------------------M-.SOT1----
|0: iz 51 fgo N12 R0slot S-rid
|1: cy 7 fgo M23 | 2 47
|2: hi 78 wap N34 | 3 49
|3: na 78 zap N21 | 2 50
|4: di 22 bis Y12 | 4 51
|5: ma 54 ffs Y32 | 5 54
|6: li 56 gfs Y32 |
Srid-IN ---------------|
47 51 iz 17 dls
48 49 di 24 dls
49 50 cy 53 wap
|OUT---------------'
iz 51 fgo N12 51 17 dls
di 22 bis Y12 49 24 dls
cy 7 fgo M23 50 53 wap
8th page of S1:
---------------------M-.SOT1----
|0: iz 51 fgo N12 R0slot S-rid
|1: cy 7 fgo M23 | 2 47
|2: hi 78 wap N34 | 3 49
|3: na 78 zap N21 | 2 50
|4: di 22 bis Y12 | 4 51
|5: ma 54 ffs Y32 | 5 54
|6: li 56 gfs Y32 |
Srid-IN ---------------|
50 48 iz 15 wap
51 52 di 17 bis
54 55 hi 36 wap
|OUT---------------'
iz 51 fgo N12 48 15 wap
di 22 bis Y12 52 17 bis
hi 78 wap N34 55 36 wap
RESULT:
jo 37 gfs M24 3 14 bis
su 67 gfs M23 1 143 ffs
bo 46 bis Y32 2 7 wap
bo 46 bis Y32 4 17 dls
jo 37 gfs M24 6 54 bis
su 67 gfs M23 11 17 bis
mo 17 mhd N12 14 17 dls
mo 17 mhd N12 15 14 dls
ab 34 gfs Y23 17 211 wap
ng 34 ffs N12 18 99 mhd
mo 17 mhd N12 20 17 bis
jo 37 gfs M24 19 52 bis
bo 46 bis Y32 21 17 fgo
ng 34 ffs N12 24 17 mhd
kz 55 gfs Y21 25 14 ffs
jo 37 gfs M24 26 34 wap
bo 46 bis Y32 27 17 wap
bo 46 bis Y32 28 76 dls
jo 37 gfs M24 31 17 wap
jo 37 gfs M24 32 15 ffs
su 67 gfs M23 33 214 fgo
su 67 gfs M23 36 14 wap
mo 17 mhd N12 40 17 wap
mo 17 mhd N12 42 52 dls
ab 34 gfs Y23 43 14 fgo
ng 34 ffs N12 44 17 bis
kz 55 gfs Y21 45 17 ffs
jo 37 gfs M24 46 67 wap
bo 46 bis Y32 47 3 dls
mo 17 mhd N12 53 17 bis
mo 17 mhd N12 54 44 fgo
ab 34 gfs Y23 56 123 fgo
ng 34 ffs N12 57 111 mhd
ma 54 ffs Y32 5 18 dls
na 78 zap N21 7 34 gfs
li 56 gfs Y32 8 127 min
di 22 bis Y12 10 15 bis
iz 51 fgo N12 12 243 ffs
di 22 bis Y12 13 12 wap
hi 78 wap N34 16 53 dls
iz 51 fgo N12 22 14 wap
di 22 bis Y12 23 5 wap
di 22 bis Y12 23 5 wap
iz 51 fgo N12 30 34 bis
ma 54 ffs Y32 29 154 min
li 56 gfs Y32 34 12 wap
na 78 zap N21 35 8 gfs
cy 7 fgo M23 37 143 wap
iz 51 fgo N12 38 164 fgo
di 22 bis Y12 39 99 mhd
hi 78 wap N34 41 6 fgo
iz 51 fgo N12 51 17 dls
di 22 bis Y12 49 24 dls
cy 7 fgo M23 50 53 wap
iz 51 fgo N12 48 15 wap
di 22 bis Y12 52 17 bis
hi 78 wap N34 55 36 wap