Home » RDBMS Server » Server Administration » Denormalized columns
Denormalized columns [message #208895] Tue, 12 December 2006 08:08 Go to next message
Messages: 259
Registered: January 2006
Senior Member

what is meant by denormalized columns?
When it's required/when we'll create it & how the values for these columns are obtained?

Can anyone explain this concept with an example?

Re: Denormalized columns [message #208930 is a reply to message #208895] Tue, 12 December 2006 11:21 Go to previous messageGo to next message
Messages: 43
Registered: December 2006
Denormalized columns are used mostly in DWH environments. To be more specific the Fact tables are mostly denormalized ones.

It helps in reducing resource contention.

These are generally populated using ETL process.
Re: Denormalized columns [message #208969 is a reply to message #208930] Tue, 12 December 2006 15:26 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member

You should have a complete understanding of the real benefits and real disadvantages of denormalized structures before using them. You can denormalize from a parent table onto a child table (say to record a State on an address table), from the current table onto itself (e.g. price + tax = total) or from a child table onto a parent table (e.g. order table has a Total column based on child records).
Previous Topic: Oracle Data Blocks clarification
Next Topic: Intermediate Commit
Goto Forum:

Current Time: Thu Oct 27 06:15:37 CDT 2016

Total time taken to generate the page: 0.10834 seconds