Browse > Article
http://dx.doi.org/10.9708/jksci.2011.16.2.289

An Approach to Navigating Data Cubes with a Hierarchical Visualization Technique  

Oh, Mi-Hwa (Industrial & Information Systems Engineering, Soongsil Univ.)
Hwang, Man-Mo (Industrial & Information Systems Engineering, Soongsil Univ.)
Choi, Jung-Woo (Industrial & Information Systems Engineering, Soongsil Univ.)
Choi, In-Soo (Industrial & Information Systems Engineering, Soongsil Univ.)
Abstract
To efficiently analyze complex and voluminous data, OLAP systems increasingly provide functionalities for visual exploration of the data allowing end-users to navigate the desired view of the data cube. This paper only deals with data cubes whose schemas represented like the exclusive symmetric hierarchy which is not addressed by current OLAP implementations. This paper presents a conceptual classification of abstraction hierarchies, and an approach to navigating data cubes with a hierarchical visualization technique. The hierarchical visualization technique is developed by using the transitive closure of a binary relation. The approach is exemplified using a real-world study from the domain of national license administration.
Keywords
Hierarchical visualization; Abstraction hierarchy; Exclusive symmetric hierarchy; Data cube navigation; Transitive closure; Schema;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
1 Alfredo Cuzzocrea, and Svetlana Mansmann, "Models, Issues, and Techniques in OLAP Visualization," IGI Golbal, pp. 1-8, 2009.
2 Alfredo Cuzzocrea, Domenico Sacca, and Paolo Serafino, "A Hierarchy-Driven Compression Technique for Advanced OLAP Visualization of Multidimensional Data Cubes," Proceedings of the 8th International Conference on Data Warehousing and Knowledge Discovery, LNCS 4081, pp. 106- 119, 2006.
3 Svetlana Mansmann, and Marc H. Scholl, "Exploring OLAP Aggregates with Hierarchical Visualization Techniques," Proceedings of the 22nd Annual ACM Symposium on Applied Computing, Multimedia & Visualization Track, pp. 1067-1073, 2007.
4 DuckSung Lee, and InSoo Choi, "Design of an Inference Control Process in OLAP Data Cubes," Journal of The Korea Society of Computer and Information, Vol. 14, No. 5, pp. 183-193, May. 2009.
5 Xiaoyang Yo, "Transitive Closure of Binary Relation", http://imps.mcmaster.ca
6 Garrett M. Fitzmaurice, Nan M. Laird, and James H. Ware, "Applied Longitudinal Analysis," John Wiley & Sons, pp. 1-4, 2004.
7 DuckSung Lee, and InSoo Choi, "A Strategy for Inference Control of Official Statistics," Journal of The Korea Society of Computer and Information,, Vol. 14, No. 11, pp. 200-211, November. 2009.
8 Andreas Bauer, Wolfgang Hummer, and Wolfgang Lehner, "An Alternative Relational OLAP Modeling Approach," LNCS 1874, pp. 189-198, 2000.
9 Surajit Chaudhuri, and Umeshwar Dayal, "An Overview of Data Warehousing and OLAP Technology," ACM SIGMOD Record, Vol. 26, No. 1, pp. 65-74, 1997.   DOI   ScienceOn
10 Transitive closure, http://en.wikipedia.org
11 Erik Thomsen, "OLAP Solutions," pp. 132-133, John Wiley & Sons, 2002.
12 Svetlana Vinnik, and Florian Mansmann, "From Analysis to Interactive Exploration: Building Visual Hierarchies from OLAP Cubes,"LNCS 3896, pp.496-514, 2006.
13 H. J. Lenz, and A. Shoshani, "Summarizability in OLAP and statistical data bases," In Proceedings of 9th International Conference on Scientific and Statistical Database Management, pp. 132-43, 1997.
14 Torben Bach Pedersen, Christian S. Jensen, and Curtis E. Dyreson, "A foundation for capturing and querying complex multidimensional data," Information Systems Vol. 26, pp. 383-423, 2001.   DOI   ScienceOn
15 Torben Bach Pedersen, and Christian S. Jensen, "Multidimensional Data Modeling for Complex Data," A Time Center Technical Report, pp. 1-27, 1998.
16 Carlos A. Hurtado, and Alberto O. Mendelzon. Jensen, "Reasoning about Summarizability in Heterogeneous Multidimensional Schemas", LNCS 1973, pp. 375-389, 2001.
17 David M. Kroenke, "Database Processing," PEARSON, pp. 182, 2010.
18 EM015527, KRIVET, 2002.
19 Svetlana Mansmann, and Marc H. Scholl, "Extending Visual OLAP for Handling Irregular Dimensional Hierarchies," LNCS 4081, pp. 95-105, 2006.
20 EM018587, KRIVET, 2003.
21 E. Malinowski, and E. Zimanyi, "OLAP Hierarchies: A Conceptual Perspective," LNCS 3084, pp. 477-49, 2004.
22 EM015526, KRIVET, 2000.
23 SeHyeon Jang, HanJu Yu, and InSoo Choi, "Design of a Hierarchical Dimension of the Bill of Materials Type," Journal of the Korea Society of Computer and Information, Vol. 11, No. 4, pp. 244-250, Sept. 2006.
24 John Miles Smith, and Diane C.P.Smith, "Database Abstractions: Aggregation," ACM Transactions on Database Systems, Vol. 2, No. 2, pp. 105-133, June. 1977.   DOI
25 Aggregation, http://krdic.naver.com
26 John Miles Smith, and Diane C.P.Smith, "Database Abstractions: Aggregation and Generalization," ACM Transactions on Database Systems, Vol. 2, No. 2, pp. 105-133, June. 1977.   DOI
27 David M. Kroenke, "Database Processing," PEARSON, pp. 125-188, 2010.