Table 17 Final distribution of predicates over fragments
From: On hierarchical clustering-based approach for RDDBS design
Fragment | Query contained | Predicate contained | Data derivation |
|---|---|---|---|
F1 | Q1 and Q2 | P1 and P3 | A6 < 20 and A3 ≥ 4000 |
F2 | Q5 and Q7 | P1 and P4 | A6 < 20 and A3 < 4000 |
F3 | Q6 and Q3 | P2 and P3 | A6 > 20 and A3 ≥ 4000 |
F4 | Q8 and Q4 | P2 and P4 | A6 > 20 and A3 < 4000 |
F5 | Else | – | A6 = 20 |