{"id":"W4389611627","doi":"10.1145/3626750","title":"Rethink Query Optimization in HTAP Databases","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":4,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"","keywords":"Computer science; Online analytical processing; Online transaction processing; Database; Schedule; Isolation (microbiology); Parallel computing; Database transaction; Transaction processing; Data warehouse; Operating system","routes":{"ca_aff":false,"ca_fund":false,"ca_venue":false,"about_ca":true,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001903186,0.001018267,0.0005647843,0.0004420497,0.0006665493,0.002014514,0.00188619,0.0006810611,0.0008921293],"category_scores_gemma":[0.00313869,0.0005935167,0.0007143142,0.0009996183,0.001184802,0.002845692,0.001481822,0.001609954,0.0002895877],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00109433,"about_ca_system_score_gemma":0.001637753,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.007183782,"about_ca_topic_score_gemma":0.009549847,"domain_scores_codex":[0.9977642,0.0005690016,0.0001711701,0.0003724082,0.0008748528,0.0002483763],"domain_scores_gemma":[0.9982565,0.0007570561,0.0001485207,0.000515947,0.000241733,0.00008024688],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"not_applicable","study_design_scores_codex":[0.001603151,0.0005429073,0.01616252,0.0004601394,0.0003444317,0.0005720763,0.001305523,0.4459093,0.1500756,0.02453426,0.01126261,0.3472274],"study_design_scores_gemma":[0.00008435783,0.0002820017,0.0026703,0.0000189825,0.00008517593,0.0001797192,0.0003435395,0.9275171,0.0505226,0.01153078,0.006723115,0.00004241042],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.4720565,0.003075907,0.4992596,0.001585273,0.0001517183,0.000296648,0.0006037639,0.01379587,0.009174848],"genre_scores_gemma":[0.7739594,0.0004374286,0.2218969,0.0003682889,0.00005826372,0.0000875105,0.0004923144,0.0008221208,0.001877792],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.007183782,"threshold_uncertainty_score":0.01428396,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.09719269435293139,"score_gpt":0.3220787802633234,"score_spread":0.224886085910392,"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."}}