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 wa...

Full description

Bibliographic Details
Main Authors: XIAO Linjing, WEN Yicheng, SUN Chuanyu, WEN Yan, WU Hui
Format: Article
Language:zho
Published: Editorial Department of Industry and Mine Automation 2015-04-01
Series:Gong-kuang zidonghua
Subjects:
Online Access:http://www.gkzdh.cn/article/doi/10.13272/j.issn.1671-251x.2015.04.007
_version_ 1797868749493108736
author XIAO Linjing
WEN Yicheng
SUN Chuanyu
WEN Yan
WU Hui
author_facet XIAO Linjing
WEN Yicheng
SUN Chuanyu
WEN Yan
WU Hui
author_sort XIAO Linjing
collection DOAJ
description 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.
first_indexed 2024-04-10T00:00:48Z
format Article
id doaj.art-0de6c3489aae42dc80de84a16b750e0c
institution Directory Open Access Journal
issn 1671-251X
language zho
last_indexed 2024-04-10T00:00:48Z
publishDate 2015-04-01
publisher Editorial Department of Industry and Mine Automation
record_format Article
series Gong-kuang zidonghua
spelling doaj.art-0de6c3489aae42dc80de84a16b750e0c2023-03-17T01:46:52ZzhoEditorial Department of Industry and Mine AutomationGong-kuang zidonghua1671-251X2015-04-01414262910.13272/j.issn.1671-251x.2015.04.007Design of database of mine logistics management and personnel positioning systemXIAO Linjing0WEN Yicheng1SUN Chuanyu2WEN Yan3WU Hui4College of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, ChinaCollege of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, ChinaCollege of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, ChinaCollege of Information Science and Engineering, Shandong University of ScienCollege of Mechanical and Electronic Engineering, Shandong University of Science and Technology, Qingdao 266590, ChinaIn 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.http://www.gkzdh.cn/article/doi/10.13272/j.issn.1671-251x.2015.04.007minelogistics transportationlogistics managementpersonnel positioningradio frequency identificationdatabase
spellingShingle XIAO Linjing
WEN Yicheng
SUN Chuanyu
WEN Yan
WU Hui
Design of database of mine logistics management and personnel positioning system
Gong-kuang zidonghua
mine
logistics transportation
logistics management
personnel positioning
radio frequency identification
database
title Design of database of mine logistics management and personnel positioning system
title_full Design of database of mine logistics management and personnel positioning system
title_fullStr Design of database of mine logistics management and personnel positioning system
title_full_unstemmed Design of database of mine logistics management and personnel positioning system
title_short Design of database of mine logistics management and personnel positioning system
title_sort design of database of mine logistics management and personnel positioning system
topic mine
logistics transportation
logistics management
personnel positioning
radio frequency identification
database
url http://www.gkzdh.cn/article/doi/10.13272/j.issn.1671-251x.2015.04.007
work_keys_str_mv AT xiaolinjing designofdatabaseofminelogisticsmanagementandpersonnelpositioningsystem
AT wenyicheng designofdatabaseofminelogisticsmanagementandpersonnelpositioningsystem
AT sunchuanyu designofdatabaseofminelogisticsmanagementandpersonnelpositioningsystem
AT wenyan designofdatabaseofminelogisticsmanagementandpersonnelpositioningsystem
AT wuhui designofdatabaseofminelogisticsmanagementandpersonnelpositioningsystem