Junior — Middle
What is the purpose of denormalization in databases?
sobes.tech AI
Answer from AI
Denormalization in databases is used to improve read performance by storing redundant data. Instead of complex JOIN queries, data is duplicated across tables, which speeds up data retrieval and reduces server load. This is useful in systems with high read query volume, where response speed is critical, such as analytics or high-load web applications. However, denormalization increases data update complexity, as data consistency must be maintained.