基于Sync Framework的矿用防爆手机数据同步技术研究与应用  

RESEARCH AND APPLICATION OF MINE EXPLOSION PROOF MOBILE PHONE DATA SYNCHRONIZATION TECHNOLOGY BASED ON SYNC FRAMEWORK

作　　者：李明建[1,2] 

机构地区：[1]瓦斯灾害监控与应急技术国家重点实验室,重庆400037 [2]中煤科工集团重庆研究院有限公司,重庆400037

出　　处：《计算机应用与软件》2018年第2期74-79,166,共7页Computer Applications and Software

基　　金：国家重点研发计划项目(2016YFC0801407);重庆市科技创新领军人才支持计划项目(CSTCKJCX-LJRC14);中煤科工集团有限公司科技创新基金项目(2013ZD002)

摘　　要：煤矿瓦斯灾害监控预警系统不仅需要采集在线的安全监控信息,而且需要采集井下离线的检测、观测信息,防治煤与瓦斯突出所使用的日常预测、观测信息是瓦斯灾害监控预警重要的数据来源之一。为解决煤矿井下基于Android防爆手机的防突信息采集App与地面基于SQL Server的防突动态信息数据库间双向同步问题,提出一种基于Sync Framework的SQLite与SQL Server数据库慢同步方案,实现了防突信息采集App与防突动态信息数据库按需双向同步,并在河南能源集团演马庄矿进行了现场实验,取得了较好的应用效果。该方案实现了数据同步模块与具体业务数据库及业务管理系统解耦,因此可推广至防爆手机乃至普通Android手机App与SQL Server数据库同步,具有较高的工程研究和应用价值。Coal mine gas disaster monitoring and early warning system not only needs to collect online safety monitoring information,but also need to collect underground detection and observation information. Daily forecast for the prevention and control of coal and gas outburst observation information is one of the important data sources for monitoring and early warning of gas disasters. In order to solve the coal mine explosion proof outburst of Android mobile phone information collection App and ground process dynamic information database synchronization problem between two anti SQL Server based on Sync Framework,this paper proposed a slow synchronization scheme between SQLite databases and SQL Server databases based on Sync Framework. The scheme realized the bidirectional synchronization of anti-sudden information collection App and anti-outburst dynamic information database on-demand and realized on-site test in Henan Energy Group Yanmazhuang Mine and achieved good application effect. The scheme realized the decoupling of the data synchronization module,the specific service database and business management system,therefore it could be popularized to the explosion-proof mobile phone and even the ordinary Android mobile phone App synchronized with the SQL Server database,and had high engineering research and application value.

关 键 词：瓦斯灾害 监控预警系统 防爆手机 Android数据同步 SyncFramework 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]