Database Reference
In-Depth Information
Table 3. The experiments queries
Query
No.
Query Name
A set of Individual Query (IQ) Executed in
an Algorithm Sequentially (The Details are
in APPENDIX II)
Q 1
Single Table Query for
a CTT
IQ1
Q 2
Single Table Query for
a VET
IQ2, IQ3, and IQ4
Q 3
One-to-Many Query for
two CTTs
IQ5
Q 4
One-to-Many Query for
two VETs
IQ6, and IQ7
Q 5
One-to-Many Query for
a CTT and a VET.
IQ8, and IQ7.
Q 6
Union Query for Two
CTTs
IQ9, and IQ10
Q 7
Union Query for Two
VETs
IQ2, IQ3, IQ11, IQ12, IQ13, and IQ14
Q 8
Union Query for a CTT
and a VET
IQ9, IQ12, IQ13, and IQ14
Q 9
Left Join Query for two
CTTs
IQ15, IQ16, and IQ17
Q 10
Left Join Query for two
VETs
IQ2, IQ18, IQ19, IQ4, and IQ21
Q 11
Left Join Query for a
CTT and a VET
IQ15, IQ8, IQ20, IQ1, and IQ21
Q 12
Targeted Tables Query
for two CTTs
IQ22, and IQ23
Q 13
Targeted Tables Query
for two VETs
IQ24, IQ25, IQ26, and IQ27
Q 14
Targeted Tables Query
for a CTT and a VET
IQ28, IQ22, IQ29, and IQ27
EETPS functions improved the query execution time for retrievals from VET and CTT-
and-VET when compared to retrieval using CTT (traditional physical tables). Except in
two cases the results show increase in execution times:
rst, when 100 rows are
retrieved from the One-to-Many function, VET is slightly slower than CTT, and sec-
ond, when 1 row is retrieved from the Targeted Tables function VET is slower than
CTT and the average difference between them is 236 ms.
Search WWH ::




Custom Search