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

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.