{"id":"W2057545667","doi":"10.1145/1508857.1508858","title":"The design of a query monitoring system","year":2009,"lang":"en","type":"article","venue":"ACM Transactions on Database Systems","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":169,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto","funders":"","keywords":"Computer science; Query optimization; Online aggregation; Joins; Query expansion; Sargable; Query plan; View; Data mining; Database; Query language; Cardinality (data modeling); Web query classification; Information retrieval; Web search query; Search engine; Database design","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.005352603,0.0007736016,0.001387581,0.001132105,0.001589407,0.004318254,0.003957888,0.002091341,0.003382208],"category_scores_gemma":[0.009265824,0.001312127,0.0006248969,0.001075928,0.001210797,0.004988434,0.002686638,0.002340015,0.002229899],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009907882,"about_ca_system_score_gemma":0.002512266,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001967019,"about_ca_topic_score_gemma":0.0009435122,"domain_scores_codex":[0.9951591,0.0007941028,0.0006581429,0.00137164,0.001706362,0.0003105866],"domain_scores_gemma":[0.9947228,0.001522095,0.0004387884,0.001066183,0.001734793,0.0005153705],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.003433106,0.001505417,0.0204144,0.001449778,0.0004314356,0.001791768,0.002955761,0.07104931,0.2389501,0.1010524,0.03948348,0.5174831],"study_design_scores_gemma":[0.0002840129,0.0008010718,0.002684423,0.0001041443,0.0002567926,0.001186645,0.0002963297,0.8149929,0.09537934,0.01474604,0.06909358,0.0001748126],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.01072415,0.0002215657,0.9742353,0.0004908641,0.00009500238,0.0007574908,0.0001228673,0.01199624,0.001356462],"genre_scores_gemma":[0.2183189,0.0003086808,0.7740512,0.0006478538,0.00023564,0.001181473,0.0005507702,0.0007732977,0.003932154],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.005352603,"threshold_uncertainty_score":0.02830762,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03427797394678277,"score_gpt":0.266917922125267,"score_spread":0.2326399481784843,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}