its_saru

 Profile 

• Oct 18th, 2006

 

Adding purposeful redudancy of data is called as Denormalization.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

 

denormaliztion is notihing but spliting the data and it's used for reducing data redundancy and improve data accessibility .

Sushant

• Oct 28th, 2006

 

As the name indic0ates, 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

hema

• Oct 30th, 2006

 

u'r saying abt normalization.

Nirmal V Nair

• Dec 5th, 2006

 

de-normalization is the reverse process of normalization. Some times we may want some speedretreival of data more than reducing redundancy .At that time we do the de-normalization and makesome redundancy

SRAVAN

• Dec 8th, 2006

 

Denormalization is Used in OLAP Systems.

Rajneesh Kaur

• Dec 21st, 2006

 

Denormalization is a technique to move from higher normal form to lower normal form in order to speed up database access. OR Denormalization is a technique of deriving a physical data model from a logical data model.Time does not play any role in DENORMALIZATION.Denormalization is done when fast retreival is must than redundancy.

sivanesh.a

 Profile Answers by sivanesh.a Questions by sivanesh.a

• Feb 6th, 2007

 

reverse process of normalization

hari prasad

• Mar 19th, 2007

 

when its a large data base and our main constraint is the  cost(time) than we concentrates on fast retriving .so we go for denormalization instade of joing(complex relation calculcus) too many table and be in much complexicity with hign normalization.

sweetytrivedi

 Profile Answers by sweetytrivedi 

• Jun 18th, 2008

 

Denormalization is the process of attempting to optimize the performance of a DB by adding redundant data or by grouping data. The recommendation is always to use this for teh logical design