在数据库方面，是“Normalize for correctness，denormalize for performance”一个正确的口头禅？ [英] In terms of databases, is "Normalize for correctness, denormalize for performance" a right mantra?

问题描述

正常化导致许多基本和理想的特性，包括美学的乐趣。此外，它在理论上也是正确的。在这种情况下，非规范化被应用为折衷，即实现性能的校正。
除了数据库可能被非规范化之外，还有什么其他原因吗？

Normalization leads to many essential and desirable characteristics, including aesthetic pleasure. Besides it is also theoretically "correct". In this context, denormalization is applied as a compromise, a correction to achieve performance. Is there any reason other than performance that a database could be denormalized?

推荐答案

是：

1. 效能


2. 无知

前者应通过分析进行验证，后者应使用卷起的报纸进行更正; - ）

The former should be verified with profiling, while the latter should be corrected with a rolled-up newspaper ;-)

说一个更好的口头禅将正常化的正确性，反正规化的速度 - 只有在必要时

I would say a better mantra would be "normalize for correctness, denormalize for speed - and only when necessary"

这篇关于在数据库方面，是“Normalize for correctness，denormalize for performance”一个正确的口头禅？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！