What is Database Denormalization?

Posted By: Avi

Date: 7 October 2009 02:29:21 AM

Answer:

Database denormalization is the reverse process of database normalization. Denormalization is the process of attempting to optimize the performance of a database by adding redundant data or by grouping data. It helps improve the query performance as the number of joins could be reduced.
Posted By: eTechPlanet	Date: 7 October 2009 02:29:21 AM
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.
Posted By: Johndecruse	Date: 4 February 2010 12:47:14 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

What do you mean by Cardinality?

Cardinality refers to the type of relationship like the relationship between two entities is one to ....

Category: Database

Date: 8/20/2009 3:06:52 AM

When number of transaction are running at the same time and if a situation occurs when the one trans....

Category: Database

Date: 8/20/2009 3:04:53 AM

Concurrency refers when the two or more transaction are executed simultaneously.

Category: Database

Date: 8/20/2009 3:03:52 AM

Candidate key is a set of one or more attribute other than primary key that can uniquely identify a ....

Category: Database

Date: 8/20/2009 3:02:40 AM

A foreign key is a referential constraint between two tables. The foreign key identifies a column or....

Category: Database

Date: 8/20/2009 3:01:26 AM

View All Questions >>

Signup for our weekly email newsletter