What is De-normalization?

Asked 20-Nov-2017
Viewed 816 times

1 Answer


0

De-normalization is an important concept in database design, which is used to improve performance and reduce complexity. It is the process of reorganizing data in a database to reduce redundancy and improve the performance of certain queries.

Simply put, de-normalization is a way of organizing data in a database to reduce the amount of data redundancy and improve the performance of certain queries. It involves the elimination of redundant data and incorporating the non-redundant data into larger, more complex data structures.

Normalization is the process of organizing data into a logical structure that minimizes redundant data. The process of normalization includes the analysis of relationships between data items, the identification of appropriate key fields, and the identification of relationships between tables. It is a process that reduces the size and complexity of a database.

De-normalization is the opposite of normalization. It is the process of reorganizing data in a database in order to reduce redundancy and improve the performance of certain queries. It involves the addition of redundant data and the incorporation of large and complex data structures.

De-normalization can be divided into two categories: logical de-normalization and physical de-normalization. Logical de-normalization involves the addition of redundant data and the incorporation of large and complex data structures. Physical de-normalization involves the addition of redundant data and the reorganization of the physical layout of the database.

De-normalization is often used in databases with large amounts of data. In such cases, the data can be organized in a more efficient manner to reduce the amount of redundant data and improve the performance of certain queries.

By de-normalizing the data, you can add redundant data to the database and make it easier to query the data. You can also reorganize the physical layout of the database in order to reduce redundancy and improve the performance of certain queries. De-normalization can significantly improve the performance of certain queries by reducing the amount of data redundancy and improving the speed of certain queries.

De-normalization is an important concept in database design and is often used to improve the performance of certain queries. It involves the elimination of redundant data and the incorporation of large and complex data structures. By de-normalizing the data, you can reduce the amount of redundant data and improve the performance of certain queries.