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

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.