On the number of independent functional dependencies

被引:0
|
作者
Demetrovics, J
Katona, GOH
Miklós, D
Thalheim, B
机构
[1] Hungarian Acad Sci, Inst Comp & Automat, H-1111 Budapest, Hungary
[2] Hungarian Acad Sci, Alfred Renyi Inst Math, H-1364 Budapest, Hungary
[3] Univ Kiel, Inst Comp Sci & Pract Math, D-24098 Kiel, Germany
关键词
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
We will investigate the following question: what can be the maximum number of independent functional dependencies in a database of n attributes, that is the maximum cardinality of a system of dependencies which which do not follow from the Armstrong axioms and none of them can be derived from the remaining ones using the Armstrong axioms. An easy and for long time believed to be the best construction is the following: take the maximum possible number of subsets of the attributes such that none of them contains the other one (by the wellknown theorem of Sperner [8] their number is (n / n/2)) and let them all determine all the further values. However, we will show ( n by a specific construction that it is possible to give more than (n / n/2) independent dependencies (the construction will give (I + 1 / n(2))(n / n/2) of them) and - on the other hand - the upper bound is 2(n) - 1, which is roughly root n(n / n/2).
引用
收藏
页码:83 / 91
页数:9
相关论文
共 50 条
  • [1] INDEPENDENT DATABASE SCHEMES UNDER FUNCTIONAL AND INCLUSION DEPENDENCIES
    ATZENI, P
    CHAN, EPF
    [J]. ACTA INFORMATICA, 1991, 28 (08) : 777 - 799
  • [2] REPRESENTATION OF CLOSURES IN THE NUMBER OF FUNCTIONAL AND JOIN DEPENDENCIES IN RELATIONAL SCHEMES
    DEMETROVICH, Y
    ZUI, NS
    [J]. PUBLICATIONES MATHEMATICAE-DEBRECEN, 1989, 36 (1-4): : 33 - 50
  • [3] Elaboration on Functional Dependencies: Functional Dependencies Are Dead, Long Live Functional Dependencies!
    Karachalias, Georgios
    Schrijvers, Tom
    [J]. ACM SIGPLAN NOTICES, 2017, 52 (10) : 133 - 147
  • [4] Inclusion dependencies and their interaction with functional dependencies in SQL
    Koehler, Henning
    Link, Sebastian
    [J]. JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 2017, 85 : 104 - 131
  • [5] INCLUSION DEPENDENCIES AND THEIR INTERACTION WITH FUNCTIONAL-DEPENDENCIES
    CASANOVA, MA
    FAGIN, R
    PAPADIMITRIOU, CH
    [J]. JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 1984, 28 (01) : 29 - 59
  • [6] A Unified Hierarchy for Functional Dependencies, Conditional Functional Dependencies and Association Rules
    Medina, Raoul
    Nourine, Lhouari
    [J]. FORMAL CONCEPT ANALYSIS, 2009, 5548 : 98 - 113
  • [7] Functional Dependencies for XML
    Chen, Haitao
    Liao, Husheng
    Gao, Zengqi
    [J]. WEB-AGE INFORMATION MANAGEMENT, 2010, 6185 : 110 - 115
  • [8] Monoidal functional dependencies
    Vychodil, Vilem
    [J]. JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 2015, 81 (07) : 1357 - 1372
  • [9] Functional dependencies for XML
    Vincent, MW
    Liu, JX
    [J]. WEB TECHNOLOGIES AND APPLICATIONS, 2003, 2642 : 22 - 34
  • [10] PageRank: Functional Dependencies
    Boldi, Paolo
    Santini, Massimo
    Vigna, Sebastiano
    [J]. ACM TRANSACTIONS ON INFORMATION SYSTEMS, 2009, 27 (04)