Agenda: Introduction What is Denormalization? Benefits When to use? Read-Heavy Systems Reporting and Analytics Real time data Requirements Denormalization Techniques Materialized Views Redundant Columns Aggregated Tables Challenges and Consideration Conclusion