{"id":"W4380433188","doi":"10.1145/3588711","title":"dbET: Execution Time Distribution-based Plan Selection","year":2023,"lang":"en","type":"article","venue":"Proceedings of the ACM on Management of Data","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":8,"is_retracted":false,"has_abstract":true,"ca_institutions":"Huawei Technologies (Canada); University of Toronto; York University","funders":"","keywords":"Computer science; Query plan; Plan (archaeology); Complement (music); Selection (genetic algorithm); Execution time; Overhead (engineering); Query optimization; Database; Sargable; Distributed computing; Programming language; Information retrieval; Web search query; Search engine; Artificial intelligence","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.002191425,0.0009194135,0.0007175332,0.001338912,0.000364969,0.001218257,0.001518702,0.0005092492,0.00250589],"category_scores_gemma":[0.007232832,0.0003609835,0.0006459228,0.001309589,0.0005338353,0.001282688,0.001026577,0.000994251,0.000575365],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001070235,"about_ca_system_score_gemma":0.001936909,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003583151,"about_ca_topic_score_gemma":0.004992072,"domain_scores_codex":[0.9979256,0.000447716,0.0001201095,0.0003379941,0.001014279,0.0001542181],"domain_scores_gemma":[0.9966056,0.001815403,0.000288767,0.0005627452,0.0005788096,0.0001485873],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0007843677,0.0003600623,0.01017004,0.0003150172,0.0001689978,0.0001762109,0.0001820584,0.3799504,0.02244128,0.02387184,0.01845036,0.5431294],"study_design_scores_gemma":[0.00005490303,0.00009687094,0.0009474748,0.000009824093,0.00002137434,0.00008734859,0.00003084069,0.9794613,0.007938948,0.007705579,0.003625116,0.00002045042],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.02333282,0.000333321,0.9657782,0.0001843635,0.00004250998,0.0002542114,0.00079448,0.006588399,0.002691692],"genre_scores_gemma":[0.4175302,0.0002852889,0.5763616,0.0001757291,0.0000665745,0.0003549347,0.002413454,0.0009348546,0.001877265],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.003583151,"threshold_uncertainty_score":0.01158953,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04636754490894221,"score_gpt":0.2778059725457491,"score_spread":0.2314384276368069,"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."}}