矿井物流管理和人员定位系统数据库设计  

Design of database of mine logistics management and personnel positioning system

作　　者：肖林京[1] 文艺成 孙传余[1] 温彦[2] 武慧[1] 

机构地区：[1]山东科技大学机械电子工程学院,山东青岛266590 [2]山东科技大学信息科学与工程学院,山东青岛266590

出　　处：《工矿自动化》2015年第4期26-29,共4页Journal Of Mine Automation

基　　金：山东省科技发展计划项目(2012GSF11606)

摘　　要：针对矿井物流管理系统与矿井人员定位系统独立运行导致的成本高、维护困难等问题,提出将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.

关 键 词：矿井 物流运输 物流管理 人员定位 射频识别 数据库 

分 类 号：TD67[矿业工程—矿山机电]