{"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":"codex-gemma-dda1882f352a","candidate_categories":["open_science"],"consensus_categories":["open_science"],"category_scores_codex":[0.0005031657,0.0001463609,0.0002336233,0.0001032868,0.0001178371,0.00004983129,0.006193459,0.00002653428,0.000001254303],"category_scores_gemma":[0.0002293947,0.0001046877,0.00006367197,0.0003835075,0.00009949219,0.001154112,0.009896182,0.00006358676,0.000001781936],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0000165623,"about_ca_system_score_gemma":0.00001654714,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.000009419884,"about_ca_topic_score_gemma":7.257239e-7,"domain_scores_codex":[0.998679,0.000004279349,0.0003458807,0.0004705553,0.000296094,0.0002041412],"domain_scores_gemma":[0.9973451,0.00005625648,0.0003223393,0.002106699,0.0001467116,0.00002288911],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00004912926,0.00007954855,0.0001744099,0.001280002,0.0001659296,4.021793e-7,0.00008749847,0.00001738868,0.0004053953,0.8967305,0.04467313,0.0563367],"study_design_scores_gemma":[0.001782203,0.0003388328,0.00212524,0.002777494,0.0001916267,0.000002735941,0.001471658,0.01496538,0.051234,0.04273557,0.8818519,0.0005233643],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01069401,0.0006272769,0.9563394,0.0154056,0.001323699,0.002419717,0.001031681,0.0002283842,0.0119302],"genre_scores_gemma":[0.01449801,0.0001397737,0.9808981,0.0002164013,0.00004150148,0.00006177717,0.00003024368,0.00001196254,0.004102188],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.8539949,"threshold_uncertainty_score":0.9991835,"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."}}