Boundaries (k=7)

xtrathreshavg_timestddev_time
000.25600.0238
01000.32960.0239
02000.33760.0273
03000.33120.0265
04000.32880.0252
05000.33840.0264
01,0000.35360.0256
10000.25360.0214
1001000.25440.0212
1002001.52880.0259
1003001.52960.0193
1004001.54720.0223
1005001.53680.0214
1001,0001.81280.0270
20000.25200.0245
2001000.25680.0243
2002000.25040.0246
2003002.94320.0632
2004002.95200.0545
2005002.88800.0306
2001,0003.36800.0990
30000.25600.0252
3001000.26320.0214
3002000.25760.0240
3003000.26000.0231
3004005.04800.0933
3005005.02960.0666
3001,0005.03680.0814
40000.26560.0255
4001000.26720.0215
4002000.25680.0269
4003000.26400.0265
4004000.24880.0239
4005006.89600.0963
4001,0006.92240.1316
50000.25680.0180
5001000.26080.0274
5002000.26160.0199
5003000.26480.0185
5004000.25440.0268
5005000.26080.0268
5001,0008.78960.2623
download as csv
SELECT d_xtra AS xtra, d_thresh AS thresh, AVG(1000*d_time/(d_decisions/2)) AS avg_time, STDDEV_SAMP(1000*d_time/(d_decisions/2)) AS stddev_time
FROM exp_data_8
WHERE d_install = 'no' AND d_k = 7
GROUP BY d_xtra, d_thresh
ORDER BY d_xtra ASC, d_thresh ASC
threshqryavg_timestddev_time
00.00020.20280.0023
00.14292.61200.0224
00.16673.00520.0279
00.20003.57680.0217
00.25004.38320.0406
00.33335.78640.0632
00.50008.54840.0548
1000.00020.20840.0055
1000.14290.20400.0028
1000.16670.20680.0023
1000.20000.20640.0017
1000.25000.20720.0011
1000.33330.20520.0011
1000.50000.20720.0018
download as csv
SELECT d_thresh AS thresh, IF(d_qry=1,1/5040,1/d_qry) AS qry, AVG(1000*d_time/(d_decisions/2)) AS avg_time, STDDEV_SAMP(1000*d_time/(d_decisions/2)) AS stddev_time
FROM exp_data_8
WHERE d_install IN ('sel') AND d_k = 7 AND d_xtra = 0
GROUP BY d_thresh, d_qry
ORDER BY d_thresh ASC, qry ASC
  • Five trials for each setting
  • 5000 queries per attribute (selectivity)
  • install: "yes"=retrieve + activate + add to wm, "no"=retrieve + activate, "nil"=retrieve