Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 38974 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
In which database can extended stored procedures be added?
Explain about normal forms?
What is database design and development?
How to replace not in with not exist?
Explain the rollup operator?
How to combine two function together?
Who are naive users?
Explain about the database management systems.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Who are end users in dbms?
How would you design a database for an online site, which would average a million hits a day?
Can an extended stored procedure be called from inside a user-defined function?
How is data stored in dbms?
What is data modeling with example?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
