Category

Database normalization

page 1

database normalisation

reduction of data redundancy

first normal form

minimum requirement in database normalization

third normal form

normalizing a database design to reduce the duplication of data and ensure referential integrity

second normal form

database normalization requirement after first normal form

Boyce–Codd normal form

normal form used in database normalization which removed all redundancies based on functional dependencies

denormalization

Denormalization is a strategy used on a previously-normalized database to increase performance. In computing, denormalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data. It is often motivated by performance or scalability in relational database software needing to carry out very large numbers of read operations. Denormalization differs from the unnormalized form in that denormalization benefits can only be fully realized on a data model that is otherwise normaliz

fourth normal form

normal form used in database normalization concerned with multivalued dependency

fifth normal form

database normalization form designed to remove final redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships

Armstrong's axioms

set of axioms used to infer all the functional dependencies on a relational database

single source of truth

information systems good practice for data normalization using one source for a particular data element

sixth normal form

relational database normalization form which generalizes relational operators to support interval data

domain-key normal form

database normalization that requires there are no other contains than on domain and keys

lossless decomposition

decomposition of a database relation such that a natural join of the resulting relations yields back the original relation