{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.004323212,0.001490778,0.001265898,0.0008444513,0.001580771,0.003477313,0.004424745,0.002227865,0.02220848],"category_scores_gemma":[0.01240208,0.0008925399,0.001361113,0.001608568,0.002109785,0.006460949,0.002889561,0.001518047,0.01426328],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009414514,"about_ca_system_score_gemma":0.002056062,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004255423,"about_ca_topic_score_gemma":0.003451691,"domain_scores_codex":[0.9942065,0.00107868,0.0004429836,0.001408479,0.002097246,0.0007661052],"domain_scores_gemma":[0.9930682,0.002199048,0.0004855002,0.003095561,0.0009693917,0.0001822455],"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.00143944,0.000622759,0.005887306,0.001151202,0.0002113267,0.001316568,0.001517862,0.02085313,0.0388617,0.2333695,0.2219472,0.472822],"study_design_scores_gemma":[0.0003476599,0.0005223786,0.002405944,0.0001945234,0.0001429344,0.002557281,0.0005900244,0.3619076,0.09024727,0.2445456,0.296276,0.0002628835],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.007537669,0.000171207,0.9462899,0.0009275936,0.0001382865,0.0007873266,0.001424768,0.03136032,0.01136296],"genre_scores_gemma":[0.1138015,0.000302005,0.8691029,0.0009466696,0.0001084756,0.0003171862,0.00460167,0.003523099,0.007296463],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.02220848,"threshold_uncertainty_score":0.07429475,"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."}}