{"id":"W4390679439","doi":"10.1109/aike59827.2023.00030","title":"A Hybrid Cost Model for Evaluating Query Execution Plans","year":2023,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Ottawa","funders":"University of Ottawa","keywords":"Computer science; Query optimization; Sargable; Query plan; Online aggregation; Query expansion; Cardinality (data modeling); Web query classification; Relational database; Execution time; RDF query language; Cost estimate; Plan (archaeology); Web search query; Data mining; Query language; View; Search engine; Database; Information retrieval; Distributed computing; Database design","routes":{"ca_aff":true,"ca_fund":true,"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.0004157892,0.00007399655,0.00009179215,0.00005709969,0.0001478792,0.00003323436,0.0001664132,0.00001487526,0.000002528945],"category_scores_gemma":[0.00007933833,0.00006297844,0.00003722914,0.000138859,0.00001209124,0.000539007,0.0001271692,0.00003325483,0.00005908055],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002350773,"about_ca_system_score_gemma":0.00005948194,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00002623247,"about_ca_topic_score_gemma":0.00003155736,"domain_scores_codex":[0.9991987,0.00001684586,0.0001552953,0.000251865,0.0001594363,0.0002178871],"domain_scores_gemma":[0.9994334,0.0001023394,0.00004452113,0.0003130784,0.00006313543,0.00004350034],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00001216219,0.0000146993,0.00002823142,0.00005359647,0.000009657158,0.00000611767,0.0006057392,0.0789091,0.003530599,0.8485031,0.02492618,0.04340081],"study_design_scores_gemma":[0.0001661528,0.00002509376,0.00001733218,0.00001648718,0.000001479926,0.000004181467,0.00005628569,0.9870889,0.001077048,0.004608459,0.006846049,0.00009249626],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.003845769,0.00000905643,0.994092,0.0002735557,0.0002568229,0.0003447103,0.0001025735,0.0004434444,0.0006320162],"genre_scores_gemma":[0.1796035,0.00001337182,0.8113206,0.0004432963,0.0001296594,0.0005273579,0.0001961177,0.00001903542,0.007747003],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9081798,"threshold_uncertainty_score":0.2568186,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.099629376899836,"score_gpt":0.3551715906951283,"score_spread":0.2555422137952923,"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."}}