Lesson learned during denormalization

What is database denormalization?
Google says: In computing, denormalization is the process of attempting to optimize the read performance of a database by adding redundant data or by grouping data. In some cases, denormalization is a means of addressing performance or scalability in relational database software.

Mind the word “attempting”, that means it will make an effort to tune your database but not sure about it, so stepping forward into denormalization needs an in-depth impact analysis of your environment. See below, how a smart DBA learned a lesson?

DENORMALIZATION

  • On the first day of denormalization, my design gave to me a really fast-running query.
  • On the second day of denormalization, my design gave to me 2 less tables.
  • On the third day of denormalization, my design gave to me 3 more indexes.
  • On the fourth day of denormalization, my design gave to me 4 larger disks.
  • On the fifth day of denormalization, my design gave to me 5 brand new object requests.
  • On the sixth day of denormalization, my design gave to me 6 times the locking.
  • On the seventh day of denormalization, my design gave to me 7 longer updates.
  • On the eighth day of denormalization, my design gave to me 8 more requirements.
  • On the ninth day of denormalization, my design gave to me 9 invalid rows.
  • On the tenth day of denormalization, my design gave to me 10 delays deleting.
  • On the eleventh day of denormalization, my design gave to me 11 questionable queries.
  • On the twelfth day of denormalization, my design gave to me a very complex coding in database.

Lesson learned!! Never ever denormanilize a database without a proper impact analysis.

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

Leave a Reply

%d bloggers like this: