{"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":"codex-gemma-dda1882f352a","candidate_categories":["open_science"],"consensus_categories":[],"category_scores_codex":[0.0008096583,0.0001012213,0.0001549509,0.0001664662,0.00005021185,0.00002262217,0.004826182,0.00001720264,0.000003567712],"category_scores_gemma":[0.0003575265,0.00007576714,0.00002277804,0.001044666,0.00004928618,0.001830742,0.01163511,0.00007737095,0.000007187504],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001599447,"about_ca_system_score_gemma":0.000009730887,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003221946,"about_ca_topic_score_gemma":0.000003088875,"domain_scores_codex":[0.9987118,0.000008441777,0.0003111599,0.0004074694,0.0003983291,0.0001628093],"domain_scores_gemma":[0.9974018,0.0000561603,0.0002567555,0.002208078,0.00005749312,0.00001969733],"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.00004405947,0.0001477842,0.003261318,0.001604824,0.00007629777,0.000006270806,0.0003481181,0.004942733,0.0007137644,0.9174091,0.05841587,0.01302991],"study_design_scores_gemma":[0.004786169,0.000508018,0.04471492,0.01296598,0.0002081791,0.00001506864,0.007825891,0.6116262,0.03376877,0.04731305,0.2341397,0.002128056],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.1463844,0.0008961977,0.7437927,0.0479673,0.003524072,0.007007379,0.003734073,0.001991202,0.04470275],"genre_scores_gemma":[0.04544917,0.0008376757,0.9524081,0.0001795569,0.00004733835,0.00003263148,0.0002749911,0.00002218349,0.0007483467],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.870096,"threshold_uncertainty_score":0.9963586,"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."}}