Abstract
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.
This work is supported by the Teacher Research Fund of China Earthquake Administration (No. 20110110) and Youth Science Fund for Disaster Prevention and Reduction (No. 200905).
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Chen, J.: Earthquake Disaster Reduction in Developing China. In: The 14th World Conference on Earthquake Engineering, Beijing (2008)
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)
Sheard, N.C., et al.: Data Exchange System and Method. U.S. Patent 6,453,356 B1 (September 17, 2002)
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)
Wang, Z.: Research on the application of oracle advanced replication of distributed database. Journal of East China Jiaotong University 22(5), 115–117 (2005)
Orafaq 2011. Advanced Replication FAQ, http://www.orafaq.com/wiki/Advanced_Replication_FAQ (accessed: February 10, 2012)
Orafaq 2010. Oracle Streams, http://www.orafaq.com/wiki/Oracle_Streams (accessed: February 10, 2012)
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)
Zhou, X.: Research and Implement of Data Synchronous Replication Using Oracle Materialized Views. China Hi-Tech Enterprises (15), 69–70 (2010)
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)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag GmbH Berlin Heidelberg
About this paper
Cite this paper
Shan, W., Li, J., Liu, Q., Zhang, B. (2012). Data Exchange Solution for Seismic Precursory Observation Data. In: Jin, D., Lin, S. (eds) Advances in Computer Science and Information Engineering. Advances in Intelligent and Soft Computing, vol 169. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-30223-7_32
Download citation
DOI: https://doi.org/10.1007/978-3-642-30223-7_32
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-30222-0
Online ISBN: 978-3-642-30223-7
eBook Packages: EngineeringEngineering (R0)