{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.007141,0.0006804311,0.001184103,0.002990279,0.001493602,0.003978079,0.002387656,0.0008087095,0.00593703],"category_scores_gemma":[0.02527484,0.00122002,0.001837694,0.005453716,0.001917613,0.007366195,0.003371988,0.002440989,0.003204097],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001699916,"about_ca_system_score_gemma":0.003905149,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004530326,"about_ca_topic_score_gemma":0.005452336,"domain_scores_codex":[0.990531,0.002043263,0.001164448,0.001558002,0.004160445,0.000542885],"domain_scores_gemma":[0.9745746,0.006723396,0.001518771,0.01169248,0.005151491,0.0003393168],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.0006406445,0.0002299715,0.005472884,0.0006976282,0.000251881,0.0007402862,0.001448564,0.02254817,0.0240075,0.4157905,0.04798186,0.48019],"study_design_scores_gemma":[0.00009259085,0.0001127573,0.004859464,0.0002391499,0.0004180523,0.001153223,0.0005579866,0.1579217,0.1540169,0.4796424,0.2008024,0.0001834471],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.02052053,0.0008829713,0.9537324,0.001143844,0.0005413071,0.0001651989,0.002656073,0.01105942,0.009298194],"genre_scores_gemma":[0.2393755,0.001761132,0.7151228,0.001195616,0.0007372643,0.0004354159,0.01044173,0.007620817,0.02330974],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.007141,"threshold_uncertainty_score":0.03776562,"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."}}