煤矿人员精确定位系统数据存储方案设计  

Design of data storage scheme for coal mine personnel precise positioning system

作　　者：张鹏 ZHANG Peng(Ningxia Tiandi Benniu Industrial Group Co.,Ltd.,Shizuishan 753000,China)

机构地区：[1]宁夏天地奔牛实业集团有限公司,宁夏石嘴山753000

出　　处：《煤矿安全》2024年第8期227-233,共7页Safety in Coal Mines

摘　　要：为了满足基于UWB等新型定位技术的煤矿人员精确定位系统数据存储与访问需要,分析了人员精确定位系统的数据结构、操作频率、数据量及存储占用空间大小等的数据情况,总结了系统数据生成与使用的主要特征,提出了基于Redis、MySQL和文件分别存储热数据、温数据和冷数据的混合数据存储架构,并详细阐述了Redis、MySQL、文件的存储关键设计,以及数据加密和基于Web API数据交互服务的数据查询方法。模拟数据测试结果表明:该存储方案具有较高的数据访问效率,能够满足数据存储与业务功能数据查询需要。In order to meet the data storage and access needs of coal mine personnel precise positioning system based on new positioning technologies such as UWB,the data structure,sampling frequency,data volume and storage space occupied by the personnel precise positioning system are analyzed,and the main features for system data generation and use are summarized,a hybrid data storage architecture based on Redis,MySQL and files to respectively store hot data,warm data and cold data is proposed,and the key design of Redis,MySQL,file storage,data encryption and data query method based on Web API data interaction service are described in detail.By using simulated data testing,it was verified that the storage solution has high data access efficiency,can meet the needs of data storage and business function data query.

关 键 词：人员精确定位系统 数据存储方案 混合存储架构 数据加密 数据访问接口 数据交换 

分 类 号：TD672[矿业工程—矿山机电]