张翼,于林,卢向明. 煤矿安全监控系统数据加密存储方案设计[J]. 煤矿安全,2023,54(10):196−200. doi: 10.13347/j.cnki.mkaq.2023.10.026
    引用本文: 张翼,于林,卢向明. 煤矿安全监控系统数据加密存储方案设计[J]. 煤矿安全,2023,54(10):196−200. doi: 10.13347/j.cnki.mkaq.2023.10.026
    ZHANG Yi, YU Lin, LU Xiangming. Design of data encryption storage scheme for coal mine safety monitoring system[J]. Safety in Coal Mines, 2023, 54(10): 196−200. doi: 10.13347/j.cnki.mkaq.2023.10.026
    Citation: ZHANG Yi, YU Lin, LU Xiangming. Design of data encryption storage scheme for coal mine safety monitoring system[J]. Safety in Coal Mines, 2023, 54(10): 196−200. doi: 10.13347/j.cnki.mkaq.2023.10.026

    煤矿安全监控系统数据加密存储方案设计

    Design of data encryption storage scheme for coal mine safety monitoring system

    • 摘要: 针对煤矿安全监控系统数据加密与防篡改手断逐渐被人破解,已加密的监控系统数据有着较大被篡改风险的问题;通过分析当前主要防篡改技术、数据篡改手段以及系统主要数据特征,从数据访问用户加密管理、数据加密存储,以及数据被篡改后的恢复等方面通盘考虑,结合系统数据的实际应用场景,设计了数据加密存储的总体架构和基于关系数据库与文件存储的数据加密存储方案;方案通过在关系数据库存储中引入可搜索数据混淆、数据加密、数据检验和用户管理外壳等数据加密与防篡改手段,以及对关键数据进行文件加密备份的方式进行数据加密存储。应用该方案的煤矿安全监控系统,可有效防范目前常见的置换法、删除法等数据篡改手段,在煤矿安全监控、人员定位等系统数据加密与防篡改设计上有着较大的借鉴意义。

       

      Abstract: Aiming at the problem that data encryption and tamper-proof data of the coal mine safety monitoring system are gradually being cracked, and the encrypted monitoring system data has a greater risk of being tampered, by analyzing the current main anti-tampering technologies, main data tampering methods and main data characteristics of the system, considering overall data access user encryption management, data encrypted storage, and data recovery after tampering, combined with the actual and application scenarios of system data, the overall architecture of data encrypted storage and data encrypted storage based on relational database and file storage are designed. The scheme introduces data encryption and anti-tampering methods such as searchable data obfuscation, data encryption, data inspection, and user management shell in relational database storage, and encrypts and stores key data in the form of file encryption backup. The coal mine safety monitoring system with this scheme can effectively prevent data tampering methods such as the replacement method and the deletion method, which are common at present, and has great reference significance in the data encryption and tamper-proof design of coal mine safety monitoring, personnel positioning and other systems.

       

    /

    返回文章
    返回