1. How to submit my research paper? What’s the process of publication of my paper?
The journal receives submitted manuscripts via email only. Please submit your research paper in .doc or .pdf format to the submission email: jetwi@etpub.com.
2.Can I submit an abstract?
The journal publishes full research papers. So only full paper submission should be considered for possible publication. Papers with insufficient content may be rejected as well, make sure your paper is sufficient enough to be published...[Read More]

An Architecture for Integrated Online Analytical Mining

Muhammad Usman1 and Sohail Asghar2
1. Department of Computer and Informataion Sciences, Auckland University of Technology, New Zealand
2. Center of Research in Data Engineering (CORDE), Muhammad Ali Jinnah University, Islamabad, Pakistan
Abstract—Online Analytical Processing (OLAP) technology is an essential element of the decision support system and permits decision makers to visualize huge operational data for quick, consistent, interactive and meaningful analysis. More recently, data mining techniques are also used together with OLAP to analyze large data sets which makes OLAP more useful and easier to apply in decision support systems. Several works in the past proved the likelihood and interest of integrating OLAP with data mining and as a result a new promising direction of Online Analytical Mining (OLAM) has emerged. In this paper, a variety of OLAM architectures in the literature were reviewed and the limitations in the previously reported work have been identified. Literature review reveals the fact that none of the previously reported OLAM architectures have integrated enhanced OLAP with data mining. We enhanced the performance of OLAP in terms of cube construction time and visualization by providing interactive visual exploration of data cube. Furthermore, automatic OLAP schema generation has never been introduced as a component of OLAM architecture. The aim of this paper is to propose an integrated OLAM architecture that not only overcomes the existing limitations but also extends the architecture by adding an automation layer for the schema generation. In the proposed work, hierarchical clustering has been used as the data mining technique and three types of schemas namely star, snowflake and galaxy were automatically generated. A prototype of automatic schema generation has been developed and schema generation algorithms have been provided. In addition to this, we implemented and deployed the proposed architecture. Validation has been done by performing experiments on real life data set. Experimental results prove that the proposed architecture improves the cube construction time, empowers interactive data visualization, automate schema generation, and enable targeted and focused analysis at the front-end. By integrating enhanced OLAP with data mining system a higher degree of development is achieved which makes significant advancement in the modern OLAM architectures.

Index Terms—automatic schema, cube, decision support system, data mining, data visualization, hierarchical clustering, OLAP  

Cite: Muhammad Usman and Sohail Asghar, "An Architecture for Integrated Online Analytical Mining," Journal of Emerging Technologies in Web Intelligence, Vol. 3, No. 2, pp. 74-99, May 2011. doi:10.4304/jetwi.3.2.74-99
Array
Copyright © 2013-2020 Journal of Emerging Technologies in Web Intelligence, All Rights Reserved
E-mail: jetwi@etpub.com