{"id":"W2150774720","doi":"10.1145/1142351.1142369","title":"On redundancy vs dependency preservation in normalization","year":2006,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":18,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto","funders":"","keywords":"Redundancy (engineering); Computer science; Functional dependency; Dependency (UML); Normalization (sociology); Theoretical computer science; Data integrity; Data mining; Relational database; Artificial intelligence; 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.0001037676,0.00006044202,0.00006250046,0.00007920335,0.00004306608,0.00002780002,0.0001419499,0.00002487245,0.00001967598],"category_scores_gemma":[0.000027732,0.00005231336,0.00001208869,0.0002768993,0.000006288919,0.00141962,0.00005463817,0.00003839174,0.00003419288],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002806732,"about_ca_system_score_gemma":0.00001884471,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0009724722,"about_ca_topic_score_gemma":0.001110997,"domain_scores_codex":[0.999336,0.00002620723,0.0001756796,0.0001857709,0.0001530003,0.0001233122],"domain_scores_gemma":[0.9995953,0.00002879299,0.00004574352,0.0002818843,0.00003306311,0.00001516121],"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.000003398948,0.00002591146,0.002983403,0.000007785369,3.281524e-7,0.000003530026,0.0000294195,0.002133876,0.0001162506,0.9920685,0.0008060316,0.001821615],"study_design_scores_gemma":[0.001998296,0.0003636973,0.2000876,0.0003368765,0.000002873967,0.00002595355,0.00004845632,0.3602295,0.01875587,0.3162825,0.1008879,0.0009805314],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.02049324,0.00002322615,0.9545489,0.0002617587,0.000135886,0.0001070476,0.000001583816,0.00009367102,0.02433467],"genre_scores_gemma":[0.9174821,0.000005306275,0.07751576,0.0002293092,0.00006334337,0.00002496149,0.00003628733,0.000006083656,0.004636814],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.8969889,"threshold_uncertainty_score":0.2133277,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.006379026253693026,"score_gpt":0.2189514351828395,"score_spread":0.2125724089291465,"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."}}