An Architecture for Integrated Online Analytical Mining

Abstract

[1]. S. Chaudhuri and U. Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, Vol. 26 (1997), pp. 65-74. doi:10.1145/248603.248616
http://dx.doi.org/10.1145/248603.248616

[2]. A. Cuzzocrea, D. Sacca and P. Serafino, A hierarchy driven compression technique for advanced OLAP visualization of multidimensional data cubes, in Proc. of 8th Int’l Conf. on Data Warehousing and Knowledge Discovery (DaWak), (Springer Verlag 2006), pp. 106-119

[3]. S. Maniatis, P. Vassiliadis, S. Skiadopoulos and Y. Vassiliou, Advanced visualization for OLAP, in Proc. of 6th ACM Int’l Workshop on Data Warehousing and OLAP (DOLAP), (ACM New York, 2003), pp. 9-16.

[4]. S. Mansmann and M. Scholl, Exploring OLAP aggregates with hierarchical visualization techniques, in Proc. of ACM Symposium on Applied Computing (2007), pp. 1067-1073.

[5]. S. Goil and A. Choudhary, “High performance OLAP and data mining on parallel computers,” Data Mining and Knowledge Discovery, vol. 1, no. 4, pp. 391-417, Dec. 1997. doi:10.1023/A:1009777418785
http://dx.doi.org/10.1023/A:1009777418785

[6]. D. Papadias, P. Kalnis, J. Zhang and Y. Tao, “Efficient OLAP operations in spatial data warehouse,” in Proc. of the 7th Int’l Symposium on Advances in Spatial and Temporal Databases (SSTD), Springer-Verlag, 2001, pp. 443-459

[7]. S. Asghar, D. Alahakoon and A. Hsu, “Enhancing OLAP functionality using self-organizing neural networks,” Neural, Parallel and Scientific Computations, vol. 12, no. 1, pp. 1-20, March 2004.

[8]. R. B. Messaoud, O. Boussaid and S. Rabaseda, “A new OLAP aggregation based on the AHC technique,” in Proc. of the 7th ACM Int’l Workshop on Data Warehousing and OLAP (DOLAP), ACM New York, 2004, pp. 65-72.

[9]. S. Maniatis, P. Vassiliadis, S. Skiadopoulos and Y. Vassiliou, “Advanced visualization for OLAP,” in Proc. of the 6th ACM Int’l Workshop on Data Warehousing and OLAP (DOLAP), ACM New York, 2003, pp. 9-16.

[10]. M. Sifer, “A visual interface technique for exploring OLAP data with coordinated dimension hierarchiches,” in Proc. of the 12th ACM Int’l Conf. on Information and Knowledge Management (CIKM), ACM New York, 2003, pp. 532-535.

[11]. A. Voss, V. Hernandez, H. Voss and S. Scheider, “Interactive visual exploration of multidimensional data: requirements for common GIS with OLAP,” in Proc. of the 15th Int’l Workshop on Database and Expert Systems Applications (DEXA), 2004, pp. 883-887.

[12]. M. Scotch and B. Paramanto, “SOVAT: Spatial OLAP visualization and analysis tool,” in Proc. of the 38th Annual Hawaii Int’l Conf. on Systems Sciences (HICSS), 2005, p. 165.

[13]. A. Cuzzocrea, D. Sacca and P. Serafino, “A hierarchy driven compression technique for advanced OLAP visualization of multidimensional data cubes,” in Proc. of the 8th Int’l Conf. on Data Warehousing and Knowledge Discovery (DaWak), Springer Verlag, 2006, pp. 106-119.

[14]. K. Techapichetvanich and A. Datta, “Interactive visualization for OLAP,” in Int’l Conf. on Computational Science and its Applications (ICCSA), 2005, pp. 206-214.

