Tell Something You Know About Normalization And De-normalization?

1.	Tell Something You Know About Normalization And De-normalization?
Answer» Normalization is nothing but the process that is adopted for the purpose or removing the REDUNDANT data from the database. This is GENERALLY done by splitting the table into different sections. This actually makes sure of integrity. On the other side, the de-normalization is the process of considering the redundant data so that all the QUERIES which are complex can be ENHANCED in terms of overall performance. Normalization is nothing but the process that is adopted for the purpose or removing the redundant data from the database. This is generally done by splitting the table into different sections. This actually makes sure of integrity. On the other side, the de-normalization is the process of considering the redundant data so that all the queries which are complex can be enhanced in terms of overall performance.

Answer»

Normalization is nothing but the process that is adopted for the purpose or removing the REDUNDANT data from the database. This is GENERALLY done by splitting the table into different sections. This actually makes sure of integrity. On the other side, the de-normalization is the process of considering the redundant data so that all the QUERIES which are complex can be ENHANCED in terms of overall performance.

Normalization is nothing but the process that is adopted for the purpose or removing the redundant data from the database. This is generally done by splitting the table into different sections. This actually makes sure of integrity. On the other side, the de-normalization is the process of considering the redundant data so that all the queries which are complex can be enhanced in terms of overall performance.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Benefits That Sql Can Bring For You?
What Exactly Is The Significance Of Persistence Layer In Sap Hana?
How To Secure A Sap Hana User Connexion?
What Is The Best Way To Manage, Operate, And Monitor Sap Hana Systems?
Can You Tell Something About The Role Of Transaction Manager And Session In Sap Hana?
What Do You Know About The Master Controller Job In The Hana?
What Problems Can Unnecessary Information Can Cause In The Sap Hana And How You Can Avoid The Same From Being Stored In The Application?
Can You Tell Some Important Benefits That Users Can Have From The Slt Replication In Sap Hana?
What Are The Various Tasks In The Sap Hana Which Are Performed By The Modeling Studio?
What Sort Of Advantages Do Businesses Have With Effective Database Management?