煤矿人员精确定位系统数据存储方案设计OA北大核心CSTPCD
Design of data storage scheme for coal mine personnel precise positioning system
为了满足基于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 posi-tioning 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 stor-age 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 de-scribed 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.
张鹏
宁夏天地奔牛实业集团有限公司,宁夏 石嘴山 753000
矿山工程
人员精确定位系统数据存储方案混合存储架构数据加密数据访问接口数据交换
personnel precise positioning systemdata storage schemehybrid storage architecturedata encryptiondata access interfacedata exchange
《煤矿安全》 2024 (008)
227-233 / 7
评论