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.
Answers were Sorted based on User's Feedback
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 |
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 |
How did you decide on these actions?
0 Answers John Clark Motor Group,
1. What are the different levels of Management? Describe the role of the people at each level of management?
How do you balance the need for quality work, customer satisfaction and profitability?
Difference between traditional and old concept of marketing?
How did you start the process?
0 Answers John Clark Motor Group,
Home Based Research Jobs.(ti17380)
what do you mean by ERPS?
NGOs have become a lucrative business
how much salary expected as a freshar
how about ibm(international business management) specialization in MBA?What are the future in it?what are the sources to upgrade it?
Describe a BPM and explain why it is used with examples?
How successful were you?
0 Answers John Clark Motor Group,