摘要
介绍了在关系数据库设计中的非规范化的概念和方法,即在数据库设计中适当地降低数据库的范式,以数据的冗余和不规则性来换取连接的减少以提高访问速度。并结合城市公共交通“一卡通”系统的数据库设计,分析了非规范化方法在实际问题中的应用,最后给出了非规范化处理的策略。
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.
出处
《电脑开发与应用》
2003年第4期75-76,共2页
Computer Development & Applications
关键词
非规范化
关系数据库
设计
数据冗余
denormalization, normalization, database design, using only one card, relational database