[1]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.
Copy
Research on Compression,Exchange and Access Efficiency of Seismic Precursor Oracle LOB data
Journal of Seismological Research[ISSN 1000-0666/CN 53-1062/P] Volume:
42
Number of periods:
2019 03
Page number:
447-453
Column:
Public date:
2019-07-24
- Title:
- Research on Compression,Exchange and Access Efficiency of Seismic Precursor Oracle LOB data
- Keywords:
- -
- CLC:
- P315.73
- DOI:
- -
- 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:
- -
- Similar References:
Memo
-
Last Update:
2019-07-24