Design of data storage scheme for coal mine personnel precise positioning system
ZHANG Peng
为了满足基于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.
personnel precise positioning system;data storage scheme;hybrid storage architecture;data encryption;data access interface;data exchange
主办单位:煤炭科学研究总院有限公司 中国煤炭学会学术期刊工作委员会