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 条
  • [1] Using Functional Dependencies in Conversion of Relational Databases to Graph Databases
    Megid, Youmna A.
    El-Tazi, Neamat
    Fahmy, Aly
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS (DEXA 2018), PT II, 2018, 11030 : 350 - 357
  • [2] Functional dependencies in random databases
    Demetrovics, J
    Katona, GOH
    Miklós, D
    Seleznjev, O
    Thalheim, B
    [J]. STUDIA SCIENTIARUM MATHEMATICARUM HUNGARICA, 1998, 34 (1-3) : 127 - 140
  • [3] Functional dependencies for XML databases
    Dong Dong
    Wuwongse, Vilas
    [J]. ICCSE'2006: PROCEEDINGS OF THE FIRST INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE & EDUCATION: ADVANCED COMPUTER TECHNOLOGY, NEW EDUCATION, 2006, : 249 - 255
  • [4] Functional dependencies in fuzzy databases
    Nakata, M
    [J]. FIRST INTERNATIONAL CONFERENCE ON KNOWLEDGE-BASED INTELLIGENT ELECTRONIC SYSTEMS, PROCEEDINGS 1997 - KES '97, VOLS 1 AND 2, 1997, : 363 - 372
  • [5] Ordered functional dependencies in relational databases
    Ng, W
    [J]. INFORMATION SYSTEMS, 1999, 24 (07) : 535 - 554
  • [6] ARMSTRONG DATABASES FOR FUNCTIONAL AND INCLUSION DEPENDENCIES
    FAGIN, R
    VARDI, MY
    [J]. INFORMATION PROCESSING LETTERS, 1983, 16 (01) : 13 - 19
  • [7] An approach to functional dependencies in fuzzy databases
    Bosc, P
    Pivert, O
    Liétard, L
    [J]. NINTH IEEE INTERNATIONAL CONFERENCE ON FUZZY SYSTEMS (FUZZ-IEEE 2000), VOLS 1 AND 2, 2000, : 917 - 922
  • [8] Functional dependencies in vague relational databases
    Zhao, Faxin
    Ma, Z. M.
    [J]. 2006 IEEE INTERNATIONAL CONFERENCE ON SYSTEMS, MAN, AND CYBERNETICS, VOLS 1-6, PROCEEDINGS, 2006, : 4006 - +
  • [9] REPRESENTATION OF FUNCTIONAL-DEPENDENCIES IN RELATIONAL DATABASES USING LINEAR GRAPHS
    NAMBIAR, KK
    RADHAKRISHNAN, T
    TIKEKAR, VG
    [J]. THEORETICAL COMPUTER SCIENCE, 1983, 24 (02) : 143 - 159
  • [10] Towards relational inconsistent databases with functional dependencies
    Greco, Sergio
    Molinaro, Cristian
    [J]. KNOWLEDGE-BASED INTELLIGENT INFORMATION AND ENGINEERING SYSTEMS, PT 2, PROCEEDINGS, 2008, 5178 : 695 - 702