{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003870698,0.0004069593,0.0003107073,0.001260825,0.001644427,0.00324134,0.002102868,0.003402842,0.002296136],"category_scores_gemma":[0.02465983,0.0004868298,0.0005201671,0.001792821,0.001303625,0.005426948,0.001817813,0.002181933,0.0003332435],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001675047,"about_ca_system_score_gemma":0.001505006,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.007293737,"about_ca_topic_score_gemma":0.01410731,"domain_scores_codex":[0.9972711,0.001325224,0.0001689479,0.0004135736,0.0006640574,0.000157057],"domain_scores_gemma":[0.9720416,0.02202084,0.001182037,0.00243518,0.001893338,0.0004270461],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"qualitative","study_design_scores_codex":[0.00107447,0.003639274,0.1217696,0.002066146,0.0002006457,0.02691948,0.1697217,0.03017208,0.0328131,0.07696737,0.01248437,0.5221718],"study_design_scores_gemma":[0.0003386107,0.001521778,0.05660826,0.001189691,0.0005790081,0.04219767,0.1506045,0.3823785,0.08896092,0.07943961,0.1958642,0.0003170922],"study_design_candidate":"qualitative","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.8877336,0.0007346077,0.09236269,0.00398237,0.00004850999,0.0003514585,0.0005608238,0.0006450215,0.01358093],"genre_scores_gemma":[0.9003116,0.0005092286,0.09400111,0.0003401381,0.00001749897,0.000064295,0.0005756981,0.0001721999,0.00400831],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.007293737,"threshold_uncertainty_score":0.02047044,"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."}}