Web Administration > Databases

Why Denormalization

(1/1)

Sap Solution:
Why demoralization techniques are used when we develop a decision support system ?

richardmsmith:
Denormalization is a strategy used on a previously-normalized database to increase performance.
When and Why to Use Denormalization
Maintaining history
Improving query performance
Speeding up reporting
Computing commonly-needed values up front

saravanan28:
Denormalization is a strategy used on a previously-normalized database to increase performance. The idea behind it is to add redundant data where we think it will help us the most. We can use extra attributes in an existing table, add new tables, or even create instances of existing tables.

Navigation

[0] Message Index

Go to full version