Modelling functional dependencies in databases using mathematical logic

被引:2
|
作者
Lovrencic, Alen [1 ]
Cubrilo, Mirko [1 ]
Kisasondi, Tonimir [1 ]
机构
[1] Univ Zagreb, Fac Org & Informat, Zagreb 41000, Croatia
关键词
D O I
10.1109/INES.2007.4283717
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
For more than 20 years relational model is the most important database model. So, it is examined in the most various ways. A very important concept in the relational model is the concept of dependencies, especially functional dependencies. It is proven that functional dependencies can be represented by formulae of propositional or predicate calculus. There are several systems of transforming functional dependencies into a logic system, known from the literature, but all of them has one serious drawback: they do not have a form that is appropriate for reasoning about normalization. This paper presents a new approach to the process of transforming functional dependencies into predicate calculus. The system presented in this paper is designed in the way to be appropriate for normalization, reasoning about it, as well as for the building a system for automated normalization of databases.
引用
收藏
页码:307 / +
页数:2
相关论文
共 50 条
  • [41] FUNCTIONAL-DEPENDENCIES IN RELATIONAL DATABASES - A LATTICE POINT-OF-VIEW
    DEMETROVICS, J
    LIBKIN, L
    MUCHNIK, IB
    [J]. DISCRETE APPLIED MATHEMATICS, 1992, 40 (02) : 155 - 185
  • [42] Functional and multivalued dependencies in nested databases generated by record and list constructor
    Hartmann, S
    Link, S
    Schewe, KD
    [J]. ANNALS OF MATHEMATICS AND ARTIFICIAL INTELLIGENCE, 2006, 46 (1-2) : 114 - 164
  • [43] Functional and multivalued dependencies in nested databases generated by record and list constructor
    Sven Hartmann
    Sebastian Link
    Klaus-Dieter Schewe
    [J]. Annals of Mathematics and Artificial Intelligence, 2006, 46 : 114 - 164
  • [44] Functional dependencies in extended possibility-based fuzzy relational databases
    Ma, ZM
    Zhang, WJ
    Ma, WY
    Chen, GQ
    [J]. NINTH IEEE INTERNATIONAL CONFERENCE ON FUZZY SYSTEMS (FUZZ-IEEE 2000), VOLS 1 AND 2, 2000, : 929 - 932
  • [45] Mathematical modelling of Bit-Level Architecture using Reciprocal Quantum Logic
    Narendran, S.
    Selvakumar, J.
    [J]. PROCEEDINGS OF THE 10TH NATIONAL CONFERENCE ON MATHEMATICAL TECHNIQUES AND ITS APPLICATIONS (NCMTA 18), 2018, 1000
  • [46] Mathematical modelling of the one-carbon metabolism network by using logic programming
    Chango, Abalo
    Gnimpieba, Etienne Z.
    [J]. FASEB JOURNAL, 2011, 25
  • [47] A relation-algebraic approach to the "Hoare logic" of functional dependencies
    Oliveira, Jose N.
    [J]. JOURNAL OF LOGICAL AND ALGEBRAIC METHODS IN PROGRAMMING, 2014, 83 (02) : 249 - 262
  • [48] Temporal functional dependencies with multiple granularities: A logic based approach
    Combi, C
    Rossato, R
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2004, 3180 : 864 - 873
  • [49] FUNCTIONAL MODELLING FOR LOGIC SIMULATION.
    Raeth, Peter G.
    Acken, John M.
    Lamont, Gary B.
    Borky, John M.
    [J]. Proceedings - Design Automation Conference, 1981, : 791 - 795
  • [50] Dependencies in relational models of databases
    Winter, Michael
    [J]. JOURNAL OF LOGICAL AND ALGEBRAIC METHODS IN PROGRAMMING, 2016, 85 (05) : 1095 - 1107