中国煤炭特性数据库信息系统性能优化策略  

Systematic Function Optimizing and Realization in Coal Quality Database of China

作　　者：郝伟[1] 曹代勇[1] 彭宏钊[1] 禹蒲阳[2] 

机构地区：[1]中国矿业大学煤炭资源与安全开采国家重点实验室,北京100083 [2]湖南科技大学知识网格实验室,湖南湘潭411201

出　　处：《湖南科技大学学报（自然科学版）》2007年第2期85-89,共5页Journal of Hunan University of Science And Technology：Natural Science Edition

基　　金：教育部科技基础条件平台项目(505011)

摘　　要：从中国煤炭特性数据库信息系统的自身特点出发,总结了目前Oracle9i数据库和C#语言的优化方法,主要包括数据库的结构优化、数据库的性能优化、数据库访问方式的最优选择以及在系统中SQL语句和C#代码的优化.重点阐述了在数据库设计阶段如何避免竞争和如何优化数据库的访问方式,在系统运行阶段如何从应用程序和数据库方面进行调整,以达到本系统性能的最优.将上述优化方法用于该系统中,通过理论分析和实例计算证明了该方法使得本系统的后台数据库的性能在硬件系统一定的情况下达到了最优,也使本信息系统拥有良好的系统稳定性和系统的高效性.图2,表2,参8.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 effieieney.2figs., 2tabs., grefs.

关 键 词：中国煤炭特性数据库 ORACLE 9i 性能优化 系统稳定性 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]