非规范化在关系数据库设计中的应用 |
| |
引用本文: | 刘伯莹,徐瑾. 非规范化在关系数据库设计中的应用[J]. 电脑开发与应用, 2003, 16(4): 75-76 |
| |
作者姓名: | 刘伯莹 徐瑾 |
| |
作者单位: | 天津大学,天津,300072 |
| |
摘 要: | 介绍了在关系数据库设计中的非规范化的概念和方法,即在数据库设计中适当地降低数据库的范式,以数据的冗余和不规则性来换取连接的减少以提高访问速度。并结合城市公共交通“一卡通”系统的数据库设计,分析了非规范化方法在实际问题中的应用,最后给出了非规范化处理的策略。
|
关 键 词: | 非规范化 规范化 数据库设计 一卡通 关系数据库 |
修稿时间: | 2002-11-12 |
Application of Unnormalization in Relational Database Design |
| |
Abstract: | 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. |
| |
Keywords: | denormalization normalization database design using only one card relational database |
本文献已被 CNKI 维普 万方数据 等数据库收录! |
|