Denormalization
speeds up reads
-improves query performance -BI reporting -BA data cubes you can find the information faster...it comes back to you quicker
denormalization
The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields when you duplicate the data so it can be found in multiple places (more useful like this)
denormalization def
conversion of a table that is in third normal form to a table that is no longer in third normal form...introduces anomaly problems but can decrease the number of disk accesses required by certain types of transactions...thus improves performance
slows down writes
makes sure the data is being written in accurately not an architectural approach
denormalization and big data
normalization atomizes data -queries piece it back together it can be difficult to piece it back together, because big data does not always play along