You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vxquery.apache.org by pr...@apache.org on 2014/06/26 20:25:40 UTC
[32/36] git commit: Added the mrql and saxon versions of the
benchmark queries.
Added the mrql and saxon versions of the benchmark queries.
- Also updated the q00 and q02 to use stations that exist in GSN and HCN networks.
Project: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/commit/fee9582a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/tree/fee9582a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/diff/fee9582a
Branch: refs/heads/master
Commit: fee9582ab5e1a83a9bd59c91ed16b9c3cfff55d5
Parents: 13ed39e
Author: Preston Carman <pr...@apache.org>
Authored: Tue Jun 24 18:21:04 2014 -0700
Committer: Preston Carman <pr...@apache.org>
Committed: Tue Jun 24 18:21:04 2014 -0700
----------------------------------------------------------------------
.../noaa-ghcn-daily/other_systems/mrql/q00.mrql | 7 +++++++
.../noaa-ghcn-daily/other_systems/mrql/q01.mrql | 5 +++++
.../noaa-ghcn-daily/other_systems/mrql/q02.mrql | 8 ++++++++
.../noaa-ghcn-daily/other_systems/mrql/q03.mrql | 7 +++++++
.../noaa-ghcn-daily/other_systems/mrql/q04.mrql | 9 +++++++++
.../other_systems/mrql/q04_sensor.mrql | 5 +++++
.../other_systems/mrql/q04_station.mrql | 8 ++++++++
.../noaa-ghcn-daily/other_systems/mrql/q05.mrql | 11 +++++++++++
.../other_systems/mrql/q05_sensor.mrql | 7 +++++++
.../other_systems/mrql/q05_station.mrql | 7 +++++++
.../noaa-ghcn-daily/other_systems/mrql/q06.mrql | 12 ++++++++++++
.../other_systems/mrql/q06_sensor.mrql | 7 +++++++
.../other_systems/mrql/q06_station.mrql | 7 +++++++
.../noaa-ghcn-daily/other_systems/mrql/q07.mrql | 11 +++++++++++
.../other_systems/mrql/q07_join_count.mrql | 10 ++++++++++
.../other_systems/mrql/q07_tmax.mrql | 6 ++++++
.../other_systems/mrql/q07_tmin.mrql | 6 ++++++
.../noaa-ghcn-daily/other_systems/saxon/q00.xq | 15 +++++++++++++++
.../noaa-ghcn-daily/other_systems/saxon/q01.xq | 8 ++++++++
.../noaa-ghcn-daily/other_systems/saxon/q02.xq | 14 ++++++++++++++
.../noaa-ghcn-daily/other_systems/saxon/q03.xq | 8 ++++++++
.../noaa-ghcn-daily/other_systems/saxon/q04.xq | 13 +++++++++++++
.../other_systems/saxon/q04_sensor.xq | 10 ++++++++++
.../other_systems/saxon/q04_station.xq | 8 ++++++++
.../noaa-ghcn-daily/other_systems/saxon/q05.xq | 16 ++++++++++++++++
.../other_systems/saxon/q05_sensor.xq | 11 +++++++++++
.../other_systems/saxon/q05_station.xq | 8 ++++++++
.../noaa-ghcn-daily/other_systems/saxon/q06.xq | 13 +++++++++++++
.../other_systems/saxon/q06_sensor.xq | 8 ++++++++
.../other_systems/saxon/q06_station.xq | 5 +++++
.../noaa-ghcn-daily/other_systems/saxon/q07.xq | 15 +++++++++++++++
.../noaa-ghcn-daily/other_systems/saxon/q07_tmax.xq | 9 +++++++++
.../noaa-ghcn-daily/other_systems/saxon/q07_tmin.xq | 9 +++++++++
.../other_systems/saxon/sensor_count.xq | 7 +++++++
.../other_systems/saxon/station_count.xq | 7 +++++++
.../main/resources/noaa-ghcn-daily/queries/q00.xq | 13 ++++++++-----
.../main/resources/noaa-ghcn-daily/queries/q02.xq | 12 +++++++-----
37 files changed, 332 insertions(+), 10 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q00.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q00.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q00.mrql
new file mode 100644
index 0000000..538df72
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q00.mrql
@@ -0,0 +1,7 @@
+select (r)
+from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+where text(r.station) = "GHCND:USW00012836"
+ and toInt(substring(text(r.date), 0, 4)) >= 2003
+ and toInt(substring(text(r.date), 5, 7)) = 12
+ and toInt(substring(text(r.date), 8, 10)) = 25
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q01.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q01.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q01.mrql
new file mode 100644
index 0000000..5e8de9b
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q01.mrql
@@ -0,0 +1,5 @@
+select (r)
+from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+where text(r.dataType) = "AWND"
+ and toInt(text(r.value)) > 491.744
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q02.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q02.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q02.mrql
new file mode 100644
index 0000000..b8cd451
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q02.mrql
@@ -0,0 +1,8 @@
+sum(
+ select (toInt(text(r.value)))
+ from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where text(r.station) = "GHCND:USW00014771"
+ and toInt(substring(text(r.date), 0, 4)) = 1999
+ and text(r.dataType) = "PRCP"
+) / 10
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q03.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q03.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q03.mrql
new file mode 100644
index 0000000..2f85e84
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q03.mrql
@@ -0,0 +1,7 @@
+max(
+ select (toInt(text(r.value)))
+ from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where text(r.dataType) = "TMAX"
+ and toInt(substring(text(r.date), 0, 4)) = 1999
+) / 10
+;
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04.mrql
new file mode 100644
index 0000000..68ee5ec
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04.mrql
@@ -0,0 +1,9 @@
+select (r)
+from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"}),
+ t in source(xml, "sample_xml/gsn_stations.xml", {"station"}),
+ l in t.locationLabels
+where text(t.id) = text(r.station)
+ and text(r.date) = "1976-07-04T00:00:00.000"
+ and text(r.dataType) = "TMAX"
+ and text(l.displayName) = "WASHINGTON"
+;
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_sensor.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_sensor.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_sensor.mrql
new file mode 100644
index 0000000..bf30e52
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_sensor.mrql
@@ -0,0 +1,5 @@
+select (r)
+from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+where text(r.date) = "1976-07-04T00:00:00.000"
+ and text(r.dataType) = "TMAX"
+;
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_station.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_station.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_station.mrql
new file mode 100644
index 0000000..fdd6fba
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q04_station.mrql
@@ -0,0 +1,8 @@
+count(
+ select (r)
+ from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"}),
+ t in source(xml, "sample_xml/gsn_stations.xml", {"station"}),
+ l in t.locationLabels
+ where text(l.displayName) = "WASHINGTON"
+)
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05.mrql
new file mode 100644
index 0000000..5b940f3
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05.mrql
@@ -0,0 +1,11 @@
+min(
+ select (toInt(text(r.value)))
+ from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"}),
+ t in source(xml, "sample_xml/gsn_stations.xml", {"station"}),
+ l in t.locationLabels
+ where text(t.id) = text(r.station)
+ and toInt(substring(text(r.date), 0, 4)) = 2001
+ and text(r.dataType) = "TMIN"
+ and text(l.id) = "FIPS:US"
+) / 10
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_sensor.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_sensor.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_sensor.mrql
new file mode 100644
index 0000000..232b07b
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_sensor.mrql
@@ -0,0 +1,7 @@
+count(
+ select (toInt(text(r.value)))
+ from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where toInt(substring(text(r.date), 0, 4)) = 2001
+ and text(r.dataType) = "TMIN"
+)
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_station.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_station.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_station.mrql
new file mode 100644
index 0000000..b47aeef
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q05_station.mrql
@@ -0,0 +1,7 @@
+count(
+ select (t)
+ from t in source(xml, "sample_xml/gsn_stations.xml", {"station"}),
+ l in t.locationLabels
+ where text(l.id) = "FIPS:US"
+)
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06.mrql
new file mode 100644
index 0000000..f84f803
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06.mrql
@@ -0,0 +1,12 @@
+select (n, d, v)
+from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"}),
+ d in r.date,
+ v in r.value,
+ t in source(xml, "sample_xml/gsn_stations.xml", {"station"}),
+ n in t.displayName,
+ l in t.locationLabels
+where text(t.id) = text(r.station)
+ and toInt(substring(text(d), 0, 4)) = 2000
+ and text(r.dataType) = "TMAX"
+ and text(l.displayName) = "WASHINGTON"
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_sensor.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_sensor.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_sensor.mrql
new file mode 100644
index 0000000..5050654
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_sensor.mrql
@@ -0,0 +1,7 @@
+count(
+ select (r.date, r.value)
+ from r in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where toInt(substring(text(r.date), 0, 4)) = 2000
+ and text(r.dataType) = "TMAX"
+)
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_station.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_station.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_station.mrql
new file mode 100644
index 0000000..78e3297
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q06_station.mrql
@@ -0,0 +1,7 @@
+count(
+ select (t.displayName)
+ from t in source(xml, "sample_xml/gsn_stations.xml", {"station"}),
+ l in t.locationLabels
+ where text(l.displayName) = "WASHINGTON"
+)
+;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07.mrql
new file mode 100644
index 0000000..40662dd
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07.mrql
@@ -0,0 +1,11 @@
+avg(
+ select (toInt(text(rtmax.value))-toInt(text(rtmin.value)))
+ from rtmax in source(xml, "sample_xml/gsn_sensors.xml", {"data"}),
+ rtmin in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where text(rtmax.date) = text(rtmin.date)
+ and text(rtmax.station) = text(rtmin.station)
+ and text(rtmax.dataType) = "TMAX"
+ and text(rtmin.dataType) = "TMIN"
+) / 10
+;
+
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_join_count.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_join_count.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_join_count.mrql
new file mode 100644
index 0000000..2f41db1
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_join_count.mrql
@@ -0,0 +1,10 @@
+count(
+ select (toInt(text(rtmax.value))-toInt(text(rtmin.value)))
+ from rtmax in source(xml, "sample_xml/gsn_sensors.xml", {"data"}),
+ rtmin in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where text(rtmax.date) = text(rtmin.date)
+ and text(rtmax.station) = text(rtmin.station)
+ and text(r.dataType) = "TMAX"
+ and text(r.dataType) = "TMIN"
+)
+;
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmax.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmax.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmax.mrql
new file mode 100644
index 0000000..3db5107
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmax.mrql
@@ -0,0 +1,6 @@
+count(
+ select (rtmax)
+ from rtmax in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where text(r.dataType) = "TMAX"
+)
+;
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmin.mrql
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmin.mrql b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmin.mrql
new file mode 100644
index 0000000..9c93116
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_tmin.mrql
@@ -0,0 +1,6 @@
+count(
+ select (rtmin)
+ from rtmin in source(xml, "sample_xml/gsn_sensors.xml", {"data"})
+ where text(r.dataType) = "TMIN"
+)
+;
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q00.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q00.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q00.xq
new file mode 100644
index 0000000..09c5b79
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q00.xq
@@ -0,0 +1,15 @@
+(:
+XQuery Filter Query
+-------------------
+See historical data for Key West International Airport, FL (USW00012836)
+station by selecting the weather readings for December 25 over the last
+10 years.
+:)
+let $collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+for $r in collection($collection)/root/dataCollection/data
+let $datetime := xs:dateTime(fn:data($r/date))
+where $r/station eq "GHCND:USW00012836"
+ and fn:year-from-dateTime($datetime) ge 2003
+ and fn:month-from-dateTime($datetime) eq 12
+ and fn:day-from-dateTime($datetime) eq 25
+return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q01.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q01.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q01.xq
new file mode 100644
index 0000000..39d7e20
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q01.xq
@@ -0,0 +1,8 @@
+(: XQuery Filter Query :)
+(: Find all reading for hurricane force wind warning or extreme wind warning. :)
+(: The warnings occur when the wind speed (AWND) exceeds 110 mph (49.1744 :)
+(: meters per second). (Wind value is in tenth of a meter per second) :)
+let $collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+for $r in fn:collection($collection)/root/dataCollection/data
+where $r/dataType eq "AWND" and xs:decimal($r/value) gt 491.744
+return $r
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q02.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q02.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q02.xq
new file mode 100644
index 0000000..3fb0975
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q02.xq
@@ -0,0 +1,14 @@
+(:
+XQuery Aggregate Query
+----------------------
+Find the annual precipitation (PRCP) for a Syracuse, NY using the airport
+weather station (USW00014771) report for 1999.
+:)
+fn:sum(
+ let $collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($collection)/root/dataCollection/data
+ where $r/station eq "GHCND:USW00014771"
+ and $r/dataType eq "PRCP"
+ and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 1999
+ return $r/value
+) div 10
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q03.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q03.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q03.xq
new file mode 100644
index 0000000..cda344a
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q03.xq
@@ -0,0 +1,8 @@
+(: XQuery Aggregate Query :)
+(: Find the highest recorded temperature (TMAX) in Celsius. :)
+fn:max(
+ let $collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($collection)/root/dataCollection/data
+ where $r/dataType eq "TMAX"
+ return $r/value
+) div 10
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04.xq
new file mode 100644
index 0000000..09752d1
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04.xq
@@ -0,0 +1,13 @@
+(: XQuery Join Query :)
+(: Find all the weather readings for King county for a specific day :)
+(: 1976/7/4. :)
+let $collection2 := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+for $r in collection($collection2)/root/dataCollection/data
+
+let $collection1 := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+for $s in collection($collection1)/root/stationCollection/station
+
+where $s/id eq $r/station
+ and (some $x in $s/locationLabels satisfies ($x/type eq "ST" and fn:upper-case(fn:data($x/displayName)) eq "WASHINGTON"))
+ and xs:dateTime(fn:data($r/date)) eq xs:dateTime("1976-07-04T00:00:00.000")
+return $r
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_sensor.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_sensor.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_sensor.xq
new file mode 100644
index 0000000..6c927a4
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_sensor.xq
@@ -0,0 +1,10 @@
+(: XQuery Join Query :)
+(: Count all the weather sensor readings on 1976-07-04. :)
+count(
+ let $sensor_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($sensor_collection)/root/dataCollection/data
+
+ let $date := xs:date(fn:substring(xs:string(fn:data($r/date)), 0, 11))
+ where $date eq xs:date("1976-07-04")
+ return $r
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_station.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_station.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_station.xq
new file mode 100644
index 0000000..957aec0
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q04_station.xq
@@ -0,0 +1,8 @@
+(: XQuery Join Query :)
+(: Count all the weather stations for King county. :)
+count(
+ let $station_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+ for $s in collection($station_collection)/root/stationCollection/station
+ where (some $x in $s/locationLabels satisfies ($x/type eq "CNTY" and fn:contains(fn:upper-case(fn:data($x/displayName)), "KING")))
+ return $s
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05.xq
new file mode 100644
index 0000000..eca1c68
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05.xq
@@ -0,0 +1,16 @@
+(: XQuery Join Aggregate Query :)
+(: Find the lowest recorded temperature (TMIN) in the state of Oregon for :)
+(: 2001. :)
+fn:min(
+ let $collection2 := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($collection2)/root/dataCollection/data
+
+ let $collection1 := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+ for $s in collection($collection1)/root/stationCollection/station
+
+ where $s/id eq $r/station
+ and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
+ and $r/dataType eq "TMIN"
+ and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
+ return $r/value
+) div 10
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_sensor.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_sensor.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_sensor.xq
new file mode 100644
index 0000000..4ac353b
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_sensor.xq
@@ -0,0 +1,11 @@
+(: XQuery Join Aggregate Query :)
+(: Count all sensor readings for TMIN in 2001. :)
+count(
+ let $sensor_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($sensor_collection)/root/dataCollection/data
+
+ let $date := xs:date(fn:substring(xs:string(fn:data($r/date)), 0, 11))
+ where $r/dataType eq "TMIN"
+ and fn:year-from-date($date) eq 2001
+ return $r/value
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_station.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_station.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_station.xq
new file mode 100644
index 0000000..4349805
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q05_station.xq
@@ -0,0 +1,8 @@
+(: XQuery Join Aggregate Query :)
+(: Count all stations in the state of Oregon. :)
+count(
+ let $station_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+ for $s in collection($station_collection)/root/stationCollection/station
+ where (some $x in $s/locationLabels satisfies ($x/type eq "ST" and fn:upper-case(fn:data($x/displayName)) eq "OREGON"))
+ return $s
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06.xq
new file mode 100644
index 0000000..7be7c69
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06.xq
@@ -0,0 +1,13 @@
+(: XQuery Join Query :)
+(: Find the highest recorded temperature (TMAX) for each station for each :)
+(: day over the year 2000. :)
+let $station_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+for $s in collection($station_collection)/root/stationCollection/station
+
+let $sensor_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+for $r in collection($sensor_collection)/root/dataCollection/data
+
+where $s/id eq $r/station
+ and $r/dataType eq "TMAX"
+ and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2000
+return ($s/displayName, $r/date, $r/value)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_sensor.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_sensor.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_sensor.xq
new file mode 100644
index 0000000..5ca3329
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_sensor.xq
@@ -0,0 +1,8 @@
+count(
+ let $sensor_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($sensor_collection)/root/dataCollection/data
+
+ where $r/dataType eq "TMAX"
+ and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2000
+ return $r
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_station.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_station.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_station.xq
new file mode 100644
index 0000000..ef1e732
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q06_station.xq
@@ -0,0 +1,5 @@
+count(
+ let $station_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+ for $s in collection($station_collection)/root/stationCollection/station
+ return $s
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07.xq
new file mode 100644
index 0000000..35e5ea2
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07.xq
@@ -0,0 +1,15 @@
+(: XQuery Join Aggregate Query :)
+(: Self join with all sensor readings after the year 2000. :)
+fn:avg(
+let $sensor_collection_min := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+for $r_min in collection($sensor_collection_min)/root/dataCollection/data
+
+let $sensor_collection_max := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+for $r_max in collection($sensor_collection_max)/root/dataCollection/data
+
+where $r_min/station eq $r_max/station
+ and $r_min/date eq $r_max/date
+ and $r_min/dataType eq "TMIN"
+ and $r_max/dataType eq "TMAX"
+return ($r_max/value - $r_min/value)
+) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmax.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmax.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmax.xq
new file mode 100644
index 0000000..3245746
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmax.xq
@@ -0,0 +1,9 @@
+(: XQuery Join Query :)
+(: Find the all the records for TMAX. :)
+count(
+ let $sensor_collection_max := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r_max in collection($sensor_collection_max)/root/dataCollection/data
+
+ where $r_max/dataType eq "TMAX"
+ return $r_max
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmin.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmin.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmin.xq
new file mode 100644
index 0000000..6fcd276
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/q07_tmin.xq
@@ -0,0 +1,9 @@
+(: XQuery Join Query :)
+(: Find the all the records for TMIN. :)
+count(
+ let $sensor_collection_min := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r_min in collection($sensor_collection_min)/root/dataCollection/data
+
+ where $r_min/dataType eq "TMIN"
+ return $r_min
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/sensor_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/sensor_count.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/sensor_count.xq
new file mode 100644
index 0000000..1e8e312
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/sensor_count.xq
@@ -0,0 +1,7 @@
+(: XQuery Join Query :)
+(: Count all the weather sensor readings available. :)
+count(
+ let $sensor_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/sensors/?select=*.xml;recurse=yes"
+ for $r in collection($sensor_collection)/root/dataCollection/data
+ return $r
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/station_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/station_count.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/station_count.xq
new file mode 100644
index 0000000..fe6ec8f
--- /dev/null
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/saxon/station_count.xq
@@ -0,0 +1,7 @@
+(: XQuery Join Query :)
+(: Count all the weather stations available. :)
+count(
+ let $station_collection := "../../../../../../../weather_data/dataset-tiny-local/data_links/local_speed_up/d0_p1_i0/stations/?select=*.xml;recurse=yes"
+ for $s in collection($station_collection)/root/stationCollection/station
+ return $s
+)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q00.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q00.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q00.xq
index 743f95a..5006a21 100644
--- a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q00.xq
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q00.xq
@@ -14,14 +14,17 @@
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License. :)
-
-(: XQuery Filter Query :)
-(: See historical data for Riverside, CA (ASN00008113) station by selecting :)
-(: the weather readings for December 25 over the last 10 years. :)
+(:
+XQuery Filter Query
+-------------------
+See historical data for Key West International Airport, FL (USW00012836)
+station by selecting the weather readings for December 25 over the last
+10 years.
+:)
let $collection := "/tmp/1.0_partition_ghcnd_all_xml/sensors"
for $r in collection($collection)/dataCollection/data
let $datetime := xs:dateTime(fn:data($r/date))
-where $r/station eq "GHCND:ASN00008113"
+where $r/station eq "GHCND:USW00012836"
and fn:year-from-dateTime($datetime) ge 2003
and fn:month-from-dateTime($datetime) eq 12
and fn:day-from-dateTime($datetime) eq 25
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/fee9582a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q02.xq
----------------------------------------------------------------------
diff --git a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q02.xq b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q02.xq
index cbe72da..0635618 100644
--- a/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q02.xq
+++ b/vxquery-benchmark/src/main/resources/noaa-ghcn-daily/queries/q02.xq
@@ -14,14 +14,16 @@
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License. :)
-
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (USW00024233) for 1999. :)
+(:
+XQuery Aggregate Query
+----------------------
+Find the annual precipitation (PRCP) for a Syracuse, NY using the airport
+weather station (USW00014771) report for 1999.
+:)
fn:sum(
let $collection := "/tmp/1.0_partition_ghcnd_all_xml/sensors"
for $r in collection($collection)/dataCollection/data
- where $r/station eq "GHCND:USW00024233"
+ where $r/station eq "GHCND:USW00014771"
and $r/dataType eq "PRCP"
and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 1999
return $r/value