Database Reference
In-Depth Information
executing Query 5 (Q 5) that comprises of IQ8 and IQ7 respectively. The focus of
this experiment is to study each of these two table combinations that have a One-
to-Many relationship between them. The master table of this relation is the
'
table. The structure of these
two tables is shown in Fig.
7
(a) and (b). The value of the
product
'
table, and the details table is the
'
sales_fact
'
'
product_id
'
column that
is used in this experiment equals 100 for both the
'
product
'
CTT and VET. The
'
of the VET is represented as the number 58. The experimental results
of Exp.2 show that there is an approximate symmetry in the performance of the
query execution time of VET and CTT-and-VET and they are one time faster than
CTT when 1 row is retrieved. On the other hand, when 100 rows are retrieved, the
query execution time of CTT is faster than VET, and CTT-and-VET is the fastest
of the three queries. Moreover, the experimental results show that the execution
time of CTT is approximately the same when 1 row and 100 rows are retrieved,
whereas it increases for VET and CTT-and-VET when 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.
9
, and the throughputs of this experiment
are depicted in Fig.
16
(b) and (c).
product_id
'
Fig. 9. The outputs of the Simple-to-Medium Query Experiment (One-to-Many)
(3) Medium Query Experiment - Union (Exp. 3): In this experiment, the function
of the Union Query Algorithm that retrieve data from two tables is invoked by
using a union operator for two CTTs by executing Query 6 (Q 6) that comprises of
IQ9 and IQ10, for two VETs by executing Query 7 (Q 7) that comprises of IQ2,
IQ3, IQ11, IQ12, IQ13, and IQ14, and for CTT-and-VET by executing Query 8
(Q 8) that comprises of IQ9, IQ12, IQ13, and IQ14 respectively. The aim of using
this algorithm is to study, retrieving data from two tables. The
rst table is the
'
product
'
table, and the second table is the
'
sales_fact
'
table. The structures of
Search WWH ::
Custom Search