数据正规化技术是为将数据正确地保存再各个标准,从而使数据冗余达到最小,存取速度达到最高。
The technique of data normalization is about correct ways of partitioning the data among tables to minimize data redundancy and maximize the speed of retrieval.
现实世界中的数据库(正规化和反向规格化,SQL,索引)
Real world Databases (Normalisation and De-normalisation, SQL, Indexing)
为了提高可伸缩性,数据应该重复而非正规化。
To scale data should be duplicated instead of being normalized.
关系数据库的世界是以防止错误为根基的;以正规化(normalization)为工具消除重复和防止更新异常。
Relational world is based on error prevention; and normalization is used as a tool to remove duplication and prevent update anomalies.
为了在去正规化的条件下,保证数据跨多个实体的一致性,schema必须“在代码中定义,因为那是唯一能跟踪所有关系和保证数据正确性的地方。”
To keep data consistent across multiple entities in a denormalized context, schemas have to be “defined in code because it’s only code that can track all the relationships and maintain correctness.”
看来我们很可以称2007为“数据库正规化的神秘面纱被揭穿的一年”。
2007 could well be dubbed "the year the normalized database myth was debunked".
看来我们很可以称2007为“数据库正规化的神秘面纱被揭穿的一年”。
2007 could well be dubbed "the year the normalized database myth was debunked".
应用推荐