数据库优化在海量数据下的研究与应用  

Research and application of database optimization in the massive data

作　　者：岑巍 

机构地区：[1]浦发银行,上海200042

出　　处：《计算机时代》2015年第2期33-35,共3页Computer Era

摘　　要：基于云计算技术和海量数据的支撑,对数据库进行多方面的调整和优化能够最大程度地提高数据库系统的运行效率,降低系统运行的资源消耗,使得海量数据的响应效率大幅提高。以Oracle数据库为例,分析了影响数据库性能的各方面因素和数据库优化应遵循的方法,就数据库优化技术方法进行了探讨。通过数据库实施该优化方案前后的性能对比,得到数据库在运用此方法进行优化后性能明显提升的结果,这表明该方法有一定的使用价值。Based on cloud computing and mass data, the database is adjusted and optimized. The system operation efficiency has been improved to the maximal extent. The consumption of resource is lowered to increase the response efficiency of large amount data. Taking the Oracle database as an example, various factors which affect the database performance and methods which should be observed for optimization of the database are analyzed. The database optimization methods are discussed. Comparing performances before and after the optimization schemes, it is concluded that the performance is improved significantly, showing that the method has certain use value.

关 键 词：ORACLE 数据库优化 CPU的优化 SQL语句优化 

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