Question:
What is denormalization and difference between normalization and denormalization?
Answer:
Denormalization is the process of attempting to optimize the performance of a database by adding redundant data or by grouping data. Normalization is the process of de-composing a relation with anomalies into a well structured relation. Source: CoolInterview.com
Answered by: Ram | Date: 2/2/2009
| Contact Ram
Normalization is the process of organizing database into tables in such a way that the results of using the database are always unambiguous and as intended whereas Denormalization is the process of attempting to optimize the performance of a database by adding redundant data or by grouping data. Hope it helps you !!!!!!!!!!!
-cheers, Deepa Source: CoolInterview.com
Answered by: Deepa | Date: 4/16/2009
| Contact Deepa
As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced. Source: CoolInterview.com
Answered by: Jayanthi | Date: 7/9/2009
| Contact Jayanthi
Denormalization is the process of introducing redundancy into a table by incorporating data from a related table. Tables are usually denormalized to prevent expensive SQL join operations between them.
One should always normalize to third-normal form and only apply denormalization selectively as a last resort if performance problems are experienced. Remember that denormalizations is not free and introduces the following problem into the design: More disk space is used as the same data is duplicated in more than one table DML operations are more expensive as the same data must be maintained in more than one table You run the risk that the data can get "out of sync" Source: CoolInterview.com
Answered by: Mrudang | Date: 9/7/2009
| Contact Mrudang
In a simple way denormalisation is converting rows to columns and normalisation is converting columns to rows Source: CoolInterview.com
Answered by: promila | Date: 3/19/2010
| Contact promila
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|