what is difference between normalization and denormalization. in normalizatio

what is difference between normalization and
denormalization.
in normalization all tables are normalizad format or not.
what r the types of indexes are there.
what is difference b/w bitmap,b-tree,unique and function
based indexes.

Question Posted / srinivas

2 Answers
24324 Views
KPIT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is difference between normalization and denormalization. in normalization all tables are nor..

Answer / karthikeyan

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.

Is This Answer Correct ?

16 Yes

1 No

what is difference between normalization and denormalization. in normalization all tables are nor..

Answer / samarth

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"

Is This Answer Correct ?

7 Yes

2 No

Post New Answer

More Business Management AllOther Interview Questions

what is ROI stands for

1 Answers

(b) Explain how to insert a hyperlink in to an Excel worksheet and save a Word document as a Web page.

0 Answers

Is outsourcing of computer can be called as bpo?

0 Answers Spanco,

What would you do if your business tends to decline?

0 Answers IBM,

How to make Private company into public limited company ?

0 Answers

why MBA after Bsc(IT) ?

0 Answers

What Is Work-Flow in SAP

0 Answers GMR, IBM,

A. What factor account for the resurgence of interest in Operation Management today? B What strategies are used by supermarkets, airlines, hospitals, banks, and cereal Manufacturers to influence demand.

1 Answers

How have you decided what level of detail to go into?

0 Answers John Clark Motor Group,

Business Managment

2 Answers Shivam Dye Chem,

Give a relationship between concept, Hypothesis and Theory. What are the Salient features and classifications?

0 Answers

How get the c form for my company

0 Answers

For more Business Management AllOther Interview Questions Click Here