{"id":"W2088108067","doi":"10.1016/j.scico.2013.11.025","title":"Understanding database schema evolution: A case study","year":2013,"lang":"en","type":"article","venue":"Science of Computer Programming","topic":"Software Engineering Research","field":"Computer Science","cited_by":52,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Victoria","funders":"Japan Society for the Promotion of Science; Fonds De La Recherche Scientifique - FNRS","keywords":"Computer science; Database schema; Database; Reverse engineering; Schema (genetic algorithms); Database design; Schema migration; Database model; Information schema; Data science; Schema evolution; Software engineering; Information retrieval; Semi-structured model; Programming language","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.001585578,0.0001582576,0.0001816633,0.0005621893,0.0003874969,0.0007322726,0.001797575,0.00002740549,0.000008068068],"category_scores_gemma":[0.0002006523,0.0001467272,0.00004606568,0.0029577,0.0004109492,0.002423343,0.001406187,0.0001969751,0.00002902392],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0002882123,"about_ca_system_score_gemma":0.0002981006,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0003806414,"about_ca_topic_score_gemma":0.000006801385,"domain_scores_codex":[0.9972551,0.00005029252,0.0003022831,0.0006594056,0.001067968,0.0006649484],"domain_scores_gemma":[0.9979921,0.0002974975,0.00008845968,0.001025115,0.0003378957,0.0002589118],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.000009793599,0.003406389,0.1874629,0.0004789877,0.0001765258,0.006041367,0.02314084,0.006089306,0.008723734,0.1389348,0.001289145,0.6242462],"study_design_scores_gemma":[0.001229379,0.001295341,0.010982,0.0001880635,0.00001231565,0.003591808,0.004547121,0.9735157,0.00150837,0.002212652,0.0001061424,0.0008111332],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.3533309,0.00002310159,0.6455615,0.00006448749,0.0002866834,0.0004942178,1.853299e-7,0.0002222156,0.00001678707],"genre_scores_gemma":[0.6876149,1.821478e-7,0.3122846,0.000005684418,0.00004533875,0.00003731847,1.593676e-7,0.000006157088,0.000005692661],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.9674264,"threshold_uncertainty_score":0.7061322,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.08599344345401087,"score_gpt":0.3132914522561743,"score_spread":0.2272980088021634,"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."}}