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

' CTT. Second, two VETs by executing Query 10 (Q 10) that comprises

of IQ2, IQ18, IQ19, IQ4, and IQ21. The two VETs are the

sales_fact '

' product VET that

equals 16, and the VET that equals 17. Third, a CTT and a VET by

executing Query 11 (Q 11) that comprises of IQ15, IQ8, IQ20, IQ1, and IQ21
respectively. These two tables are the

' sales_fact '

VET that
equals 17. Figure 11 shows the three Left Join operations that are used in this
experiment. The experimental results of Exp. 4 shows that the query execution time
of CTT-and-VET is faster than CTT, and the VET is the fastest of the three queries
when 1 row and 100 rows are retrieved. The details of the queries used in this
experiment are shown in Tables 3 and 4 , the output of these queries is shown in
Fig. 12 , and the throughputs of this experiment are depicted in Fig. 16 (g) and (h).

' product ' CTT, and the ' sales_fact '

Fig. 11. The three left joins of the Left Join experiment

Fig. 12. The output of the Medium-to-Complex Query Experiment (Left Join)

(5) Complex Query Experiment - Targeted Tables (Exp. 5): In this experiment, the
function of the Targeted Table Query Algorithm is invoked to join two CTTs
by executing Query 12 (Q 12) that comprises of IQ22 and IQ23, two VETs by