{"id":"W1998597078","doi":"10.1145/1670243.1670248","title":"An information-theoretic analysis of worst-case redundancy in database design","year":2008,"lang":"en","type":"article","venue":"ACM Transactions on Database Systems","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":25,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of British Columbia","funders":"Seventh Framework Programme; Engineering and Physical Sciences Research Council","keywords":"Computer science; Redundancy (engineering); Schema (genetic algorithms); Functional dependency; Database schema; Theoretical computer science; Data integrity; Relational database; Data mining; Database design; Information retrieval; 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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.01224363,0.001280755,0.001113995,0.003294484,0.0009495663,0.004377198,0.002695252,0.001421061,0.002386144],"category_scores_gemma":[0.05150817,0.001081934,0.001241537,0.00375176,0.005014334,0.01085169,0.001890431,0.002488062,0.0004928748],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.003522623,"about_ca_system_score_gemma":0.001565015,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0007024063,"about_ca_topic_score_gemma":0.000611911,"domain_scores_codex":[0.9830073,0.006897724,0.001115581,0.001404444,0.006760076,0.0008148199],"domain_scores_gemma":[0.9477338,0.03699489,0.003410354,0.007671615,0.003742899,0.0004464647],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.0001770875,0.00008537819,0.001147099,0.0003209697,0.00009803643,0.0001927236,0.0004042596,0.3119412,0.004790825,0.6201838,0.001471719,0.05918695],"study_design_scores_gemma":[0.00002261202,0.0001572303,0.0003657597,0.00005468235,0.00006207993,0.000305021,0.00007572305,0.4110947,0.004040639,0.5806116,0.003169416,0.0000405118],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.03455323,0.001074143,0.9562877,0.0009785042,0.00004430057,0.00007382144,0.0001312122,0.0002076006,0.006649425],"genre_scores_gemma":[0.6734915,0.001543706,0.3209257,0.0003375761,0.0003230463,0.000383941,0.0003414386,0.0002010411,0.002451919],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01224363,"threshold_uncertainty_score":0.06475127,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03518479320693964,"score_gpt":0.275027395432391,"score_spread":0.2398426022254513,"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."}}