Browse Benchmarks
Benchmark ::multi_level_exist : Multiple corelated nested query with existential quantification
(submitted at 2006-11-24) |
|---|
| Authors: |
Norman May (University of Mannheim) |
| Categories: |
XQuery,
|
| Target: |
All systems |
| Engine type: |
persistent-storage main-memory |
| Measure: |
The measure targets the total execution time.
|
Result unit: |
Milliseconds |
| Query: |
|---|
|
The naive evaluation of this query evaluates in nested-loops.
This results in a cubic increase in excution time when the document size is increased.
More efficient evaluation strategies scale better.
|
|
Syntax: |
for $u in doc("users.xml")//user_tuple
where some $i in doc("items.xml")//item_tuple
satisfies ($i/offered_by ne $u/userid
and some $b in doc("bids.xml")//bid_tuple
satisfies ($b/userid eq $u/userid
and $b/itemno eq $i/itemno
and ($b/bid cast as xs:double) gt (2.0 * $i/reserve_price)))
return
<result>
{ $u/userid }
</result>
|
|
Language: |
XQuery 1.0 |
| Document: |
|---|
| The document creates a document that conforms to the DTD used for the XQuery Use Case REL. |
|
Generator: |
Toxgene and reldata.tsl |
| Parameters: |
|---|
Parameter
num_items:
the number of items, this is the main scaling parameter
|
|
This parameter characterizes the: |
doc |
|
Unit: |
None. |
|
Values: |
100 1000 10000 |
|
Distribution: |
uniform |
|
Scale: |
ordinal |
|
|
|
Parameter
num_bids_per_item:
The number of bids per item. |
|
This parameter characterizes the: |
doc |
|
Unit: |
None |
|
Values: |
10 |
|
Distribution: |
uniform |
|
Scale: |
ordinal |
|
|
|
|
| Methodology: |
|
Running scenario: queryScale
|
|---|
|
Test the influence of the document size (which depends on parameter
num_items) on the query execution time.
|
| Parameter instantiation: |
|
Name |
Value(s) |
|
num_items |
100
,
1000
,
10000 |
|
|
Download the micro-benchmark:
[XML]
|
|