Confirm (k=7)

installxtraavg_timestddev_time
yes00.36800.0224
yes1002.03040.0289
yes2003.87840.0428
yes3005.81440.0601
yes4008.07600.0458
yes50010.64320.1488
no00.33200.0258
no1001.53680.0298
no2002.92400.0490
no3004.36480.0989
no4005.87200.0787
no5007.50400.1641
nil00.24080.0297
nil1000.24720.0215
nil2000.24320.0189
nil3000.24400.0173
nil4000.24320.0275
nil5000.24560.0242
download as csv
SELECT d_install AS install, d_xtra AS xtra, AVG(1000*d_time/(d_decisions/2)) AS avg_time, STDDEV_SAMP(1000*d_time/(d_decisions/2)) AS stddev_time
FROM exp_data_7
WHERE d_install IN ('yes','no','nil') AND d_k = 7
GROUP BY d_install, d_xtra
ORDER BY d_install DESC, d_xtra ASC
qryavg_timestddev_time
0.00020.20120.0023
0.14290.20120.0030
0.16670.19920.0027
0.20000.19800.0024
0.25000.20000.0024
0.33330.20080.0058
0.50000.20000.0014
download as csv
SELECT 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_7
WHERE d_install IN ('sel') AND d_k = 7 AND d_xtra = 0
GROUP BY qry
ORDER BY qry ASC
  • Five trials for each setting
  • Five randomly chosen ids queried
  • 500 queries per id (children), 5000 queries per attribute (selectivity)
  • install: "yes"=retrieve + activate + add to wm, "no"=retrieve + activate, "nil"=retrieve