大型关系数据库性能优化研究概述  

Overview of Performance Optimization Research on Large-scale Relational Database

作　　者：张金波[1] 徐晖[1] 魏理豪[1] 肖建毅[1] 

机构地区：[1]广东省电力试验研究所,广州510600

出　　处：《广东电力》2007年第5期31-33,43,共4页Guangdong Electric Power

摘　　要：随着广东电网公司信息化建设的发展,大型关系数据库得到了十分广泛的应用,但业务运行所必需的数据库性能优化水平却显得相对滞后,体现为:硬件配置较高而性能水平低下,性能随着业务数据量的增长而急剧下降等。目前,针对大型数据库的性能优化专题技术研究虽然很多,但缺乏专门针对电网公司应用系统的数据库性能优化研究。为此,以广东电网公司内的信息系统为研究对象,对大型关系数据库的性能优化问题做了全面深入的研究,并给出了成功的实施案例,最后对广东电网公司应用系统的数据库性能优化提出了规范化的建议。The large-scale relational database is widely used in information system with the development of informatization in Guangdong Power Grid Corporation （GPG）, but the database performance optimization skill is not enough to ensure the transaction running, for example the high hardware configuration with low performance and system slowing with data growth, and so on. Presently, there are already many research works about the performance optimization of large-scale relational database, but no such research works aim at power grid corporation system. The paper does general and deep research on performance optimization of large-scale relational database on the basis of the information system in GPG, and shows a successful implementation example. At last, the standardization suggestion is given for the application system performance optimization in GPG.

关 键 词：关系数据库 性能优化 ORACLE数据库 SQL语句 优化设计 系统全局区(SGA) 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]