问题描述
规范化会带来许多基本和理想的特征，包括审美愉悦.此外，它在理论上也是正确的".在这种情况下，非规范化被用作一种折衷，一种实现性能的校正.除了性能之外，还有其他原因可以对数据库进行非规范化吗?
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?
推荐答案
非规范化的两个最常见原因是:
The two most common reasons to denormalize are:
- 性能
- 无知
前者应通过分析进行验证，而后者应通过卷起的报纸进行更正;-)
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"
这篇关于在数据库方面，是“为了正确性而规范化，为了性能去规范化"；正确的咒语?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！