Changeset: 038a15cf73c4 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=038a15cf73c4 Modified Files: sql/src/benchmarks/uva/c1.sql sql/src/benchmarks/uva/c2.sql sql/src/benchmarks/uva/c3.sql sql/src/benchmarks/uva/cees.txt sql/src/benchmarks/uva/cees/VxSegmentDoubleFeature_tab.txt sql/src/benchmarks/uva/cees/VxSegmentIntFeature_tab.txt sql/src/benchmarks/uva/cees/VxSegmentStringFeature_tab.txt sql/src/benchmarks/uva/cees/VxSegment_tab.txt sql/src/benchmarks/uva/cees/VxSegmentation_tab.txt sql/src/benchmarks/uva/cees/times sql/src/benchmarks/uva/count.sql sql/src/benchmarks/uva/drop.sql sql/src/benchmarks/uva/dump.sql sql/src/benchmarks/uva/j1.sql sql/src/benchmarks/uva/j2.sql sql/src/benchmarks/uva/j3.sql sql/src/benchmarks/uva/j4.sql sql/src/benchmarks/uva/journaal.txt sql/src/benchmarks/uva/journaal/VxSegmentDoubleFeature_tab.txt sql/src/benchmarks/uva/journaal/VxSegmentIntFeature_tab.txt sql/src/benchmarks/uva/journaal/VxSegmentStringFeature_tab.txt sql/src/benchmarks/uva/journaal/VxSegment_tab.txt sql/src/benchmarks/uva/journaal/VxSegmentation_tab.txt sql/src/benchmarks/uva/journaal/times sql/src/benchmarks/uva/load-cees.sql sql/src/benchmarks/uva/load-journaal.sql sql/src/benchmarks/uva/makeTables.sql sql/src/benchmarks/uva/run.all Branch: default Log Message:
Merge with Jun2010 branch. diffs (truncated from 145745 to 300 lines): diff -r 8bb68df6d269 -r 038a15cf73c4 sql/src/benchmarks/uva/c1.sql --- a/sql/src/benchmarks/uva/c1.sql Wed Jul 28 13:50:01 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,10 +0,0 @@ -SELECT DISTINCT segment0.id -FROM VxSegment_tab segment0, - VxSegmentation_tab segmentation0, - VxSegmentStringFeature_tab feat0_0 -WHERE (segment0.segmentationId = segmentation0.id) AND - (segmentation0.name = 'demo') AND - (feat0_0.segmentId = segment0.id) AND - (feat0_0.fieldName = 'team') AND - (feat0_0.value = 'Feyenoord'); - diff -r 8bb68df6d269 -r 038a15cf73c4 sql/src/benchmarks/uva/c2.sql --- a/sql/src/benchmarks/uva/c2.sql Wed Jul 28 13:50:01 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -SELECT DISTINCT segment0.id -FROM VxSegment_tab segment0, - VxSegmentation_tab segmentation0, - VxSegmentStringFeature_tab feat0_0, - VxSegmentStringFeature_tab feat0_1 -WHERE (segment0.segmentationId = segmentation0.id) AND - (segmentation0.name = 'demo') AND - (feat0_0.segmentId = segment0.id) AND - (feat0_0.fieldName = 'team') AND - (feat0_0.value = 'Lazio Roma') AND - (feat0_1.segmentId = segment0.id) AND - (feat0_1.fieldName = 'type') AND - (feat0_1.value = 'Yellow'); - diff -r 8bb68df6d269 -r 038a15cf73c4 sql/src/benchmarks/uva/c3.sql --- a/sql/src/benchmarks/uva/c3.sql Wed Jul 28 13:50:01 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,9 +0,0 @@ -SELECT DISTINCT segment0.id -FROM VxSegment_tab segment0, - VxSegmentation_tab segmentation0, - VxSegmentStringFeature_tab feat0_0 -WHERE (segment0.segmentationId = segmentation0.id) AND - (segmentation0.name = 'demo') AND - (feat0_0.segmentId = segment0.id) AND - (feat0_0.fieldName = 'type') AND - (feat0_0.value = 'Goal'); diff -r 8bb68df6d269 -r 038a15cf73c4 sql/src/benchmarks/uva/cees.txt --- a/sql/src/benchmarks/uva/cees.txt Wed Jul 28 13:50:01 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,28 +0,0 @@ -sqlplus cees/c...@csys - - -SQL> @c1 - - ID ----------- - 20701 - 20703 - 20704 - - -SQL> @c2 - - ID ----------- - 20711 - - -SQL> @c3 - - ID ----------- - 20701 - 20702 - 20705 - 20709 - diff -r 8bb68df6d269 -r 038a15cf73c4 sql/src/benchmarks/uva/cees/VxSegmentDoubleFeature_tab.txt --- a/sql/src/benchmarks/uva/cees/VxSegmentDoubleFeature_tab.txt Wed Jul 28 13:50:01 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,7610 +0,0 @@ - 1877,belief , .106383 - 1878,belief , .182927 - 1879,belief , .106383 - 1880,belief , .0666667 - 1881,belief , .0238095 - 1882,belief , .125 - 1883,belief , .272727 - 1884,belief , .486111 - 1885,belief , .0769231 - 1886,belief , .0952381 - 1887,belief , .666667 - 1888,belief , .315789 - 1889,belief , .605263 - 1890,belief , .0952381 - 1891,belief , .263158 - 1892,belief , .0967742 - 1893,belief , .538462 - 1894,belief , .137931 - 1895,belief , .210526 - 1896,belief , .125 - 1897,belief , .0392157 - 1898,belief , .0588235 - 1899,belief , .986945 - 1900,belief , .0224719 - 1901,belief , .205357 - 1902,belief , .0792079 - 1903,belief , 1 - 1904,belief , 1 - 1905,belief , 1 - 1906,belief , 1 - 1907,belief , .99322 - 1908,belief , .677596 - 1909,belief , .985294 - 1910,belief , .0888889 - 1911,belief , .264368 - 1912,belief , .113636 - 1913,belief , .824519 - 1914,belief , .0152284 - 1915,belief , .718973 - 1916,belief , .0377358 - 1917,belief , .963178 - 1918,belief , .371429 - 1919,belief , .2375 - 1920,belief , .18 - 1921,belief , .28 - 1922,belief , .105556 - 1923,belief , .283582 - 1924,belief , .777778 - 1925,belief , .0321285 - 1926,belief , .997238 - 1927,belief , .0392157 - 1928,belief , .015674 - 1929,belief , .0487805 - 1930,belief , .0277778 - 1931,belief , .06 - 1932,belief , .025 - 1933,belief , .0106952 - 1934,belief , .00591716 - 1935,belief , .0190476 - 1936,belief , .0266667 - 1937,belief , .1 - 1938,belief , .035461 - 1939,belief , .00980392 - 1940,belief , .04 - 1941,belief , .043956 - 1942,belief , .0444444 - 1943,belief , .00900901 - 1944,belief , .0348837 - 1945,belief , .0285714 - 1946,belief , .951715 - 1947,belief , .0267857 - 1948,belief , .925 - 1949,belief , .415385 - 1950,belief , .029703 - 1951,belief , .0663265 - 1952,belief , .284091 - 1953,belief , .371429 - 1954,belief , .111111 - 1955,belief , .0222222 - 1956,belief , .189873 - 1957,belief , .00397878 - 1958,belief , .195122 - 1959,belief , .666667 - 1960,belief , .227273 - 1961,belief , .678571 - 1962,belief , .128205 - 1963,belief , .290323 - 1964,belief , .875 - 1965,belief , .277778 - 1966,belief , .484375 - 1967,belief , .87234 - 1968,belief , .909091 - 1969,belief , .25 - 1970,belief , .4 - 1971,belief , .08 - 1972,belief , .162162 - 1973,belief , .194631 - 1974,belief , .142857 - 1975,belief , .933333 - 1976,belief , .8 - 1977,belief , .0972222 - 1978,belief , .192308 - 1979,belief , .117647 - 1980,belief , .73913 - 1981,belief , .5 - 1982,belief , .0434783 - 1983,belief , .12 - 1984,belief , .0909091 - 1985,belief , .642857 - 1986,belief , .0487805 - 1987,belief , .0555556 - 1988,belief , .636364 - 1989,belief , .454545 - 1990,belief , .0943396 - 1991,belief , .372549 - 1992,belief , .0645161 - 1993,belief , .564103 - 1994,belief , .0413223 - 1995,belief , .121212 - 1996,belief , .116279 - 1997,belief , .94012 - 1998,belief , .149254 - 1999,belief , .918919 - 2000,belief , .113208 - 2001,belief , .863572 - 2002,belief , .102339 - 2003,belief , .0841969 - 2004,belief , .145205 - 2005,belief , .0212121 - 2006,belief , .970284 - 2007,belief , .507692 - 2008,belief , .854563 - 2009,belief , .0127389 - 2010,belief , .839216 - 2011,belief , .0238095 - 2012,belief , .860465 - 2013,belief , .125 - 2014,belief , .0727273 - 2015,belief , .440678 - 2016,belief , .0225564 - 2017,belief , .111111 - 2018,belief , .0523256 - 2019,belief , .0196078 - 2020,belief , .0930233 - 2021,belief , .038961 - 2022,belief , .047619 - 2023,belief , .5625 - 2024,belief , .912409 - 2025,belief , .00877193 - 2026,belief , .0625 - 2027,belief , .0168067 - 2028,belief , .0526316 - 2029,belief , .025641 - 2030,belief , .00420168 - 2031,belief , .55 - 2032,belief , .22 - 2033,belief , .0246305 - 2034,belief , .00673401 - 2035,belief , .0215054 - 2036,belief , .473214 - 2037,belief , .297619 - 2038,belief , .119048 - 2039,belief , .0157233 - 2040,belief , .666667 - 2041,belief , .398936 - 2042,belief , .469697 - 2043,belief , .241758 - 2044,belief , .526718 - 2045,belief , .046729 - 2046,belief , .010989 - 2047,belief , .0144231 - 2048,belief , .0540541 - 2049,belief , .0361446 - 2050,belief , .105263 - 2051,belief , .198198 - 2052,belief , .123288 - 2053,belief , .0526316 - 2054,belief , .0152439 - 2055,belief , .0392157 - 2056,belief , .031746 - 2057,belief , .004158 - 2058,belief , .00495663 - 2059,belief , .0243902 - 2060,belief , .132075 - 2061,belief , .0365854 - 2062,belief , .0220994 - 2063,belief , .176796 - 2064,belief , .151163 - 2065,belief , .294444 - 2066,belief , .00536913 - 2067,belief , .0444444 - 2068,belief , .0307692 - 2069,belief , .0689655 - 2070,belief , .0857143 - 2071,belief , .0222222 - 2072,belief , .222222 - 2073,belief , .0792079 - 2074,belief , .0224719 - 2075,belief , .00525394 - 2076,belief , .0408163 - 2077,belief , .0215054 - 2078,belief , .00959233 - 2079,belief , .0273973 - 2080,belief , .786667 - 2081,belief , .00628931 - 2082,belief , .025974 - 2083,belief , .0108992 - 2084,belief , .0163934 - 2085,belief , .00434783 - 2086,belief , .36 - 2087,belief , .0675676 - 2088,belief , .04 - 2089,belief , .0277778 - 2090,belief , .0183824 - 2091,belief , .120482 - 2092,belief , .416667 - 2093,belief , .00769231 - 2094,belief , .0108932 - 2095,belief , .0481928 _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
