井下人员定位管理系统数据模型设计

Design of data model of underground personnel positioning and management system

针对井下人员定位管理系统存在的灾害发生时可靠信息易被破坏、查询效率低等问题,设计了井下人员定位管理系统的数据采集模型及数据流图,并分析了系统数据库的设计要求、表结构设计及数据库优化方法。系统采用主从式通信方式实现数据采集,根据功能划分建立基础数据库和当前数据库,并采用查询语句优化、索引优化等手段提升数据库性能,提高了数据采集及处理速度、系统可靠性及查询效率。

For problems that reliable information is easily destroyed and query efficiency is low existed in underground personnel positioning and management system, the paper designed a data acquisition model and data flow diagrams of the system, and analyzed design requirements, table structure design and database optimization. The system uses master-slave communication mode to achieve data acquisition, establishes foundation database and current database according to different functions, and adopts query sentence optimization and index optimization to improve database performance, so as to improve data acquisition and processing speed, system reliability and inquiring efficiency.