基于SSM的智能仪器云平台异库数据协同检索机制研究  

Research on collaborative retrieval mechanism of different database data of intelligent instrument cloud platform based on SSM

作　　者：李源 高建军[1] 王猛[1] 郝浩宇 任林彬 LI Yuan;GAO Jianjun;WANG Meng;HAO Haoyu;REN Linbin(China University of Geosciences(Beijing)School of Geophysics and Information Technology,Beijing 100083,China)

机构地区：[1]中国地质大学(北京)地球物理与信息技术学院,北京100083

出　　处：《物探化探计算技术》2022年第5期665-670,共6页Computing Techniques For Geophysical and Geochemical Exploration

基　　金：国家重点研发计划课题(2019YFC0312004);国家自然科学基金(41874142);中央高校基本科研业务费专项资金资助项目(2-9-2018-268)。

摘　　要：随着物联网技术的高速发展,地球物理仪器上位机软件也随着仪器种类的增多呈现出多样化趋势。为解决上位机软件研发过程中的仪器数据集中管理和检索问题,以开发智能地球物理仪器云平台为目的,进行数据库结构的分析和设计。在数据结构设计中,基于SSM环境使用MySQL和MongoDB,实现了双数据库同步检索信息机制。该机制对云平台用户信息、仪器状态信息等持久化的数据,使用MySQL数据库进行数据检索。对仪器采集数据的检索,则使用MongoDB进行分离检索,并利用文档分片的方式进行存储,在单数据库的基础上提高了检索效率和集群扩展性。经过数据的检索测试,验证了同步检索机制的有效性,该方法也为今后智能仪器集中管理软件数据库的设计和开发提供了技术方案。With the rapid development of internet of things technology,the upper computer software of geophysical instruments shows a diversification trend with the increase of instrument types.In order to solve the problem of centralized management and retrieval of instrument data,this paper analyzes and designs the database structure for the purpose of developing intelligent geophysical instrument cloud platform.In the data structure design,based on the SSM environment,this paper uses MySQL and MongoDB to realize the dual database synchronization information retrieval mechanism.This mechanism uses MySQL database to retrieve persistent data such as cloud platform user information and instrument state information.For the retrieval of data collected by instruments,MongoDB is used for separate retrieval,and the document fragmentation is used for storage.This improves the retrieval efficiency and cluster scalability on the basis of single database.Through the data retrieval test,the effectiveness of the synchronous retrieval mechanism is verified.The method presented in this paper also provides a technical scheme for the design and development of intelligent instrument centralized management software database in the future.

关 键 词：智能地球物理仪器 异库同步数据检索机制 SSM MYSQL数据库 MongoDB数据库 

分 类 号：P631[天文地球—地质矿产勘探]