{"id":"W1486998273","doi":"10.1109/icdew.2015.7129584","title":"Improving the quality of large-scale database-centric software systems by analyzing database access code","year":2015,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":10,"is_retracted":false,"has_abstract":true,"ca_institutions":"Queen's University","funders":"","keywords":"Computer science; Database; Database schema; SQL; View; Relational database management system; Database administrator; Database design; Database tuning; Database model; Relational database","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.002845015,0.0002350596,0.0004271702,0.00009744452,0.0002440762,0.0002241747,0.001707768,0.00005215892,0.00001072072],"category_scores_gemma":[0.0006131072,0.000155106,0.00007295398,0.0008397931,0.000084836,0.003338579,0.002038556,0.0001935194,0.0000161774],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00007555067,"about_ca_system_score_gemma":0.000205618,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004056024,"about_ca_topic_score_gemma":0.0004201299,"domain_scores_codex":[0.9969747,0.0003709679,0.0007807329,0.0006468439,0.0007233921,0.0005033392],"domain_scores_gemma":[0.9963003,0.0003758369,0.0005511434,0.002183297,0.0003443336,0.0002450279],"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.0002540714,0.001762574,0.1130522,0.004470677,0.0004412887,0.00009514381,0.005566012,0.004540139,0.02636918,0.4875539,0.3360926,0.01980221],"study_design_scores_gemma":[0.007098851,0.000284685,0.00178164,0.0009014796,0.0001494896,0.0001167109,0.01150152,0.5579832,0.03470702,0.0002524879,0.3819834,0.00323955],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.008360404,0.002068862,0.9856915,0.0001164684,0.0006163439,0.0004361325,0.002337954,0.0002182188,0.0001541487],"genre_scores_gemma":[0.6029165,0.0001657174,0.3914548,0.0008106992,0.0004956443,0.0002212585,0.001796707,0.00008986695,0.002048797],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.5945562,"threshold_uncertainty_score":0.632504,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.05885681904401319,"score_gpt":0.3361835446933748,"score_spread":0.2773267256493616,"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."}}