|本期目录/Table of Contents|

[1]王建军,赵银刚,刘高川.地震前兆Oracle LOB数据压缩与交换及其访问效率研究*[J].地震研究,2019,42(03):447-453.
 WANG Jianjun,ZHAO Yingang,LIU Gaochuan.Research on Compression,Exchange and Access Efficiency of Seismic Precursor Oracle LOB data[J].Journal of Seismological Research,2019,42(03):447-453.
点击复制

地震前兆Oracle LOB数据压缩与交换及其访问效率研究*(PDF/HTML)

《地震研究》[ISSN:1000-0666/CN:53-1062/P]

卷:
42
期数:
2019年03期
页码:
447-453
栏目:
出版日期:
2019-07-24

文章信息/Info

Title:
Research on Compression,Exchange and Access Efficiency of Seismic Precursor Oracle LOB data
作者:
王建军1赵银刚2刘高川3
(1.甘肃省地震局,甘肃 兰州 730000; 2.安丘地震台,山东 潍坊 262100; 3.中国地震台网中心,北京 100045)
Author(s):
WANG Jianjun1ZHAO Yingang2LIU Gaochuan3
(1.Gansu Earthquake Agnecy,Lanzhou 73000,Gansu,China)(2.Anqiu Earthquake Station,Weifang 262100,Shandong,China)(3.China Earthquake Networks Center,Beijing 100045,China)
关键词:
Oracle LOB 数据压缩 交换效率 访问效率
Keywords:
-
分类号:
P315.73
DOI:
-
摘要:
针对目前地震前兆Oracle数据库存在的存储空间大、交换速度慢、读写速度慢等问题,分别用Bzip2,Gzip,GzipIO这3种压缩算法对Clob和Blob的压缩和未压缩数据进行读写和交换速度测试,使用直接读取、分段读取、分段+线程池读取3种方法进行了读库速度测试。结果表明:①无论在存储、交换还是读写速度方面Blob均优于Clob; ②Blob+Gzip为地震前兆分秒数据的“最佳”存储结构,读写和交换速度有大幅度提升,数据库整体容量降至目前的7%(或更少),秒数据的交换速率至少是目前的7.89倍; ③最简单且被软件开发者广泛使用的直接读取方法读库效率较差,分段+线程池技术无论在Clob还是Blob、压缩还是未压缩时都表现出较高的读库效率,给LOB数据读取速度带来飞跃式的提升。
Abstract:
Aiming at the problems of huge storage space,low exchange speed and low read-write speed of the current seismic precursor Oracle database,the read-write speed and exchange speed tests are performed on the compressed and uncompressed Clob and Blob data by three compression algorithms,including Bzip2,Gzip and GzipIO.The reading speed test is performed by the direct reading,substr reading,and substr+threadPool reading techniques.The results show that:①Blob is superior to Clob in terms of storage,exchange,or read-write speed; ②For the seismic precursor database,Blob+Gzip is the optimal storage structure of the minute and second data.The read-write speed is greatly improved,and the overall capacity of the database is reduced to 7%(or less).The exchange rate of the second data is at least 7.89 times of the present rate; ③The simplest and most widely used direct reading method by software developers has poor database read efficiency,while the substr+threadPool technique shows higher database reading efficiency no matter for Clob or Blob,for compressed or uncompressed,which brings a leap-forward improvement in the read speed of LOB data.

参考文献/References:

-

备注/Memo

备注/Memo:
收稿日期:2018-10-24
基金项目:中国地震局地震科技“星火计划”专项(XH17038)和甘肃省地震局基本科研专项(2013IESLZ02)联合资助.
通讯作者:赵银刚(1979-),工程师,研究方向为地震监测与软件研发.E-mail:40857347@qq.com

更新日期/Last Update: 2019-07-24