| ERP环境下关系数据库的性能优化策略 |
| |
| 引用本文： | 杜亚维,范孝民.ERP环境下关系数据库的性能优化策略[J].华北水利水电学院学报,2006,27(1):83-85. |
| |
| 作者姓名： | 杜亚维 范孝民 |
| |
| 作者单位： | 华北电力大学机械工程学院,河北,保定,071003;承德供电公司客服中心,河北,承德,067000 |
| |
| 摘 要： | 企业信息化过程需要大型关系数据库的支撑,针对数据库的性能优化问题,从关系数据库的规范化、查询优化和节省存储空间3个方面介绍了相关的优化策略,对相关研究有一定的指导作用.
|
| 关 键 词： | 企业资源计划 关系数据库 规范化 性能优化 |
| 文章编号： | 1002-5634（2006）01-0083-03 |
| 收稿时间： | 2005-06-30 |
| 修稿时间： | 2005-08-13 |
The Optimization of Relational Database's Property under ERP Environment |
| |
| DU Ya-wei,FAN Xiao-min.The Optimization of Relational Database's Property under ERP Environment[J].Journal of North China Institute of Water Conservancy and Hydroelectric Power,2006,27(1):83-85. |
| |
| Authors: | DU Ya-wei FAN Xiao-min |
| |
| Affiliation: | 1. School of Mechanical Engineering, North China Electric Power University, Baoding 071003, China; 2. Center of Services, Power Supply Company, Chengde 067000, China |
| |
| Abstract: | Enterprise′s informational construction needs the support of large-scale database.But enterprise often neglects the optimization of database′s property at the beginning of the implementation.With the growth of data quantity after the system is operated,the capability of the database will generally influence the normal work of the system and even lead to system paralysis when being serious.The strategies of optimizing database′s property are introduced from three aspects: the normalization of relational database,the optimization of query language and the save of storage space.Certain directive significance is believed to the developer of ERP and such informational administrative staff of the enterprises. |
| |
| Keywords: | ERP relational database normalization capability optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
