Design of database of mine logistics management and personnel positioning system

In order to solve problems of high cost and difficult maintenance caused by logistics management system and personnel positioning system of coal mine running independently, a way of integrating and unifying the two systems was 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 shows that the database has high practicability and reliability.