[15]. S. Mansmann and M.Scholl, “Extending visual OLAP for handling irregular dimensional hierarchies,” in Proc. of 8th Int’l Conf. on Data Warehousing and Knowledge Discovery (DaWaK'06), 2006, pp. 95-105.

[16]. S. Mansmann and M. Scholl, “Visual OLAP: A new paradigm for exploring multidimensional aggregates,” in Proc. of IADIS Int’l Conf. on Computer Graphics and Visualization (CGV), 2008, pp. 59-66.

[17]. S. Asghar and M. Usman, “Enhancing OLAP performance and visualization,” in Proc. of 6th Int’l Conf. on Information Science Technology and Management (CISTM), 2008, pp. 59-70.

[18]. Fayyad U.M, Piatesky-Shapiro G., Smyth p. and Uthurusamy R., “From data mining to knowledge discovery: An overview,”in Proc. of Advances in data mining and knowledge discovery, MIT Press, 1996, pp. 1-34.

[19]. J. Hipp, U. Guentzer and G. Nakhaeizadeh, “Algorithms for association ruling mining – a general survey and comparison,” ACM SIGKDD Explorations Newsletter, vol. 2, no. 1, pp. 58 – 64, June 2000. doi:10.1145/360402.360421
http://dx.doi.org/10.1145/360402.360421

[20]. R. C. Holte, “Very simple classification rules perform well on most commonly used datasets,” Machine Learning, vol. 11, no. 1, pp. 63-90, April 1993. doi:10.1023/A:1022631118932
http://dx.doi.org/10.1023/A:1022631118932

[21]. A. K. Jain, M. N. Murty and P. J. Flynn, “Data clustering: A review,” ACM Computing surveys (CSUR), vol. 31, no. 3, pp. 264-323, Sep. 1999.

[22]. M. J. Shaw, C. Subramaniam, G. W. Tan and M. E. Welge, “Knowledge management and data mining for marketing,” Decision Support Systems, vol. 31, no. 1, pp. 127-137, May 2001. doi:10.1016/S0167-9236(00)00123-8
http://dx.doi.org/10.1016/S0167-9236(00)00123-8

[23]. J. Han, “Towards online analytical mining in large databases,” ACM SIGMOD Record, vol. 27, no. 1, pp. 97-107, March 1998. doi:10.1145/273244.273273
http://dx.doi.org/10.1145/273244.273273

[24]. J. Han, S. H. S. Chee and J. Y. Chiang, “Issues for on-line analytical mining of data warehouses,” in Proc. of the SIGMOND Workshop on Research Issues on Data Mining and Knowledge Discovery (DMKD), Seattle, 1998, pp. 2:1-2:5.

[25]. H. Zhu, “Online analytical mining of association rules,” Master Thesis, Simon Fraser University, 1998, pp. 1-117.

[26]. J. Fong, H. K. Wong and A. Fong, “Online analytical mining Web-pages tick sequences,” J. of Data Warehousing, vol. 5, no. 4, pp. 59-67, 2000.

[27]. S. Dzeroski, D. Hristovski and B. Peterlin, “Using data mining and OLAP to discover patterns in a database of patients with Y chromosome deletions,” in Proc. AMIA Symp., 2000, pp. 215–219.
PMid:11079876    PMCid:2243768

[28]. F. Dehne, T. Eavis and A. Rau-Chaplin, “Coarse grained parallel on-line analytical processin (OLAP) for data mining, in Proc. of the Int’l Conf. on Computational Science (ICCS), 2001, 589-598.

[29]. V. Markl, F. Ramasak and R. Bayer, “Improving OLAP performance by multi-dimensional hierarchical clustering,” in Proc. of the 1999 Int’l Symposium on Database Engineering and Applications (IDEAS), 1999, p. 165.

[30]. V. Markl and R. Bayer, “Processing relational OLAP queries with UB-trees and multidimensional hierarchical clustering,” in Proc. of the Int’l. Workshop on Design and Management of Data Warehouses (DMDW), 2000, pp. 1-10.

[31]. N. Karayannidis, T. Sellis and Y. Kouvaras, “CUBE file: A file structure for hierarchically clustered OLAP cubes,” Advances in Database Technology, LNCS, Springer Verlag, Berlin-Heidelberg, pp. 621-638, 2004.

[32]. D. Theodoratos and A. Tsois, “Heuristic optimization of OLAP queries in multidimensionally hierarchically clustered databases,” in Proc. of the 4th ACM Int’l Workshop on Data Warehousing and OLAP (DOLAP), ACM New York, 2001, pp. 48-55.

[33]. K. Hann, C. Sapia and M. Balaschka, “Automatically generating OLAP schemata from conceptual graphical models,” in Proc. of the 3rd ACM Int’l. Workshop on Data Warehousing and OLAP (DOLAP), ACM New York, 2000, pp. 9-16.

[34]. V. Peralta, A. Marotta and R. Ruggia, “Towards the automation of data warehouse design,” Technical Report TR-03-09, InCo, Universidad de la República, Montevideo, Uruguay, June 2003.

[35]. N. Tryfona, F. Busborg and J. G. B. Christiansen “StarER: A conceptual model for data warehouse design,” Proc. of the 2nd ACM Int’l. Workshop on Data Warehousing and OLAP (DOLAP), ACM New York, 1999, pp. 3-8.

[36]. Y. Song, et al., “SAMSTAR: An automatic tool for generating star schemas from an entity-relationship diagram,” in Proc. of the 27th Int’l. Conf. on Conceptual Modeling, LNCS 2008,vol. 5231 pp. 522-523.

[37]. S. R. Maddi and V. Khan, “Comparative analysis of on-line analytical processing tools,” University essay from IT-universitetet I Göteborg, Sweden 2007.

[38]. M. Reed, “A definition of data warehousing,” [Onlline]. Available: http://www.intranetjournal.com/features/datawarehousing.html. [Accessed: April 28, 2009].

[39]. R. Kimball and M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd ed., New York: John Wiley, 1996.

[40]. J. Widom, “Research problems in data warehousing,” in Proc. of the 4th Intl. Conf. on Information and Knowledge Management (CIKM), 1995, pp. 25-30.

[41]. S. Chaudhuri and U. Dayal, “Data warehousing and OLAP for decision support,” in Proc. of the ACM Intl. Conf. on Management of Data, ACM New York, 1997, pp. 507-508.

[42]. G. Colliat, “OLAP, relational, and multidimensional database systems,” ACM SIGMOND Record, vol. 25, no. 3, pp. 64-69, 1996. doi:10.1145/234889.234901
http://dx.doi.org/10.1145/234889.234901

[43]. H. Gupta, V. Harinarayan, A. Rajaraman and J. D. Ullman, “Index selection for OLAP,” in Proc. of the 13th Intl. Conf. on Data Engineering (ICDE), 1997, pp. 208-219. doi:10.1109/ICDE.1997.581755
http://dx.doi.org/10.1109/ICDE.1997.581755

[44]. W. H. Inmon, “The data warehouse and data mining,” Communications of the ACM, vol. 39, no. 11, pp. 49-50, 1996. doi:10.1145/240455.240470
http://dx.doi.org/10.1145/240455.240470

[45]. ADSS OLAP Help. [Online]. Available: http://www.agroict-olap.org/OLAP_Help.aspx. [Accessed: April 28, 2009].

[46]. T. J. Teorey, „Data warehousing, OLAP, and data mining, in Database Modeling and Design, 3rd ed., Morgan Kaufmann, 1999, pp. 211-250.

[47]. IBM Journal of Research and Development. [Online]. Available: https://www.research.ibm.com/journal/sj/414/colossi.html. [Accessed: April 28, 2009].

[48]. E. Thomsen, “OLAP Solutions: Building Multidimensional Information Systems,” 2nd . New York: John Wiley, 2002.

[49]. B. Dinter and C. Sapia et al., "OLAP marketing and research: Initiating the cooperation," J. of Computer Science and Information Management, vol. 2, no. 3, 1999.

[50]. M S. Chen, J. Han and P. S. Yu, “Data mining: An overview from a database perspective,” IEEE Transactions on Knowledge and Data Engineering, vol. 8, no. 6, pp. 866-883, Dec. 1996. doi:10.1109/69.553155
http://dx.doi.org/10.1109/69.553155

[51]. U. Fayyad, G. Piatetsky-Shapiro and P. Smyth, “Knowledge discovery and data mining: Towards a unifying framework,” in Proc. of the 2nd Intl. Conf. on Knowledge Discovery and Data Mining, 1996, pp. 82-88.

[52]. D. Hand, H. Mannila and P. Smyth, “Principles of Data Mining,” [Online]. Available: http://cat.inist.fr/?aModele=afficheN&cpsidt=18958626. [Accessed: April 28, 2009].

[53]. U. Fayyad, G. Piatetsky-Shapiro and P. Smyth, “From data mining to knowledge discovery in databases,” AI Magazine, 1996.

[54]. P. Berkhin, “A survey of clustering data mining techniques,” in Grouping Multidimensional Data, Springer Berlin-Heidelberg, 2006, pp. 25-71. doi:10.1007/3-540-28349-8_2
http://dx.doi.org/10.1007/3-540-28349-8_2

[55]. A. Berson, S. Smith and K. Thearling, “An Overview of Data Mining Techniques,” [Online]. Available: http://www.thearling.com/text/dmtechniques/dmtechniques.htm. [Accessed: April 28, 2009].

[56]. D. Beeferman and A. Berger, “Agglomerative clustering of a search engine query log,” in Proc. of the 6th Intl. Conf. on Knowledge Discovery and Data Mining ACM SIGKDD, 2000, pp. 407-416.

[57]. S. O. Deininger, et al., “MALDI imaging combined with hierarchical clustering as a new tool for the interpretation of complex human cancers,” J. Proteome Res., vol. 7, no. 12, pp. 5230-5236, 2008. doi:10.1021/pr8005777
http://dx.doi.org/10.1021/pr8005777
PMid:19367705

[58]. C. Li and W. H. Wong, “DNA-Chip Analyzer (dChip),” [Online]. Available: http://biosun1.harvard.edu/complab/dchip/Li%2003.pdf. [Accessed: April 28, 2009].

[59]. V. Hatzivassiloglou, et al., “SIMFINDER: A flexible clustering tool for summarization,” in NAACL Workshop on Automatic Summarization, 2001, pp. 41-49.

[60]. J. Seo, et al., “Interactive color mosaic and dendrogram displays for signal/noise optimization in microarray data analysis,” in Proc. of the Intl. Conf. on Multimedia and Expo-Volume 3, 2003, pp. 461-464.

[61]. R. Rak and W. Stach, “Evaluation of XLMiner demo version 2,” report, 2004. [Online]. Available: http://www.cs.ualberta.ca/~zaiane/courses/cmput695-04/work/A2-reports/xlminer.pdf. [Accessed: April 28, 2009].

[62]. [Online]. Available: http://www.cs.umd.edu/hcil/hce/. [Accessed: April 28, 2009].

[63]. Netz, S. Chaudhuri, J. Bernhardt and U. Fayyad, “Integration of data mining and relational databases,” in Proc. of the 26th Intl. Conf. on Very Large Database, 2000, pp. 719-722.

[64]. [Online]. Available:http://www.ibm.com/developerworks/rational/library/07/0626_johnson/index.html. [Accessed: April 28, 2009].

[65]. D. L. K. Johnson, “Reporting with rational portfolio manager version 7.1,” June 26, 2007. [Online]. Available: http://www.ibm.com/developerworks/rational/library/07/0626_johnson/index.html [Accessed: April 28, 2009].

[66]. Stanford Technology Group, “Designing the Data Warehouse on Relational Databases,” 1996. [Online]. Available: http://www.informix.com.ua/articles/rolap/rolap.htm. [Accessed: April 28, 2009].

[67]. D. L. Moody and M. A.R. Kortink, “From enterprise models to dimensional models: A methodology for data warehouse and data mart design,” in Proc. of the Intl. Workshop on Design and Management of Data Warehouses (DMDW), 2000, pp. 5:1-5:12.

[68]. “Data Warehouse Design,“ [Online]. Available: http://www.pafis.shh.fi/%7Eargarg03/SFIS/WS1/dataw_design.htm. [Accessed: April 28, 2009].

[69]. S. Asghar, D. Alahakoon and D. Taniar, “Enhancing OLAP functionality using association rules,” in Proc. of 2nd Int’l Conf. on Computational Intelligence, Robotics and Autonomous Systems (CIRAS), 2003, pp. 1-6.

[70]. A. Rauber and P. Tomsich, “An architecture for modular OLAP Systems: Supporting distributed and parallel query processing using cooperating CORBA objects,” in 10th Int’l Workshop on Database and Expert Systems Applications (DEXA), 1999, p. 45. doi:10.1109/DEXA.1999.795143
http://dx.doi.org/10.1109/DEXA.1999.795143

[71]. S. Asghar and M. Usman, “Integrated enhancement of OLAP performance and visualization using self growing organizing neural networks,” in Int’l J. of Information Tech. and Decision Making, 2009, submitted.

[72]. Available:http://support.dundas.com/OnlineDocumentation/WebOLAP/Overview%20of%20Dundas%20OLAP%20Architecture.html. [Online]. [Accessed: Apr. 2009].

[73]. J. A. Blackard, D. J. Dean and C. W. Anderson, Forest cover type, The UCI KDD Archive [http://kdd.ics.uci.edu]. Irvine, CA: University of California, Department of Information and Computer Science (1998).

[74]. C. Meek, B. Thiesson, D.Heckerman, US Census Data (1990), The UCI KDD Archive [http://archive.ics.uci.edu/ml/datasets/US+Census+Data 281990 29], US Department of Commerce.

[75]. Available. http://archive.ics.uci.edu/ml/databases/census1990/USCensus1990raw.html. Online [Accessed: Apr. 2009].

[76]. Available. http://archive.ics.uci.edu/ml/databases/census1990/USCensus1990raw.coding.htm Online [Accessed: Apr. 2009].

[77]. Available. http://archive.ics.uci.edu/ml/databases/census1990/USCensus1990.mapping.sql Online [Accessed: Apr. 2009]