ORACLE高级队列在地震前兆数据传输中的应用研究
|
摘要
准确及时地获取地震前兆数据是开展地震短临预报和科学研究的重要基础。文中在详尽分析Oracle高级队列技术原理的基础上,给出了数据传输模型;分析了地震前兆数据的特点和传输要求;对比了已有的数据传输手段,如高级复制、E-mail,FTP等。通过PL/SQL语言编程实现了运用Oracle高级队列技术传输地震前兆数据的实例,认为利用Oracle高级队列技术进行地震数据传输是完全可行的,非常适合在地震业务处理系统中使用,为“十五”“中国地震信息服务系统”项目建设提供了一种新的数据传输手段。
As far as the seismological research is based on observation, huge seismic precursor data are produced at earthquake stations. It is vital to send them precisely and betimes. During the period of the Ninth Five-Year Project of China Seismological Bureau, several methods were applied to transmitting seismic precursor data, such as advanced replication, FTP, E-mail and etc. The advanced replication is used more extensively than others. But data are often lost by advanced replication. So a new transmission method has to be found to meet the need. This paper presents the advanced queuing method for transmitting seismic precursor data. Advanced queuing has a unique database-integrated message queuing feature built on the Oracle Streams information integration infrastructure. With Advanced Queuing, message queuing operations can be performed in the way similar to SQL operations from the Oracle database. Message queuing functionality allows applications of Oracle database to communicate asynchronously via messages in AQ queues. With the development in seismic precursor observation in China, more knowledge on the characteristics of seismic precursor data has been gained, for instance the data sources are complex, the data structure is diversified, the data sampling rate is not consistent. In order to transmit seismologic precursor data, a standard data structure needs to be created. The transmission is either point to point or point to multi-points. The system is programmed by PL/SQL. Both the sending host and the receiving one are installed with Oracle9i version. The result shows that it can transmit seismic precursor data from earthquake station to provincial center safely and reliably by using advanced queuing. It also has additional advantages compared with before. Firstly, it can assign priority to data, and then transmit the urgent data of higher priority; Secondly, it is easy to manage the advance queue with Oracle Enterprise Manager. But the network bandwidth is still the bottleneck of the transmission.
As far as the seismological research is based on observation, huge seismic precursor data are produced at earthquake stations. It is vital to send them precisely and betimes. During the period of the Ninth Five-Year Project of China Seismological Bureau, several methods were applied to transmitting seismic precursor data, such as advanced replication, FTP, E-mail and etc. The advanced replication is used more extensively than others. But data are often lost by advanced replication. So a new transmission method has to be found to meet the need. This paper presents the advanced queuing method for transmitting seismic precursor data. Advanced queuing has a unique database-integrated message queuing feature built on the Oracle Streams information integration infrastructure. With Advanced Queuing, message queuing operations can be performed in the way similar to SQL operations from the Oracle database. Message queuing functionality allows applications of Oracle database to communicate asynchronously via messages in AQ queues. With the development in seismic precursor observation in China, more knowledge on the characteristics of seismic precursor data has been gained, for instance the data sources are complex, the data structure is diversified, the data sampling rate is not consistent. In order to transmit seismologic precursor data, a standard data structure needs to be created. The transmission is either point to point or point to multi-points. The system is programmed by PL/SQL. Both the sending host and the receiving one are installed with Oracle9i version. The result shows that it can transmit seismic precursor data from earthquake station to provincial center safely and reliably by using advanced queuing. It also has additional advantages compared with before. Firstly, it can assign priority to data, and then transmit the urgent data of higher priority; Secondly, it is easy to manage the advance queue with Oracle Enterprise Manager. But the network bandwidth is still the bottleneck of the transmission.
引文
曹凤娟,谷光裕,牛峰,等.2000.地震前兆数据传输与处理系统的建立[J].东北地震研究,16(1):49—53.CAOFeng juan,GUGuang yu,NIUFeng,etal.2000.Establishmentofearthquakeforewarningdatatransmissionand processingsystem[J].SeismologicalResearchofNortheastChina,16(1):49—53(inChinese).
陈彩虹,王启动,郑黎辉,等.2003.福建省地震局FTP服务器的建设与管理[J].福建地震,19(3):19—21.CHENCai hong,WANGQi dong,ZHENGLi hui,etal.2003.ThestructureandmanagementofFTPSERVER[J].Fu jianSeismology,19(3):19—21(inChinese).
葛冬霞.1999.消息队列中间件及其应用[J].高性能计算技术,8:58—60.GEDong xia.1999.Messagequeuingmiddlewareanditsapplication[J].HighPerformanceComputingTechnology,8:58—60(inChinese).
李圣强,米宏亮,杨满栋,等.2002.MSSQLSERVER复制技术在地震前兆数据集成中的应用[J].地震学刊,22(1):53—57.LISheng qiang,MIHong liang,YANGMan dong,etal.2002.TheApplicationofMSSQLSERVERcopyingtechnique inearthquakeprecursorydataintegration[J].JournalofSeismology,22(1):53—57(inChinese).
李圣强,杨满栋,米宏亮,等.2001.地震前兆数据的管理与服务[J].地震,21(4):29—34.LISheng qiang,YANGMan dong,MIHong liang,etal.2001.Managementandserviceofseismicprecursorydata[J]Earthquake,21(4):29—34(inChinese).
刘春国,赵红丽,谷元珠,等.2002.中国地震地下水流体学科中心的技术系统[J].地震地质,24(3):432—434.LIUChun guo,ZHAOHong li,GUYuan zhu,etal.2002.Technicalsystemofresearchcenterofearthquake related subsurfacefliudsinChina[J].SeismologyandGeology,24(3):432—434(inChinese).
米宏亮,李圣强,杨满栋,等.2001.基于WindowsNT服务器的前兆数据共享与实现[J].地震,21(4):112—117.MIHong liang,LISheng qiang,YANGMan dong,etal.2001.Precursorydatasharingserviceandrealizationbasedon WindowsNTServer[J].Earthquake,21(4):112—117(inChinese).
魏德虹,范世宏.2004.数字化地震前兆数据的管理技术和有关部门问题[J].地震地磁观测与研究,25(1):105—110.WEIDe hong,FANShi hong.2004.Managementtechnologyofdigitaldataforearthquakeprecursoryandrelevantques tions[J].SeismologicalandGeomagneticObservationandResearch,25(1):105—110.
张国民,傅佂祥,桂燮泰,等.2001.地震预报引论[M].北京:科学出版社.334—365.ZHANGGuo min,FUZheng xiang,GUIXie tai,etal.2001.EarthquakePrediction[M].SciencePress,Beijing.334—365(inChinese).
周丹,张杰,杨芳南.2004.综合网管系统中消息队列技术的研究和设计[J].计算机应用,24(6):348—351.ZHOUDan,ZHANGJie,YANGFang nan.2004.Researchanddesignofmessagequeueonnetworksmanagement[J].ComputerApplications,24(6):348—351(inChinese).
周克昌,赵仲何,陈会忠,等.1999.利用数据库系统进行地震数据管理和共享服务[J].地震地磁研究与观测,20(4):63—67.ZHOUKe chang,ZHAOZhong he,CHENHui zhong,etal.1999.Managementandsharingofseismicdatathroughda tabasesystem[J].SeismologiaclandGeomagneticObservationandResearch,20(4):63—67(inChinese).
陈彩虹,王启动,郑黎辉,等.2003.福建省地震局FTP服务器的建设与管理[J].福建地震,19(3):19—21.CHENCai hong,WANGQi dong,ZHENGLi hui,etal.2003.ThestructureandmanagementofFTPSERVER[J].Fu jianSeismology,19(3):19—21(inChinese).
葛冬霞.1999.消息队列中间件及其应用[J].高性能计算技术,8:58—60.GEDong xia.1999.Messagequeuingmiddlewareanditsapplication[J].HighPerformanceComputingTechnology,8:58—60(inChinese).
李圣强,米宏亮,杨满栋,等.2002.MSSQLSERVER复制技术在地震前兆数据集成中的应用[J].地震学刊,22(1):53—57.LISheng qiang,MIHong liang,YANGMan dong,etal.2002.TheApplicationofMSSQLSERVERcopyingtechnique inearthquakeprecursorydataintegration[J].JournalofSeismology,22(1):53—57(inChinese).
李圣强,杨满栋,米宏亮,等.2001.地震前兆数据的管理与服务[J].地震,21(4):29—34.LISheng qiang,YANGMan dong,MIHong liang,etal.2001.Managementandserviceofseismicprecursorydata[J]Earthquake,21(4):29—34(inChinese).
刘春国,赵红丽,谷元珠,等.2002.中国地震地下水流体学科中心的技术系统[J].地震地质,24(3):432—434.LIUChun guo,ZHAOHong li,GUYuan zhu,etal.2002.Technicalsystemofresearchcenterofearthquake related subsurfacefliudsinChina[J].SeismologyandGeology,24(3):432—434(inChinese).
米宏亮,李圣强,杨满栋,等.2001.基于WindowsNT服务器的前兆数据共享与实现[J].地震,21(4):112—117.MIHong liang,LISheng qiang,YANGMan dong,etal.2001.Precursorydatasharingserviceandrealizationbasedon WindowsNTServer[J].Earthquake,21(4):112—117(inChinese).
魏德虹,范世宏.2004.数字化地震前兆数据的管理技术和有关部门问题[J].地震地磁观测与研究,25(1):105—110.WEIDe hong,FANShi hong.2004.Managementtechnologyofdigitaldataforearthquakeprecursoryandrelevantques tions[J].SeismologicalandGeomagneticObservationandResearch,25(1):105—110.
张国民,傅佂祥,桂燮泰,等.2001.地震预报引论[M].北京:科学出版社.334—365.ZHANGGuo min,FUZheng xiang,GUIXie tai,etal.2001.EarthquakePrediction[M].SciencePress,Beijing.334—365(inChinese).
周丹,张杰,杨芳南.2004.综合网管系统中消息队列技术的研究和设计[J].计算机应用,24(6):348—351.ZHOUDan,ZHANGJie,YANGFang nan.2004.Researchanddesignofmessagequeueonnetworksmanagement[J].ComputerApplications,24(6):348—351(inChinese).
周克昌,赵仲何,陈会忠,等.1999.利用数据库系统进行地震数据管理和共享服务[J].地震地磁研究与观测,20(4):63—67.ZHOUKe chang,ZHAOZhong he,CHENHui zhong,etal.1999.Managementandsharingofseismicdatathroughda tabasesystem[J].SeismologiaclandGeomagneticObservationandResearch,20(4):63—67(inChinese).
版权所有：© 2023 中国地质图书馆 中国地质调查局地学文献中心