Design and implementation of a new intelligent warehouse management system based on MySQL database technology
Abstract
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). 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.
DOI:
https://doi.org/10.31449/inf.v46i3.3968Downloads
Published
09/15/2022
How to Cite
Zhang, Y., & Pan, F. (2022). Design and implementation of a new intelligent warehouse management system based on MySQL database technology. Informatica, 46(3). https://doi.org/10.31449/inf.v46i3.3968
Issue
Section
SPECIAL ISSUE ON Recent Trends and Advances of Informatica in E-Commerce: Opportunities, Challenges and Solutions
License
Authors retain copyright in their work. By submitting to and publishing with Informatica, authors grant the publisher (Slovene Society Informatika) the non-exclusive right to publish, reproduce, and distribute the article and to identify itself as the original publisher.
All articles are published under the Creative Commons Attribution license CC BY 3.0. Under this license, others may share and adapt the work for any purpose, provided appropriate credit is given and changes (if any) are indicated.
Authors may deposit and share the submitted version, accepted manuscript, and published version, provided the original publication in Informatica is properly cited.
