Design and Implementation of a New Intelligent Warehouse Management System Based on MySQL Database Technology

被引：0
作者：
Zhang Y. [1 ]
Pan F. [2 ]
机构：
[1] Changchun Polytechnic, Career Foundation Department, Jilin, Changchun
[2] Continental Automotive Corporation Changchun Co., LTD., Moonlake Branch, IT Department, Jilin, Changchun
来源：
Informatica (Slovenia) | 2022年 / 46卷 / 03期
关键词：
Database technology; Eclipse; Intelligent Warehouse Management; Internet of Things; Material Management; MySQL; Real Server;
D O I：
10.31449/inf.v46i3.3968
中图分类号：
学科分类号：
摘要：
The handling industry of materials/goods is fundamental for companies for ensuring the warehouses smooth running. Efficiency within every aspect of the business is essential to gain a competitive advantage. In order to improve the material management level of enterprises based on MySQL database technology; this paper makes an overall design of the warehouse management system, builds a MySQL database, and realizes the design and application of a new intelligent warehouse management system. Through the operation and test of the system, the results show that the system mainly realizes the five necessary functional modules of warehouse management: basic information management, system management, procurement management, warehousing management and inventory management. In the test, the system runs normally, the unit test and integration test can meet the expected requirements, realize the functions required by the user, and get the desired results within the user's acceptable response time (within 3S). Whether the system is running on the local machine or on the real server in the network, it must use the appropriate hardware and software conditions. It can provide automatic and comprehensive records for the whole process of material management of the enterprise, and provide real-time and correct information for all warehouse activities, resources and inventory levels. © 2022 Slovene Society Informatika. All rights reserved.
引用
收藏
页码：355 / 364
页数：9
相关论文
共 34 条
  • [1] Velicka J., Pies M., Hajovsky R., Wireless measurement of carbon dioxide by use of iqrf technology, IFAC-PapersOnLine, 51, 6, pp. 78-83, (2018)
  • [2] Raju T., Kim W. S., Mobile guidance system for evacuation based on wi-fi system and node architecture, Journal of Information Technology Applications & Management, 26, (2019)
  • [3] Liu Y. X., Li X. Y., Design and implementation of a business platform system based on java, Procedia Computer ence, 166, pp. 150-153, (2020)
  • [4] Liang J, Wu Z., Zhu C., Zhang Z. H., An estimation distribution algorithm for wave-picking warehouse management, Journal of Intelligent Manufacturing, 1, pp. 1-14, (2020)
  • [5] Zhao J., Xue F., Li D. A., Intelligent management of chemical warehouses with rfid systems, Sensors, 20, 1, (2019)
  • [6] Zhao K., Zhu M., Xiao B., Yang X., Wu J., Joint rfid and uwb technologies in intelligent warehousing management system, IEEE Internet of Things Journal, 99, (2020)
  • [7] Viloria A., Rodado D. N., Lezama O., Recovery of scientific data using intelligent distributed data warehouse, Procedia Computer Science, 151, pp. 1249-1254, (2019)
  • [8] Zhang Y., Yao J., Guan H., Intelligent cloud resource management with deep reinforcement learning, IEEE Cloud Computing, 4, 6, pp. 60-69, (2018)
  • [9] Kermani M., Adelmanesh B., Shirdare E., Sima C. A., Martirano L., Intelligent energy management based on scada system in a real microgrid for smart building applications, Renewable Energy, (2021)
  • [10] Yu S., Chen X, Zhou Z., Gong X, Wu D., When deep reinforcement learning meets federated learning: intelligent multi-timescale resource management for multi-access edge computing in 5g ultra dense network, IEEE Internet of Things Journal, 99, (2020)
1234