A Proxy Service for Multi-tenant Elastic Extension Tables - Transactions on Large-Scale-Data-and Knowledge-Centered Systems XX - page 27

1 1.2

1

CTT CTT

0.8

0.8

0.6

0.6

0.4

VET VET

0.4

0.2

0.2

0 0

CTT
&
VET

CTT
&
VET

Fig. 17. The average experimental results of
retrieving 1 row

Fig. 18. The average experimental results of
retrieving 100 rows

Table 1. The average experimental results of retrieving 1 row in milliseconds
Retrieving 1 Row CTT VET CTT-and-VET

Single Table (Exp. 1) Q1 Q2

352 249

One-to-Many (Exp. 2) Q3 Q4 Q5

465 244 238

Union (Exp. 3) Q6 Q7 Q8

579 435 313

Left Join (Exp. 4) Q9 Q10 Q11

621 468 526

Targeted Tables (Exp. 5) Q12 Q13 Q14

640 876 536

Table 2. The average experimental results of retrieving 100 rows in milliseconds.
Retrieving 100 Rows CTT VET CTT-and-VET

Single Table (Exp. 1) Q1 Q2

520 346

One-to-Many (Exp. 2) Q3 Q4 Q5

485 524 325

Union (Exp. 3) Q6 Q7 Q8

580 391 316

Left Join (Exp. 4) Q9 Q10 Q11

920 709 829

Targeted Tables (Exp. 5) Q12 Q13 Q14

1075 889 566