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

Table 4. The experiments queries details

Individual
Query (IQ)

Query Details

IQ1 SELECT * FROM product p WHERE p.tenant_id = 1000 ORDER BY

p.product_id LIMIT 1;

IQ2 SELECT tc.table_column_id FROM table_column tc WHERE tc.

tenant_id = 1000 and tc.db_table_id = 16 and tc.
is_primary_key_column = true ORDER BY tc.table_column_id;

IQ3 SELECT distinct ti.table_row_id FROM table_index ti WHERE ti.

tenant_id = 1000 and ti.db_table_id = 16 and ti.table_column_id = 47
LIMIT 1;

IQ4 SELECT tr.table_column_id, tr.value, tr.table_row_id, tr.serial_id FROM

table_row tr WHERE tr.tenant_id = 1000 and tr.db_table_id = 16 and
tr.table_row_id IN (1100) ORDER BY 3,4 LIMIT 8 OFFSET 0;

IQ5 SELECT * FROM sales_fact sf WHERE sf.tenant_id = 1000 andsf.

product_id = 100 ORDER BY sf.sales_fact_id LIMIT 1;

IQ6 SELECT trs.table_column_id FROM table_relationship trs WHERE trs.

tenant_id = 1000 and trs.db_table_id = 17 and trs.table_type = 2 and
trs.target_table_id = ' 16 ' and (trs.table_column_id = 58 or trs.
target_column_id = 58) ORDER BY 1 ASC;

IQ7 SELECT tr.table_column_id, tr.value, tr.table_row_id, tr.serial_id FROM

table_row tr WHERE tr.tenant_id = 1000 and tr.db_table_id = 17 and
tr.table_row_id IN (SELECT distinct tr.table_row_id From table_index
tr WHERE tr.tenant_id = 1000 and tr.db_table_id = 17 and ((tr.
table_column_id = ' 58 ' and tr.value = ' 100 ' )) LIMIT 1 OFFSET 0)
ORDER BY 3,4 ASC LIMIT 11 OFFSET 0;

IQ8 SELECT trs.table_column_id FROM table_relationship trs WHERE trs.

tenant_id = 1000 and trs.db_table_id = 17 and trs.table_type = 1 and
trs.shared_table_name = ' product ' and trs.
shared_column_name = ' product_id ' ORDER BY 1 ASC;

IQ9 SELECT p.product_id, p.price FROM product p WHERE p.

tenant_id = 1000 ORDER BY p.product_id LIMIT 1;

IQ10 SELECT sf.sales_fact_id, sf.unit_price FROM sales_fact sf WHERE sf.

tenant_id = 1000 ORDER BY sf.sales_fact_id LIMIT 1;

IQ11 SELECT tr.table_column_id, tr.value FROM table_row tr WHERE tr.

tenant_id = 1000 and tr.db_table_id = 16 and tr.table_row_id IN (1100)
and table_column_id in (47,52) ORDER BY tr.table_row_id, tr.
serial_id LIMIT 2 OFFSET 0;

IQ12 SELECT tc.table_column_id FROM table_column tc WHERE tc.

tenant_id = 1000 and tc.db_table_id = 17 and tc.
is_primary_key_column = true ORDER BY tc.table_column_id;

IQ13 SELECT distinct ti.table_row_id FROM table_index ti WHERE ti.

tenant_id = 1000 and ti.db_table_id = 17 and ti.table_column_id = 55
LIMIT 1;

IQ14 SELECT tr.table_column_id, tr.value FROM table_row tr WHERE tr.

tenant_id = 1000 and tr.db_table_id = 17 and tr.table_row_id IN
( Continued )