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...
Main Authors: | , , , , |
---|---|
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 |