[1]CHEN Xiaolin,LI Shengle,LIU Jian,et al.Application of Distributed Database Greenplum in Earthquake Precursor Data Storage[J].Journal of Seismological Research,2020,43(02):412-416.
Copy
Journal of Seismological Research[ISSN 1000-0666/CN 53-1062/P] Volume:
43
Number of periods:
2020 02
Page number:
412-416
Column:
Public date:
2020-06-10
- Title:
-
Application of Distributed Database Greenplum in Earthquake Precursor Data Storage
- Author(s):
-
CHEN Xiaolin; LI Shengle; LIU Jian; LIU Zhumei
-
(Key Laboratory of Earthquake Geodesy,Institute of Seismology,China Earthquake Administration,Wuhan 430071,Hubei,China)
-
- Keywords:
-
-
- CLC:
-
P315-39
- DOI:
-
-
- Abstract:
-
With the encryption of precursor observation networks and the improvement of sampling rate,the quantity of earthquake precursor observation data increases rapidly.It is a higher requirement for the data processing ability of the precursor database in the seismic data sharing service that how to make users quickly obtain large data sets.Aiming at this problem,the Greenplum-based precursor data storage method is proposed.Through setting up the Greenplum distributed database environment,the rapid processing of massive precursor data is realized.Performance testing experiments of precursor data show that the Greenplum database takes less time to read the precursor data,and the advantages of Greenplum database are more obvious for large-volume data operations,compared with the traditional Oracle11g database.In addition,the good extensibility of Greenplum database and the support of application interface(JDBC,ODBC)make its promising application in precursor data analysis and processing.