{"id":"W2026139222","doi":"10.1016/j.jcss.2006.10.014","title":"Dependency-preserving normalization of relational and XML data","year":2006,"lang":"en","type":"article","venue":"Journal of Computer and System Sciences","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":49,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Toronto","funders":"","keywords":"Computer science; Functional dependency; Relational database; Redundancy (engineering); XML; Data integrity; Normalization (sociology); Data redundancy; Dependency (UML); XML validation; Data mining; Theoretical computer science; Database; Artificial intelligence","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.001079871,0.00006923961,0.0001906955,0.0001384769,0.0001610802,0.00009328526,0.0005622995,0.00002268258,8.109567e-7],"category_scores_gemma":[0.00001544413,0.00004875486,0.00001846303,0.0002231278,0.00009741606,0.002433281,0.0004794996,0.00004770896,2.514853e-7],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.000007909529,"about_ca_system_score_gemma":0.00008039089,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00005892544,"about_ca_topic_score_gemma":0.00001414367,"domain_scores_codex":[0.9987364,0.00007543544,0.0004912089,0.0001780507,0.0004199904,0.00009885719],"domain_scores_gemma":[0.9989851,0.000122605,0.0004661678,0.0002321217,0.0001507653,0.00004327837],"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.000007561595,0.00002966191,0.03930382,0.0002569313,0.00001912079,0.0000258865,0.0004381986,0.005372042,0.0003620848,0.9432752,0.001044607,0.009864864],"study_design_scores_gemma":[0.0005355685,0.0002736411,0.04633092,0.0007083489,0.00001504429,0.001892093,0.0003900809,0.9427488,0.0001915079,0.002590078,0.004116673,0.0002072473],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.04122769,0.001626276,0.9560727,0.0001031488,0.0003626719,0.00004232113,0.000007200387,0.000008984121,0.0005489697],"genre_scores_gemma":[0.7588019,0.00002066418,0.2409769,0.000009260289,0.0001750776,2.001855e-7,0.000001593657,0.000001507515,0.00001290429],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9406852,"threshold_uncertainty_score":0.1988166,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03262459263909213,"score_gpt":0.2570799605490312,"score_spread":0.2244553679099391,"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."}}