Database Reference
In-Depth Information
0.6
0.6
CTT
(Q1)
CTT
(Q1)
0.4
0.4
0.2
0.2
0
0
VET
(Q2)
VET
(Q2)
Number of tenant's rows
(a) Single Table 1 Row ( Exp. 1)
Number of tenant's rows
(b) Single Table 100 Rows ( Exp. 1)
0.6
0.6
CTT (Q3)
CTT (Q3)
0.4
0.4
0.2
0.2
VET (Q4)
VET (Q4)
0
0
CTT &
VET (Q5)
CTT &
VET (Q5)
Number of tenant's rows
(c) One-to-Many 1 Row ( Exp. 2)
Number of tenant's rows
(d) One-to-Many 100 Rows ( Exp. 2)
0.8
0.8
CTT (Q9)
CTT (Q6)
0.6
0.6
0.4
0.4
VET
(Q10)
CTT &
VET
(Q11)
VET (Q7)
0.2
0.2
0
0
CTT &
VET (Q8)
Number of tenant's rows
(e) Union 1 Row ( Exp. 3)
Number of tenant's rows
(f) Union 100 Rows ( Exp. 3)
0.8
1.5
CTT (Q9)
CTT (Q6)
0.6
1
0.4
VET
(Q10)
CTT &
VET
(Q11)
0.5
0.2
VET (Q7)
0
0
CTT &
VET (Q8)
Number of tenant's rows
(g) Left Join 1 Row ( Exp. 4)
Number of tenant's rows
(h) Left Join 100 Rows ( Exp. 4)
1
1.5
CTT (Q9)
CTT (Q9)
1
0.5
VET
(Q10)
CTT &
VET
(Q11)
VET
(Q10)
0.5
0
0
CTT &
VET
(Q11)
Number of tenant's rows
(j) Targeted Tables 100 Rows ( Exp. 5)
Number of tenant's rows
(i) Targeted Tables 1 Row ( Exp. 5)
Fig. 16. The queries results
Search WWH ::
Custom Search