{"id":"W4312121203","doi":"10.1109/rasse54974.2022.9989603","title":"DW vs OLTP Performance Optimization in the Cloud on PostgreSQL (A Case Study)","year":2022,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":5,"is_retracted":false,"has_abstract":true,"ca_institutions":"Langara College; Okanagan College","funders":"","keywords":"Online transaction processing; Computer science; Data warehouse; Database; Analytics; Cloud computing; Online analytical processing; Big data; Materialized view; Transaction processing; Database transaction; Data mining; Operating system; Database design; View","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.005259787,0.0008990695,0.0006734784,0.001049603,0.001035192,0.002358057,0.001945045,0.0009283411,0.001910798],"category_scores_gemma":[0.008624219,0.0004120494,0.0004957105,0.002888404,0.000853208,0.003002577,0.001145851,0.001097794,0.000838569],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.002651309,"about_ca_system_score_gemma":0.001733794,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.03190699,"about_ca_topic_score_gemma":0.01821752,"domain_scores_codex":[0.9940081,0.001135908,0.0004665186,0.0008953194,0.002416374,0.001077788],"domain_scores_gemma":[0.991299,0.003258663,0.0005534135,0.001402489,0.0027945,0.0006918886],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"observational","study_design_scores_codex":[0.0137369,0.006687931,0.06167326,0.001994306,0.000353698,0.004373627,0.003941048,0.3064132,0.1799891,0.01064444,0.05887258,0.3513199],"study_design_scores_gemma":[0.0008529674,0.003370676,0.04268043,0.00007425853,0.0001159619,0.0007498136,0.002950745,0.8103527,0.1215177,0.002633591,0.01453091,0.0001702402],"study_design_candidate":"observational","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9805287,0.0003962712,0.008039623,0.0006020568,0.00004484762,0.0001882965,0.0009623197,0.003799631,0.005438395],"genre_scores_gemma":[0.9766271,0.000161874,0.02016355,0.0001436354,0.00001649646,0.00005124613,0.001307918,0.0003207622,0.001207572],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.03190699,"threshold_uncertainty_score":0.06344253,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0186085355860389,"score_gpt":0.2535323287472063,"score_spread":0.2349237931611674,"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."}}