{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.000155445,0.0001203281,0.00009314609,0.0001121289,0.0001532089,0.000202471,0.0004405674,0.00001598053,0.00003897072],"category_scores_gemma":[0.00001997045,0.0001071681,0.00003353303,0.0002575467,0.00002517178,0.002051878,0.0002155714,0.00007038847,0.00004512527],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002113263,"about_ca_system_score_gemma":0.000009821552,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003580684,"about_ca_topic_score_gemma":0.000008420795,"domain_scores_codex":[0.9989944,0.00001984869,0.0001586155,0.000342598,0.0002629304,0.0002215858],"domain_scores_gemma":[0.9994177,0.0000406088,0.00005594625,0.000417585,0.00001785912,0.00005032107],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00001474214,0.0001067047,0.00055998,0.000006763295,0.00001592109,0.00006006383,0.00009328124,0.0003904505,0.0007436996,0.8416933,0.003829496,0.1524856],"study_design_scores_gemma":[0.0009850038,0.0004665244,0.04301605,0.000197596,0.0000230933,0.00003104026,0.00008646005,0.7618172,0.003175412,0.0066322,0.1825396,0.001029833],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.03617609,0.00006155495,0.9511196,0.00165108,0.0003277982,0.0001005689,0.00001092305,0.000274188,0.01027821],"genre_scores_gemma":[0.2166516,0.00002900237,0.7795288,0.002175501,0.0002244648,0.000002333522,0.00008698647,0.000008639764,0.001292734],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.8350611,"threshold_uncertainty_score":0.437019,"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."}}