On normalization of relations in relational databases

被引:8
|
作者
Khodorovskii, VV [1 ]
机构
[1] St Petersburg State Univ Culture & Arts, Dept Informat Sci, St Petersburg 191186, Russia
关键词
Operating System; Artificial Intelligence; Normal Form; Specific Requirement; Relational Database;
D O I
10.1023/A:1013759617481
中图分类号
TP31 [计算机软件];
学科分类号
081202 ; 0835 ;
摘要
A new normal form, namely, object-normal form (ONF), is introduced. It is shown that the existing definitions of the fifth normal form (5NF) are unsatisfactory. The correct definition is given for the first time. The importance of the 5NF is demonstrated. For improving data representation in a database with a 5NF schema, the notion of negating relation is introduced. It serves as a basis for the new normal form, namely, the sixth normal form. Combining requirements of the ONF and other normal forms, new normal forms are defined: the fourth object-normal form, the fifth object-normal form, and the sixth object-normal form. It is shown that the standard order of steps of the normalization procedure should be changed: first, the specific requirements of the fourth normal form should be satisfied, and only then the requirements of the second normal form, and so forth.
引用
收藏
页码:41 / 52
页数:12
相关论文
共 50 条
  • [1] On Normalization of Relations in Relational Databases
    V. V. Khodorovskii
    Programming and Computer Software, 2002, 28 : 41 - 52
  • [2] NORMALIZATION OF RELATIONAL DATABASES
    SRINIVASAN, B
    RAJARAMAN, V
    INFORMATION PROCESSING LETTERS, 1979, 9 (02) : 89 - 92
  • [3] ON THE NORMALIZATION IN NESTED RELATIONAL DATABASES
    OZSOYOGLU, ZM
    YUAN, LY
    LECTURE NOTES IN COMPUTER SCIENCE, 1989, 361 : 243 - 271
  • [4] Relational databases with ordered relations
    Nedbal, Radim
    LOGIC JOURNAL OF THE IGPL, 2005, 13 (05) : 587 - 597
  • [5] FUZZY RELATIONS AND FUZZY RELATIONAL DATABASES
    MELTON, A
    SHENOI, S
    COMPUTERS & MATHEMATICS WITH APPLICATIONS, 1991, 21 (11-12) : 129 - 138
  • [6] ON SIMILARITY RELATIONS IN FUZZY RELATIONAL DATABASES
    POTOCZNY, HB
    FUZZY SETS AND SYSTEMS, 1984, 12 (03) : 231 - 235
  • [7] Entities and relations for historical relational databases
    Morris, RA
    Khatib, L
    FOURTH INTERNATIONAL WORKSHOP ON TEMPORAL REPRESENTATION AND REASONING, PROCEEDINGS, 1997, : 180 - 186
  • [8] The entropy of rough relations in rough relational databases
    Sui, YF
    Wang, J
    Jiang, YC
    WORLD MULTICONFERENCE ON SYSTEMICS, CYBERNETICS AND INFORMATICS, VOL 1, PROCEEDINGS: INFORMATION SYSTEMS DEVELOPMENT, 2001, : 566 - 570
  • [9] Complementary Relations and Their Concept Lattices in Relational Databases
    Lei, Yuxia
    Sui, Yuefei
    Cao, Cungen
    2009 FIFTH INTERNATIONAL CONFERENCE ON SEMANTICS, KNOWLEDGE AND GRID (SKG 2009), 2009, : 152 - 159
  • [10] A logic of type relations and its applications to relational databases
    MacCaull, Wendy
    Orlowska, Ewa
    JOURNAL OF LOGIC AND COMPUTATION, 2006, 16 (06) : 789 - 815