{"id":"W1540277706","doi":"10.1109/icde.1994.283001","title":"Performing group-by before join [query processing]","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":18,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Joins; Computer science; SQL; Null (SQL); Group (periodic table); Semantics (computer science); Join (topology); Query optimization; Transformation (genetics); Theoretical computer science; Database; Information retrieval; Programming language; Mathematics; Combinatorics","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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001081301,0.0001206555,0.0001253259,0.00004277244,0.0002022088,0.00007422051,0.0002774662,0.00003571651,0.0001187321],"category_scores_gemma":[0.00001438073,0.00009160013,0.00003266835,0.0002164151,0.00003459066,0.001679187,0.0001585832,0.00008741899,0.0001273326],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002325903,"about_ca_system_score_gemma":0.000008161958,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003184253,"about_ca_topic_score_gemma":0.00003006294,"domain_scores_codex":[0.999035,0.00001388186,0.0001874716,0.0003012618,0.0001949575,0.0002674351],"domain_scores_gemma":[0.9994429,0.00001164502,0.00006129711,0.0003683416,0.00003560117,0.00008021617],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.000001311918,0.00008542827,0.0007303022,0.00009099655,0.000006899408,0.00002118676,0.001443348,0.000006384297,0.001342501,0.1905396,0.03447052,0.7712616],"study_design_scores_gemma":[0.00035508,0.000157476,0.0002298097,0.00009659278,0.000003208348,0.0001144625,0.0002233303,0.1530101,0.00232273,0.0009736744,0.8420612,0.0004524157],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.003798907,0.0006592677,0.9807452,0.0005832845,0.0001469183,0.00009347047,0.000005060248,0.0003094323,0.01365846],"genre_scores_gemma":[0.595758,0.000043984,0.3835318,0.0009756785,0.0002125604,0.00004443726,0.00001609306,0.00002402488,0.01939337],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.8075906,"threshold_uncertainty_score":0.3735345,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01338241844144647,"score_gpt":0.2147243309469355,"score_spread":0.2013419125054891,"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."}}