{"id":"W4411141648","doi":"10.1145/3725241","title":"Output-Optimal Algorithms for Join-Aggregate Queries","year":2025,"lang":"en","type":"article","venue":"Proceedings of the ACM on Management of Data","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Join (topology); Aggregate (composite); Computer science; Algorithm; Theoretical computer science; 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.003603997,0.001711749,0.001780588,0.001483787,0.001346087,0.005278497,0.003008788,0.001668148,0.009325603],"category_scores_gemma":[0.01365406,0.0008835681,0.001980558,0.003356733,0.001483186,0.01081165,0.005173522,0.002788544,0.003959262],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.002497193,"about_ca_system_score_gemma":0.002292391,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001804854,"about_ca_topic_score_gemma":0.002181964,"domain_scores_codex":[0.991699,0.001227083,0.0009802621,0.001777707,0.003043319,0.001272578],"domain_scores_gemma":[0.9901032,0.004178574,0.0006068093,0.003560973,0.001230023,0.000320424],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.004086814,0.0009916375,0.004244715,0.001530201,0.000262033,0.0002267126,0.001603623,0.1192017,0.04411084,0.2754199,0.03317313,0.5151488],"study_design_scores_gemma":[0.0003238949,0.000363624,0.000888912,0.00008822438,0.0001343487,0.0003425855,0.0004074856,0.5841764,0.03246497,0.3637544,0.01697115,0.00008406988],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.04153471,0.001066912,0.9352366,0.0005878003,0.0001148361,0.0002255035,0.001093003,0.009313324,0.0108273],"genre_scores_gemma":[0.3614436,0.0007742166,0.6211678,0.000658564,0.0003264076,0.0005413918,0.004926794,0.00230897,0.007852244],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.009325603,"threshold_uncertainty_score":0.03119719,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.06301675797609008,"score_gpt":0.3193127812564128,"score_spread":0.2562960232803227,"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."}}