{"id":"W4392139269","doi":"10.1145/3649133","title":"Sharing Queries with Nonequivalent User-defined Aggregate Functions","year":2024,"lang":"en","type":"article","venue":"ACM Transactions on Database Systems","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Rewriting; Computer science; Aggregate (composite); Class (philosophy); Query language; Function (biology); Materialized view; Extension (predicate logic); Theoretical computer science; Database query; Reuse; Programming language; Information retrieval; Artificial intelligence; View","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":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.000339451,0.0004029423,0.0003626755,0.0004079307,0.0004947246,0.000514912,0.0008564417,0.00007569491,0.00005830354],"category_scores_gemma":[0.00003012173,0.000315906,0.0001249126,0.00107224,0.0001022232,0.002652616,0.00008316986,0.0004080884,0.0005402532],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0001607921,"about_ca_system_score_gemma":0.0001368613,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0009955425,"about_ca_topic_score_gemma":0.0003425584,"domain_scores_codex":[0.997222,0.00008591094,0.0005085885,0.001103855,0.0005621549,0.0005174787],"domain_scores_gemma":[0.9963498,0.0002446292,0.00009933066,0.002984535,0.0001012021,0.0002204941],"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.0002707918,0.0006107063,0.0001692359,0.003315804,0.001257241,0.00149072,0.002133451,0.04249815,0.00746313,0.890094,0.006339103,0.04435763],"study_design_scores_gemma":[0.0008613006,0.0005219868,0.00004554172,0.003799129,0.0001407849,0.001067528,0.001051944,0.04227437,0.004984148,0.0001667974,0.9438603,0.001226182],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.001703856,0.001452737,0.9894316,0.0005756618,0.002864486,0.0005531106,0.001475787,0.001372248,0.0005705667],"genre_scores_gemma":[0.8289388,0.000545865,0.146542,0.0001984185,0.0005924389,0.001536036,0.0006412209,0.0002028715,0.0208023],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9375212,"threshold_uncertainty_score":0.9999293,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02668953795672124,"score_gpt":0.2596981473377908,"score_spread":0.2330086093810696,"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."}}