Design of database of mine logistics management and personnel positioning system

XIAO Linjing; WEN Yicheng; SUN Chuanyu; WEN Yan; WU Hui

doi:10.13272/j.issn.1671-251x.2015.04.007

Gong-kuang zidonghua (Apr 2015)

Design of database of mine logistics management and personnel positioning system

XIAO Linjing,
WEN Yicheng,
SUN Chuanyu,
WEN Yan,
WU Hui

Affiliations

XIAO Linjing: College of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, China
WEN Yicheng: College of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, China
SUN Chuanyu: College of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, China
WEN Yan: College of Information Science and Engineering, Shandong University of Scien
WU Hui: College of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, China

DOI: https://doi.org/10.13272/j.issn.1671-251x.2015.04.007
Journal volume & issue: Vol. 41, no. 4
pp. 26 – 29

Abstract

Read online

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.

Published in Gong-kuang zidonghua

ISSN: 1671-251X (Print)
Publisher: Editorial Department of Industry and Mine Automation
Country of publisher: China
LCC subjects: Technology: Mining engineering. Metallurgy
Website: http://www.gkzdh.cn/en.htm

About the journal

Abstract

Keywords