A real-time database management system for logistics systems: A case study

King Lun Tommy Choy, Edmond L H Choy, T. C. Poon

Research output: Chapter in book / Conference proceedingConference article published in proceeding or bookAcademic researchpeer-review

4 Citations (Scopus)

Abstract

Due to the effect of globalization, the supply chain network has become more complex than before. In order to provide seamless integration among different supply chain parties within the network, and achieve high rewards in business activities, real-time information sharing is an essential element. Thus, numerous researches focus on instant data capturing techniques and effective data management tools separately for enhancing the performance of logistics operations, such as order picking, storage operation, etc. However, the attention paid by researchers to the integration of logistics operations, real-time information collection techniques and database management is relatively limited. In this paper, a Warehouse Resources Management System, an interactive database management system for logistics operations will be introduced in order to optimize the action of information retrieval performed by front-end users using Structured Query Language within the system. Real-time warehouse resources status will be captured by Radio Frequency Identification. Thus, interactive instant responses will be shown in the system for assisting users in making real-time decisions. The query optimization technique has been applied to the system for minimizing the expected cost of retrieving the required information.
Original languageEnglish
Title of host publicationPICMET '08 - 2008 Portland International Center for Management of Engineering and Technology, Proceedings Technology Management for a Sustainable Economy
Pages864-871
Number of pages8
DOIs
Publication statusPublished - 30 Sep 2008
Event2008 Portland International Center for Management of Engineering and Technology, Technology Management for a Sustainable Economy, PICMET '08 - Cape Town, South Africa
Duration: 27 Jul 200831 Jul 2008

Conference

Conference2008 Portland International Center for Management of Engineering and Technology, Technology Management for a Sustainable Economy, PICMET '08
CountrySouth Africa
CityCape Town
Period27/07/0831/07/08

ASJC Scopus subject areas

  • Business, Management and Accounting(all)
  • Management of Technology and Innovation
  • Strategy and Management
  • Management Science and Operations Research

Cite this