Journal of information and communication convergence engineering

The Korea Institute of Information and Commucation Engineering (한국정보통신학회)
권호 표지
DOI QR코드

DOI QR Code

Odoo Data Mining Module Using Market Basket Analysis

  • Received : 2018.03.15
  • Accepted : 2018.03.23
  • Published : 2018.03.31
Download PDF
⟨ Previous Next ⟩

Abstract

Odoo is an enterprise resource planning information system providing modules to support the basic business function in companies. This research will look into the development of an additional module at Odoo. This module is a data mining module using Market Basket Analysis (MBA) using FP-Growth algorithm in managing OLTP of sales transaction to be useful information for users to improve the analysis of company business strategy. The FP-Growth algorithm used in the application was able to produce multidimensional association rules. The company will know more about their sales and customers' buying habits. Performing sales trend analysis will give a valuable insight into the inner-workings of the business. The testing of the module is using the data from X Supermarket. The final result of this module is generated from a data mining process in the form of association rule. The rule is presented in narrative and graphical form to be understood easier.

Keywords

E1ICAW_2018_v16n1_52_f0001.png 이미지

Fig. 1. Research method.

E1ICAW_2018_v16n1_52_f0002.png 이미지

Fig. 2. ERD on X Supermarket sales system.

E1ICAW_2018_v16n1_52_f0003.png 이미지

Fig. 3. System flowchart.

E1ICAW_2018_v16n1_52_f0004.png 이미지

Fig. 4. Generate frequent itemsets flowchart.

E1ICAW_2018_v16n1_52_f0005.png 이미지

Fig. 5. Generate FP-Tree flowchart.

E1ICAW_2018_v16n1_52_f0006.png 이미지

Fig. 6. Header table.

E1ICAW_2018_v16n1_52_f0007.png 이미지

Fig. 7. Update frequent header table.

E1ICAW_2018_v16n1_52_f0008.png 이미지

Fig. 8. FP-Tree.

E1ICAW_2018_v16n1_52_f0009.png 이미지

Fig. 9. The view conditional pattern menu interface.

E1ICAW_2018_v16n1_52_f0010.png 이미지

Fig. 10. The interface of view generated view pattern menu.

E1ICAW_2018_v16n1_52_f0011.png 이미지

Fig. 11. The interface of table view menu.

E1ICAW_2018_v16n1_52_f0012.png 이미지

Fig. 12. Pie diagram for the confidence of the pattern set.

Table 1. The capability ranking algorithm

E1ICAW_2018_v16n1_52_t0001.png 이미지

References

  1. L. W. Santoso and Yulia, "Data warehouse and big data technology for higher education," Procedia Computer Science, vol. 124, pp. 93-99, 2017. DOI: 10.1016/j.procs.2017.12.134.
  2. G. Moss, Working with openERP. Brimingham: Packt Publishing, 2013.
  3. D. Reis, Odoo Development Essentials. Brimingham: Packt Publishing, 2015.
  4. S. Riggs and H. Krossing, PostgreSQL 9 Administration Cookbook. Brimingham, UK: Packt Publishing, 2010.
  5. M. Narvekar and S. F. Syed, "An optimized algorithm for association rule mining using FP tree," Procedia Computer Science, vol. 45, pp. 101-110, 2015. DOI: 10.1016/j.procs.2015.03.097.
  6. D. T. Larose, Discovering Knowledge in Data: an Introduction to Data Mining. Hoboken, NJ: John Wiley & Sons, 2005.
  7. J. Han, M. Kamber, and J. Pei, Data Mining: Concepts and Techniques, 3rd ed. San Fransisco, CA: Morgan Kaufman, 2012.
  8. X. D. Wu and V. Kumar, The Top Ten Algorithms in Data Mining. Boca Raton, FL: CRC Press, 2009.
  9. P. T. Tan, M. Steinbach and V. Kumar, Introduction to Data Mining. Boston, MA: Pearson, 2005.
  10. J. Li and D. T. Ming, "Research of an association rule mining algorithm based on FP tree," in Proceedings of IEEE International Conference on Intelligent Computing and Intelligent Systems, Xiamen, China, pp. 559-563, 2010. DOI: 10.1109/ICICISYS.2010.5658443.
  11. J. Han, J. Pei, Y. Yin, and R. Mao, "Mining frequent patterns without candidate generation: a frequent-pattern tree approach," Data Mining and Knowledge Discovery, vol. 8, no. 1, pp. 53-87, 2004. DOI: 10.1023/B:DAMI.0000005258.31418.83.
  12. Z. Zheng, R. Kohavi, and L. Mason, "Real world performance of association rule algorithms," in Proceeding of the 7th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, San Francisco, CA, pp. 401-405, 2000. DOI: 10.1145/502512.502572.

Cited by

  1. ISM Application Tool, A Contribution to Address the Barrier of Information Security Management System Implementation vol.18, pp.1, 2018, https://doi.org/10.6109/jicce.2020.18.1.39