非规范化在关系数据库设计中的应用

介绍了在关系数据库设计中的非规范化的概念和方法,即在数据库设计中适当地降低数据库的范式,以数据的冗余和不规则性来换取连接的减少以提高访问速度。并结合城市公共交通“一卡通”系统的数据库设计,分析了非规范化方法在实际问题中的应用,最后给出了非规范化处理的策略。

Application of Unnormalization in Relational Database Design

The concept and method of unnormalization in relational database design ars introduced, in which the database normalization is decreased properly during database design,and data redundancy and unnormalization results in a less connection, that will improve access speed. Describing the example of the database design of urban public traffic"using only one card",this paper analyzes the application of unnormalization in practical issue and presents the strategies of unnormalization.