{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0005228526,0.00008390466,0.0000846917,0.0000739593,0.0004015451,0.0000393782,0.0003919833,0.000008460702,0.00004886081],"category_scores_gemma":[0.00001245809,0.00005612544,0.00001697338,0.0004725296,0.00001287935,0.0003895181,0.0003169443,0.0001486468,0.000009567386],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00004175128,"about_ca_system_score_gemma":0.00002693682,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0003966545,"about_ca_topic_score_gemma":0.0001338919,"domain_scores_codex":[0.9989638,0.0001877934,0.0001684032,0.000241623,0.000288175,0.0001501968],"domain_scores_gemma":[0.9992708,0.00006935832,0.00005113202,0.0005687452,0.00001987122,0.00002008085],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00005253224,0.0006179267,0.004459043,0.00001466594,0.000009093113,0.003223375,0.01416265,0.8808163,0.000005498998,0.08586168,0.00192073,0.008856476],"study_design_scores_gemma":[0.001111938,0.002117399,0.001233408,0.00001395328,0.000004297206,0.003199264,0.02345162,0.9081526,0.00005393647,0.00003497655,0.06024411,0.0003825272],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.6433503,0.00004123593,0.3508522,0.0007353919,0.0006336978,0.0006971951,0.00001094204,0.0001090468,0.003569955],"genre_scores_gemma":[0.9872118,0.000004873553,0.0115815,0.0007464648,0.00004219665,0.00009875924,0.000004868496,0.000004841352,0.0003046486],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.3438616,"threshold_uncertainty_score":0.3088401,"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."}}