Advantages of de normalized data?
Answers were Sorted based on User's Feedback
Answer / bharat kalra
De-normalization is a concept used for fast data retrieval
as it reduces the number of joins to be performed in the
select query.
It's reverse of normalisation as any normalised data base
is optimized for DML operations(insert,update,delete).
| Is This Answer Correct ? | 9 Yes | 4 No |
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
| Is This Answer Correct ? | 10 Yes | 5 No |
What is a hash cluster?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Tell me what is degree of a relation?
Explain the importance of data warehouse?
What is a fact, dimension, measure?
Code the tables statement to produce a multi-level frequency?
What is Time Series algorithm in data mining?
What is the metadata extension?
Explain the definition of normalized and denormalized view and what are the differences between them?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
What are necessary tasks to install reportnet software?