Effective SQL Item 9 Posted on 2024-05-13 In DataBase Views: Symbols count in article: 177 Reading time ≈ 1 mins. Data Model Design Use Denormalization for Information Warehouses 简介数仓环境可能需要 Denormalization。存储计算字段等。数仓环境一般用于查询，写入一般没有很高的要求。 Things to Remember Decide what data to duplicate and why. Plan how to keep the data in sync. Refactor the queries to use the denormalized fields.