{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0004808872,0.00009272507,0.0001175464,0.0000708477,0.0001026344,0.00002618614,0.002949895,0.00002159729,0.000004363941],"category_scores_gemma":[0.000131979,0.00006994965,0.00003079206,0.000824485,0.00003955194,0.0007406122,0.002874291,0.00005480977,0.00003409672],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002557509,"about_ca_system_score_gemma":0.000009967477,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.000009335869,"about_ca_topic_score_gemma":4.3189e-7,"domain_scores_codex":[0.9989184,0.000006029392,0.0002135479,0.0003226448,0.000388967,0.0001504806],"domain_scores_gemma":[0.9985195,0.00003049852,0.0002367508,0.001112383,0.00007921548,0.00002162658],"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.00009440284,0.0002245666,0.002641084,0.001400683,0.0001712189,0.00000165738,0.00009632921,0.0004190713,0.01204911,0.5911238,0.3689598,0.02281819],"study_design_scores_gemma":[0.002525915,0.0007186517,0.05291063,0.003007377,0.0002188604,0.000007184514,0.0006766396,0.3496422,0.1370789,0.02329834,0.4288169,0.001098371],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.2911014,0.0001580907,0.6475309,0.02962072,0.00220282,0.00500111,0.008321313,0.002611316,0.0134524],"genre_scores_gemma":[0.8320891,0.0001054698,0.1619623,0.0002130573,0.0001606364,0.00008336881,0.002408709,0.0000388918,0.002938434],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.5678255,"threshold_uncertainty_score":0.5481688,"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."}}