Statistical Relational Databases: Normal Forms

This paper discusses problems associated with defining normal forms of relational tables relevant to statistical processing. The concepts of derived identifier, class identifier, derived class-counts, count domains, compact and uniform domains for statistical relational tables have been introduced. We also discuss the structures of the first and the second statistical-normal forms and the relational decompositions needed to achieve them. The statistical-normal form can be an important method to determine whether the usual statistical analysis techniques are valid. We have some suggestions for extending the SQL statements to achieve these operations on statistical relational tables. Some results linking Codd'S normal forms with statistical normal forms are also discussed. We also discuss relational statistical abnormalities, called outlyers. © 1991 IEEE