Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39695 Views
- NBP, I also Faced
- E-Mail Answers
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
Write the fastest query to find out how many rows exist in a table?
Who are end users in dbms?
fact table and dimension table containg one to many relationship or many to one relastionship
How to use timestamp datatypes
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How can you log an error to the server event log from a stored procedure?
Explain the process of the user request and data generating?
What is the physical representation for a many-to-many relationship?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about normal forms?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to combine two function together?
What are the constraints on severity level in raiseerror?
What are data modelling techniques?
How to use online Backups?
