【摘要】 利用硬件设备、网络、存储、系统架构等高可用环境升级的技术手段,并采用Oracle数据库参数调整、索引添加、分区等方法对集成数据库进行性能调优。测试结果表明,优化后的集成观测数据库性能得到有效的提升。同时,通过SQL语句解析的深入分析,对业务应用软件的设计开发提出SQL语句优化和实时波形存储方式改变的修改建议。更多还原

【Abstract】 Using technical means of available service environment upgrading,such as the hardware equipment,network,storage,system architecture etc.,we do the performance tuning on the integrated database by the methods of adjustment,adding index and partition etc. of Oracle database parameter. The test result showthat the performance of integrated observation database improved efficiently after optimization. Through the in-depth analysis of SQL statement parsing,we put forward modification proposals to optimize SQL statements and change waveform storage method in real time for the design and development of business application software更多还原