Data Exchange Solution for Seismic Precursory Observation Data
China seismic precursory network consists of more than 800 precursory monitoring stations and over 30 Oracle database nodes, and it is responsible for collecting, transferring and monitoring the seismic precursory data. There are several approaches to exchange data among database nodes, but they are mostly adapt to two Oracle database nodes and difficult to manage for the usage of database link (DBlink) technology. In this paper, we introduced a novel data exchange solution for seismic precursory observation data using user-defined update operation logs. While an update operation (insert, delete or update) triggers, the relative information of it will be recorded into the update log table. We detail the update log table schemer, exchange task structure and three phase of an exchange task: export, transfer and import phases. This solution is an effective, manageable, flexible solution for exchange of seismic precursory observation data.
KeywordsSeismic Precursory Observation Data Earthquake Data Exchange Data Replication Oracle Database
Unable to display preview. Download preview PDF.
- 1.Chen, J.: Earthquake Disaster Reduction in Developing China. In: The 14th World Conference on Earthquake Engineering, Beijing (2008)Google Scholar
- 2.Guan, D.: Research and Implementation of Database Backup and Disaster Recovery Based on Oracle Streams. M.S. thesis. Chengdu University of Technology, Chengdu, China (2008)Google Scholar
- 3.Sheard, N.C., et al.: Data Exchange System and Method. U.S. Patent 6,453,356 B1 (September 17, 2002)Google Scholar
- 4.Emmanuel, C., George, C., Anastasia, A.: Middleware-based database replication: The gaps between theory and practice. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 739–752. Association for Computing Machinery, Vancouver (2008)Google Scholar
- 6.Orafaq 2011. Advanced Replication FAQ, http://www.orafaq.com/wiki/Advanced_Replication_FAQ (accessed: February 10, 2012)
- 7.Orafaq 2010. Oracle Streams, http://www.orafaq.com/wiki/Oracle_Streams (accessed: February 10, 2012)
- 8.Liu, G., Teng, Y., Wang, C., Tang, W.: Oracle Replication and Its Application in Earthquake Precursor Metadata Exhcange. Earthquake Research in China 24(2), 142–149 (2008)Google Scholar
- 9.Zhou, X.: Research and Implement of Data Synchronous Replication Using Oracle Materialized Views. China Hi-Tech Enterprises (15), 69–70 (2010)Google Scholar
- 10.Huang, X., Chen, L., Wei, W., Xu, S.: Data Synchronous Method Based on Snapshot Log Analysis. Journal of Logistical Engineering University 22(2), 59–62, 67 (2006)Google Scholar
- 11.Wong, L., Arora Nimar, S., Gao, L., Hoang, T., Wu, J.: Oracle streams: A high performance implementation for near real time asynchronous replication. In: Proceeding of 25th IEEE International Conference on Data Engineering, pp. 1363–1374 (2009)Google Scholar