{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003406235,0.001567906,0.001325912,0.002183297,0.000478666,0.002332756,0.00275206,0.001349641,0.0024502],"category_scores_gemma":[0.0129159,0.0006265786,0.0009462404,0.00213474,0.0007666759,0.003686,0.001134341,0.001444886,0.000414403],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.003503294,"about_ca_system_score_gemma":0.002793465,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.01380837,"about_ca_topic_score_gemma":0.01461445,"domain_scores_codex":[0.9958883,0.001172093,0.0002953757,0.0006017658,0.001762625,0.0002799157],"domain_scores_gemma":[0.9930924,0.00412446,0.0006624919,0.0006908345,0.001241206,0.000188687],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0002215967,0.0001398504,0.002382991,0.0001183548,0.000078784,0.00005656051,0.00004333837,0.9130551,0.001922887,0.01110124,0.002087474,0.06879182],"study_design_scores_gemma":[0.000006430632,0.00003492001,0.000172301,0.000004407423,0.000009821145,0.00001517723,0.000004795619,0.9968566,0.0003433873,0.002309568,0.0002367885,0.000005768941],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.0366696,0.0006310879,0.9566843,0.00065963,0.00004614462,0.0002564872,0.000686329,0.001731267,0.002635158],"genre_scores_gemma":[0.6338449,0.0004187832,0.3609036,0.0002331866,0.00008322735,0.0005866247,0.001236864,0.0002670312,0.002425815],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01380837,"threshold_uncertainty_score":0.02745599,"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."}}