What is denormalization and when would you go for it?
Answer Posted / niraj kumar
Industrial experience---->
Denormalization or Normalization both we use on databse so
that any one can filter as well as retrive the data from
the tabel easily.
Denormalization - As the name suggest it is a reverse
process of normalization, means we fill some redundant data
in table so that user can retrive easily.
But actualy we use the major functionality of normalization
of higher normal form(BCNF, 4TH NF ,5TH NF, DKNF) in lower
normal form (1st and 2nd) because higher normal forms are
so costly to use, thats why we use denormalization to
reduce the cost of normalization.
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is DB Development software?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
Explain the process of the user request and data generating?
Where is dbms used?
What is data modeling with example?
What is the maximum length of an extended property?
Explain about the database management systems.
Explain about the hierarchical model of the database?
Explain the cube operator?
Explain about normal forms?
Explain about the storage and physical database design?
What are the three types of database design?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS