| 规范化与反规范化理论在图书订购系统中的应用 |
| |
| 引用本文： | 肖海蓉. 规范化与反规范化理论在图书订购系统中的应用[J]. 陕西理工学院学报(自然科学版), 2011, 27(2) |
| |
| 作者姓名： | 肖海蓉 |
| |
| 作者单位： | 陕西理工学院,计算机科学与技术系,陕西,汉中,723001 |
| |
| 摘 要： | 关系数据库的规范化理论是判断一个数据库逻辑设计是否合理的重要手段,取图书订购系统的数据库设计为例,采用逐步深入的方法解决了数据库设计中存在的问题,并使关系模式满足更高级别的范式要求.同时,分析了反规范化理论在数据库设计中的应用.实例研究证明,在进行关系模式设计时,并非范式的级别越高,数据库系统的性能就越好,需根据实际需求.合理设计数据库模式.
|
| 关 键 词： | 关系模式 规范化 范式 反规范化 图书订购系统 |
Usage of normalization and denormalization theory in books Ordering system |
| |
| XIAO Hai-rong. Usage of normalization and denormalization theory in books Ordering system[J]. Journal of Shananxi University of Technology(Natural Science Edition), 2011, 27(2) |
| |
| Authors: | XIAO Hai-rong |
| |
| Affiliation: | XIAO Hai-rong(Department of Computer Sciences & Technology,Shaanxi University of Technology,Hanzhong 723001,China) |
| |
| Abstract: | Normalization theory of relational database is an important means in judging the logical design of database.By taking database design of Books Ordering System as an example,the problem of database design is sloved step by step,and relation schema can meet the higher requirements of normal form.At the same time,Denormalization theory is analyzed in database design application in view of actual circumstances.The case results indicate that the lower of the level of normal form,the better of performance of data... |
| |
| Keywords: | relation schema normalization normal form denormalization books ordering system |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
