About denormalization

Posted by Sumit.Bundiwal under Sql Server on 7/10/2012 | Points: 10 | Views : 1468 | Status : [Member] | Replies : 6
In which situation we have to use denormalization with example

sumit bundiwal


Responses

Posted by: Premalatha on: 7/10/2012 [Member] Starter | Points: 25

Up
0
Down
http://www.dfpug.de/loseblattsammlung/online/workshop/jim_booth/seite3.htm

http://www.siue.edu/~dbock/cmis564/denormal.htm

Premalatha
Software Engineer

Sumit.Bundiwal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Gaur1982 on: 7/10/2012 [Member] Starter | Points: 25

Up
0
Down
check this link : http://planetofcoders.com/de-normalization/

Gaurav Agrawal
http://www.planetofcoders.com/

Sumit.Bundiwal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/10/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Refer this url.
it will help u.
http://www.siue.edu/~dbock/cmis564/denormal.htm

Sumit.Bundiwal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Weblorquins on: 7/16/2012 [Member] Starter | Points: 25

Up
0
Down
De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It is sometimes necessary because current DBMSs implement the relational model poorly. A true relational DBMS would allow for a fully normalized database at the logical level, while providing physical storage of data that is tuned for high performance. De-normalization is a technique to move from higher to lower normal forms of database modeling in order to speed up database access.

De-normalizing the database design allows for fewer joins with tables and foreign key requirements. This method is commonly used for Reporting and OLAP workloads.
For more Interview question Click on billow link.

http://sqlserver4us.blogspot.in/

Sumit.Bundiwal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 9/4/2012 [Member] Bronze | Points: 25

Up
0
Down
Denormalization is the process of attempting to optimise the read performance of a database by adding redundant data or by grouping data. In some cases, denormalisation helps cover up the inefficiencies inherent in relational database software. A relational normalised database imposes a heavy access load over physical storage of data even if it is well tuned for high performance.

Sumit.Bundiwal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pgayath on: 9/4/2012 [Member] Starter | Points: 25

Up
0
Down
Denormalization is the process of allowing redundancies to optimize the performance.
To overcome the update anamolies, maintain the denormalized data in transactions.

1. Denormalize to Maintain History
A fully normalized schema shows current state only.History can be easily maintained in a denormalised schema by having more tables.

2. Denormalize for Performance
Performance is increased by the need of fewer joins in a denormalised schema.

Example:
In an invoicing application that is in a fully normalized design, customer's address will be only in the Customers table. Suppose that a customer moves and you update that customer's address with the new one. A few days later, the same customer reports that he accidentally lost some printed invoices during the move and asks you to print copies of lost invoices. It would be impossible to print exact copies of the invoices if you do not maintain some history about the customer's address. You can solve this problem by maintaining a copy of customer address information on the invoice date in the Invoices table which is a denormalised form. Similarly, customers can change their name, so you also need to maintain a copy of customer names as part of the invoice data in the Invoices table.

Thanks,
Gayathri P

Sumit.Bundiwal, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response