摘要
针对矿井物流管理系统与矿井人员定位系统独立运行导致的成本高、维护困难等问题,提出将2个系统进行相互融合、统一管理的方式,并采用射频识别技术和Microsoft SQL Server 2008数据库软件,设计了一种矿井物流管理和人员定位系统,着重介绍了需求分析及逻辑结构设计阶段的系统数据库设计方案,并给出了主要运输流程数据库表的映射关系。该数据库逻辑结构简单、清晰,具有良好的存储结构、数据共享性和一致性。实际应用表明,该数据库具有较高的实用性和可靠性。
In order to solve problems of management system and personnel positioning integrating and unifying the two systems was high cost and difficult maintenance caused by logistics system of coal mine running independently, a way of proposed. A mine logistics management and personnel positioning system was designed by use of radio frequency identification and Microsoft SQL Server 2008. A design scheme of system database was focused on in stages of demand analysis and logical structure design. Mapping relationship of database table of main processes was given. The database has simple and clear logic structure as well as good storage structure, data sharing and data consistency. Application show that the database has high practicability and reliability.
出处
《工矿自动化》
北大核心
2015年第4期26-29,共4页
Journal Of Mine Automation
基金
山东省科技发展计划项目(2012GSF11606)
关键词
矿井
物流运输
物流管理
人员定位
射频识别
数据库
mine
logistics transportation
logistics management
personnel positioning
radio frequency identification
database
