What are normalization and denormalization?

1.	What are normalization and denormalization?
Answer» Normalization means MERELY a process of reducing or eliminating the DATA REDUNDANCY. As a result, space is saved, and the consistency of data is increased. The DENORMALIZATION is an optimization process to increase the data redundancy in the database. As a result, the JOINS are avoided, and the performance of the database structure is improved. Denormalization is done after the normalization process

Answer»

Normalization means MERELY a process of reducing or eliminating the DATA REDUNDANCY. As a result, space is saved, and the consistency of data is increased.

The DENORMALIZATION is an optimization process to increase the data redundancy in the database. As a result, the JOINS are avoided, and the performance of the database structure is improved. Denormalization is done after the normalization process

Discussion

No Comment Found

Related InterviewSolutions

What are Java doGet () and doPost () methods?
How garbage collection makes Java more memory efficient?
What is the use of overloading and overriding in Java?
What is the difference between boxing and unboxing in Java?
What is the difference between Errors and Exceptions in Java?
Which one is better, setter injection or constructor injection?
Can you override a static method in Java?
How many ways to handle exceptions in the Spring MVC Framework?
What are the different methods of session management in Servlet?
How can we detect and avoid deadlock in Java?

What are normalization and denormalization?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment