Knowledge Extraction and Analysis to Evaluate the Financial Performance of an Organization Using OLAM

Full Text (PDF, 673KB), PP.20-27

Views: 0 Downloads: 0

Author(s)

Mahtab Ebrahimi 1,*

1. Department of Electrical and Computer Engineering, Islamic Azad University Damavand Branch Tehran, Iran

* Corresponding author.

DOI: https://doi.org/10.5815/ijmecs.2018.12.03

Received: 23 Sep. 2018 / Revised: 10 Oct. 2018 / Accepted: 17 Oct. 2018 / Published: 8 Dec. 2018

Index Terms

Data mining, data warehouse, online analytical processing, associative rules, data cube, OLAM

Abstract

Data mining or the discovery of knowledge out of databases extracts patterns, and useful and non-substantial, implicit, and unknown information from large databases. Searching for associative rules is a data mining method where relationships and dependencies Interactions between a large set of data items are shown. In large organizations, most data are created at the passage of time. Relational tables in a variety of business or scientific domains have rich information, with high quantative and nominal data types. Therefore, in order to gather information, measure performance and increase business efficiency, it is necessary to isolate relational database and store data in a data warehouse. Using the multidimensional data mining that integrates online analytical processing with data mining, knowledge can be found in multidimensional databases.
In this article, to avoid inappropriate rules in exploring associative rules, the online analytical processing technique is combined with the Apriori algorithm and explores associative rules on multi-dimensional and multilevel data using the data cubic and Apriori algorithm. In addition, the criteria of accuracy, tool performance, and runtime are defined for comparing techniques for exploring associative rules. The metrics mentioned in the scope of this paper have been compared, and data from the Central Insurance Agency have been analyzed using data cubes and the Apriori algorithm, and useful association rules have been generated. Results of the research displays improvement of the response time compared to the other methods.

Cite This Paper

Mahtab Ebrahimi, "Knowledge Extraction and Analysis to Evaluate the Financial Performance of an Organization Using OLAM", International Journal of Modern Education and Computer Science(IJMECS), Vol.10, No.12, pp. 20-27, 2018. DOI:10.5815/ijmecs.2018.12.03

Reference

[1]J.W.Seifert, 2004, “Data Mining: An overview”, Congressional Research Service of the Library of Congress.
[2]J. Han, M. Kamber, and J. Pei, 2011,”Data Mining: Concepts and Techniques”: Morgan Kaufmann Publishers.
[3]J. Han, M. Kamber, and J. Chiang, 1997 “Mining multidimensional association rules using data cubes,” Technical Report,Database Systems Research Laboratory.
[4]H. Zhu, 1998, “On-line analytical mining of association rules,” Doctoral Dissertation, Department of Computer Science, Simon Fraser University.
[5]S. Nestorov and N. Jukic, 2003, “Ad-hoc association-rule mining within the data ware-house,” in International Conference on System Sciences, Page. 232-242.
[6]C.K.H. Lee , K.L. Choy,G.T.S. Ho,K.S. Chin,K.M.Y. Law,Y.K. Tsec. 2013 “A hybrid OLAP-association rule mining based quality management system forextracting defect patterns in the garment industry” International Journal of Expert Systems with ApplicationsIssues Vol.66, Issues 7, Pages 52–62
[7]Namchul Do, Sungmoon Bae,Chulsoon Park. 2015 “Interactive Analysis Of Product Development Experiments Using On-Line Analytical Mining” International Journal Of Computers In Industry Vol.40, Issues 7, Pages 2435–2446
[8]Eltayeb Abuelyaman,Atifa Elgimari. 2014 “A Prototype For A Data Mining Based Pathfinder To Sudanese Universities” International Conference On Computer Modelling And Simulation Vol.8, Pages 119-124
[9]H Dev, SK Mishra 2011 “Design of Data Cubes and Mining for Online Banking System” International Journal of Computer Applications Vol.4.
[10]A. Guille and H. Hacid. 2013."Decision support system” in medical science using olap & data mining. In International Journal of Computer Science and Application, Vol. 6, No.2, pages 248–254.
[11]JJ Jadav, M Panchal.2012. "Association rule” mining method on olap cube. International Journal of Engineering Research and Application, Vol.2, Issue 2, pages 1147–1151.
[12]TS Abdellatif, MA Elsoud, HA Ali. 2011."Online analytical processing” and data mining tasks in enterprise resource planning. IJCSI International Journal of Computer Science Issues Vol.8, Issues 6, No 2, pages 161–173.
[13]ISY Kwan, J Fong, HK Wong. 2005. An “e-customer behavior” model with online analytical mining for internet marketing planning. Decision Support Systems - Elsevier, pages 101–123.
[14]WQ Qwaider. 2012. Apply On-Line Analytical Processing (OLAP) With Data Mining For Clinical Decision Support. International Journal of Managing Information Technology (IJMIT) Vol.4, No.1, pages 25–37.
[15]Y. Wang et al., 2013, “Improved multi-level association rule in mining algorithm based on a multidimensional data cube,” in International Conference on Consumer Electronics, Communications and Networks, Page. 355-358.
[16]A. Silva and C. Antunes, 2014, “Multi-relational pattern mining over data streams,” Data Mining and Knowledge Discovery, Page. 1-32.
[17]R. Kimball,Margy Ross,2013, “The Data Warehouse Toolkit”, Third Edition.
[18]Z. Ma, Q. Qiu, and P. Feng, 2014, “CPM algorithm for mining association rules from databases of engineering design instances,” Journal of Information Science and Engineering, Vol. 30, Paper. 463-481.
[19]Sheila A. Abaya, July-2012, “Association Rule Mining Based On Apriori Algorithm In Minimizing Candidate Generation”, International Journal of Scientific & Engineering Research,Volume 3, Issue 7 .
[20]Ms Shweta1 Dr. KanwalGarg, June 2013 ,“Mining Efficient Association Rules Through Apriori Algorithm Using Attributes and Comparative Analysis of Various Association Rule Algorithms”, International journal of Advanced Research in Computer Science and Software Engineering, Volume 3, Issue 6.
[21]Jayshree Jha1 and Leena Ragha2, Number 2013, “Educational Data Mining using Improved Apriori Algorithm”, International Journal of Information and Computation Technology. Department of Computer Engineering, Volume 3, Paper. 411-418.
[22]Jiao Yabing January 2013, “Research of an Improved Apriori Algorithm in Data Mining Association Rules “, International Journal of Co Communication Engineering, Vol. 2, No. 1.
[23]Jyoti Arora1, Nidhi Bhalla2, Sanjeev Rao3, July 2013, “A Review on Association Rule Mining Algorithms”, International Journal of Innovat in Computer and Communication Engineering, Vol. 1, Issue 5.
[24]Mohammed Al-Maolegi1, Bassam Arkok2, February 2014, “An Improved Apriori Algorithm For Association Rules”, International Journal on Natural Language Computing (IJNLC),Vol. 3.
[25]Jaishree Singh, Hari Ram and Dr.J.S.Sodhi, January 2013, “Improving efficiency of Apriori algorithm using Transaction Reduction”, International Journal of Scientific and Research Publications, Volume 3, Issue 1.