{"id":"W2075657963","doi":"10.1145/1516360.1516374","title":"Answering aggregate keyword queries on relational databases using minimal group-bys","year":2009,"lang":"en","type":"article","venue":"","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":27,"is_retracted":false,"has_abstract":true,"ca_institutions":"Simon Fraser University","funders":"Natural Sciences and Engineering Research Council of Canada","keywords":"Computer science; Aggregate (composite); Tuple; Information retrieval; Set (abstract data type); Keyword search; Relational database; Matching (statistics); Table (database); Result set; Group (periodic table); Data mining; Database; Mathematics","routes":{"ca_aff":true,"ca_fund":true,"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.002785116,0.001213222,0.003957796,0.003760927,0.001318836,0.003262127,0.002179692,0.00139775,0.001994136],"category_scores_gemma":[0.01546806,0.000731883,0.001495587,0.006962728,0.001031597,0.008404763,0.003855578,0.0008747639,0.0009295191],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00101193,"about_ca_system_score_gemma":0.001529408,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003266779,"about_ca_topic_score_gemma":0.003768151,"domain_scores_codex":[0.9945294,0.001587904,0.0007197877,0.001113731,0.0016119,0.0004372293],"domain_scores_gemma":[0.9867871,0.008049082,0.001255513,0.002501206,0.001015367,0.0003916552],"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.002449302,0.0007428352,0.01331607,0.001665425,0.0004482889,0.001055265,0.004097003,0.2785411,0.03144528,0.0711978,0.01681077,0.5782309],"study_design_scores_gemma":[0.0001668394,0.0003505016,0.001176914,0.00006134982,0.0001348208,0.0006739576,0.001620176,0.8094094,0.01305048,0.1668251,0.006460984,0.00006953092],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.2358105,0.001971544,0.7526715,0.0007876709,0.00003865897,0.0004490839,0.002775782,0.002890851,0.002604434],"genre_scores_gemma":[0.5075557,0.0006464795,0.4856412,0.0001964727,0.0001066178,0.0003308759,0.004108429,0.0002011658,0.001213169],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.003957796,"threshold_uncertainty_score":0.01472926,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0592646243551924,"score_gpt":0.2794139593444094,"score_spread":0.220149334989217,"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."}}