地震观测集成数据库的优化研究  

Research on Optimization of Earthquake Observation Integrated Database

作　　者：丁睿[1] 

机构地区：[1]上海市地震局,上海200062

出　　处：《地震研究》2014年第4期654-659,670,共6页Journal of Seismological Research

基　　金：地震科技星火计划项目-地震业务集成数据库自动监控;管理和优化研究(XH12018Y)资助

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

关 键 词：地震观测集成数据库 高可用环境 数据库优化 SQL优化 

分 类 号：P315.3[天文地球—地震学]