Research on warehouse management system based on association rules

Warehouse management is important for the development of enterprises. A good warehouse management system can enable enterprises to operate solid foundation. Using the method of manual records of data to manage enterprise warehouses has been unable to meet the current development needs of warehouse management. In this paper, we apply the Apriori algorithm to the warehouse management system. And we use the Apriori algorithm of data mining to analyze the records of the amount of goods in the warehouse, and the association rules between the goods are obtained. According to the association rules obtained by the system, the system can analyze the amount of the goods involved in the association rules. If the amount of goods is less than the minimum inventory or less than half of the maximum inventory, the system will recommend the names of goods that need to be purchased at the same time for the procurement staff. The method proposed by us can help procurement staff save time, and it can also reduce the influence of the shortage of goods for sales.

[1]  Tomasz Imielinski,et al.  Database Mining: A Performance Perspective , 1993, IEEE Trans. Knowl. Data Eng..

[2]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[3]  Šimon Kovařík.  Warehouse Management System a jeho implementace , 2014 .

[4]  Yang Cheng,et al.  The Research of Improved Apriori Algorithm for Mining Association Rules , 2007, 2007 International Conference on Service Systems and Service Management.

[5]  S. Velde,et al.  Linking warehouse complexity to warehouse planning and control structure: An exploratory study of the use of warehouse management information systems , 2002 .

[6]  Geoffrey I. Webb,et al.  Advances in Knowledge Discovery and Data Mining , 2018, Lecture Notes in Computer Science.

[7]  Philip S. Yu,et al.  Data Mining: An Overview from a Database Perspective , 1996, IEEE Trans. Knowl. Data Eng..

[8]  Rakesh Agarwal,et al.  Fast Algorithms for Mining Association Rules , 1994, VLDB 1994.

[9]  Tomasz Imielinski,et al.  Mining association rules between sets of items in large databases , 1993, SIGMOD Conference.

[10]  Ramakrishnan Srikant,et al.  Fast Algorithms for Mining Association Rules in Large Databases , 1994, VLDB.

[11]  Elisa Bertino,et al.  Hiding Association Rules by Using Confidence and Support , 2001, Information Hiding.

[12]  Kurt Hornik,et al.  Introduction to arules – A computational environment for mining association rules and frequent item sets , 2009 .

[13]  Das Amrita,et al.  Mining Association Rules between Sets of Items in Large Databases , 2013 .

[14]  Wynne Hsu,et al.  Mining association rules with multiple minimum supports , 1999, KDD '99.