Ebay Interview Question
Member Technical StaffsCountry: United States
Interview Type: In-Person
Haha Please Change "Demormalisation" to DeNormalization... Coz nothing is gonna hamper morals..
Anyways..
Basically we need to normalise Stuffs ( I hope in this context DB ) to make sure there is not redundancy ... the performance enhancement occurs in two ways
1> No redundant data means Space utilisation minimal.
2> It helps to search the record easily coz we know the interconnection of the tables easily.. So optimization of execution time..
Question corrected ..
Anyways i think there will be NO/LESS interconnection of table after denormalisation which reduces execution time .
Denormalization avoids JOINs between tables, improving performance. The downside is the increase in space utilization.
- george.maggessy April 06, 2013