| 中国煤炭特性数据库信息系统性能优化策略 |
| |
| 引用本文： | 郝伟,曹代勇,彭宏钊,禹蒲阳. 中国煤炭特性数据库信息系统性能优化策略[J]. 湖南科技大学学报(自然科学版), 2007, 22(2): 85-89 |
| |
| 作者姓名： | 郝伟 曹代勇 彭宏钊 禹蒲阳 |
| |
| 作者单位： | 1. 中国矿业大学,煤炭资源与安全开采国家重点实验室,北京,100083
2. 湖南科技大学,知识网格实验室,湖南,湘潭,411201 |
| |
| 基金项目： | 教育部科技基础条件平台建设项目 |
| |
| 摘 要： | 从中国煤炭特性数据库信息系统的自身特点出发,总结了目前Oracle 9i数据库和C#语言的优化方法,主要包括数靠据库的结构优化、数据库的性能优化、数据库访问方式的最优选择以及在系统中SQL语句和C#代码的优化.重点阐述了在数据库设计阶段如何避免竞争和如何优化数据库的访问方式,在系统运行阶段如何从应用程序和数据库方面进行调整,以达到本系统性能的最优.将上述优化方法用于该系统中,通过理论分析和实例计算证明了该方法使得本系统的后台数据库的性能在硬件系统一定的情况下达到了最优,也使本信息系统拥有良好的系统稳定性和系统的高效性.图2,表2,参8.
|
| 关 键 词： | 中国煤炭特性数据库 性能优化 系统稳定性 |
| 文章编号： | 1672-9102（2007）02-0085-05 |
| 收稿时间： | 2006-09-12 |
| 修稿时间： | 2006-09-12 |
Systematic Function Optimizing and Realization in Coal Quality Database of China |
| |
| HAO Wei,CAO Dai-yong,PENG Hong-zhao,YU Pu-yang. Systematic Function Optimizing and Realization in Coal Quality Database of China[J]. Journal of Hunan University of Science & Technology(Natural Science Editon), 2007, 22(2): 85-89 |
| |
| Authors: | HAO Wei CAO Dai-yong PENG Hong-zhao YU Pu-yang |
| |
| Affiliation: | 1.State Key laboratory of Coal Resources and Safe Exploitation, China University of Mining and Technology, Beijing 100083, China; 2 Knowledge Grid Laboratory, HuMan University of Science and Technolog, |
| |
| Abstract: | The optimizing method of the currently Oracle database and C# language are generalized,which is included framework of database optimizing, function of database optimizing, access mechanism of database optimizing and SQL statement and C# code optimizing, Some technology were presented that about optimizing database: how to avoid the competition and how to optimize the data access on database design phase; how to adjust memory and I/O from operating system and instance rank of the database in information system run phase. According to own characteristics of Coal Quality Database of China, the all kinds of optimizing methods were used in this system. The correctness of this method was proved by the theoretical analysis and practical example. The function of background database in this system was optimized when hardware system was given. This information system has a good stability and efficiency.2figs.,2tabs.,8refs. |
| |
| Keywords: | Oracle 9i |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
