The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.03 - March (2014 vol.26)
pp: 563-576
Michele Risi , University of Salerno, Fisciano
Maria I. Sessa , University of Salerno, Fisciano
Maurizio Tucci , University of Salerno, Fisciano
Genoveffa Tortora , University of Salerno, Fisciano
ABSTRACT
The visualization of information contained in reports is an important aspect of human-computer interaction, for both the accuracy and the complexity of relationships between data must be preserved. A greater attention has been paid to individual report visualization through different types of standard graphs (Histograms, Pies, etc.). However, this kind of representation provides separate information items and gives no support to visualize their relationships which are extremely important for most decision processes. This paper presents a design methodology exploiting the visual language CoDe based on a logic paradigm. CoDe allows to organize the visualization through the CoDe model which graphically represents relationships between information items and can be considered a conceptual map of the view. The proposed design methodology is composed of four phases: the CoDe Modeling and OLAP Operation pattern definition phases define the CoDe model and underlying metadata information, the OLAP Operation phase physically extracts data from a data warehouse and the Report Visualization phase generates the final visualization. Moreover, a case study on real data is provided.
INDEX TERMS
Data visualization, Standards, Data mining, Data models, Visualization, Companies,user interfaces, Information visualization, cognitive systems, OLAP reports, data and knowledge visualization
CITATION
Michele Risi, Maria I. Sessa, Maurizio Tucci, Genoveffa Tortora, "CoDe Modeling of Graph Composition for Data Warehouse Report Visualization", IEEE Transactions on Knowledge & Data Engineering, vol.26, no. 3, pp. 563-576, March 2014, doi:10.1109/TKDE.2013.24
REFERENCES
[1] P. Ciuccarelli, M.I. Sessa, and M. Tucci, "Code: A Graphic Language for Complex System Visualization," Proc. Italian Assoc. for Information Systems (ItAIS), 2010.
[2] J. Bertin, Semiology of Graphics: Diagrams, Networks, Maps/Jacques Bertin; Translated by William J. Berg., Univ. of Wisconsin Press, 1983.
[3] S.K. Card, J.D. Mackinlay, and B. Shneiderman, Readings in Information Visualization: Using Vision to Think. Morgan Kaufmann Publishers Inc., 1999.
[4] E.R. Tufte, The Visual Display of Quantitative Information, second ed. Graphics Press, May 2001.
[5] A. Unger, P. Muigg, H. Doleisch, and H. Schumann, "Visualizing Statistical Properties of Smoothly Brushed Data Subsets," Proc. Fourth Int'l Conf. Information Visualisation, pp. 233-239, 2008.
[6] J. Heer and G. Robertson, "Animated Transitions in Statistical Data Graphics," IEEE Trans. Visualization and Computer Graphics, vol. 13, no. 6, pp. 1240-1247, Nov. 2007.
[7] E. Papageorgiou, "Review Study on Fuzzy Cognitive Maps and Their Applications during the Last Decade," Proc. IEEE Int'l Conf. Fuzzy Systems (FUZZ), pp. 828-835, 2011.
[8] D. Iakovidis and E. Papageorgiou, "Intuitionistic Fuzzy Cognitive Maps for Medical Decision Making," IEEE Trans. Information Technology in Biomedicine, vol. 15, no. 1, pp. 100-107, Jan. 2011.
[9] S. Russell and P. Norvig, Artificial Intelligence: A Modern Approach, third ed. Prentice Hall, 2009.
[10] M. Risi, M.I. Sessa, G. Tortora, and M. Tucci, "Visualizing Information in Data Warehouses Reports," Proc. 19th Italian Symp. Advanced Database Systems (SEBD), pp. 246-257, 2011.
[11] S. Chaudhuri and U. Dayal, "An Overview of Data Warehousing and OLAP Technology," SIGMOD Record, vol. 26, pp. 65-74, 1997.
[12] J. Liu, Y. Wu, and G. Yang, "Optimization of Data Retrievals in Processing Data Integration Queries," Proc. Int'l Conf. Frontier of CS and Technology (FCST), pp. 183-189, 2009.
[13] V. Harinarayan, A. Rajaraman, and J.D. Ullman, "Implementing Data Cubes Efficiently," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD), pp. 205-216, 1996.
[14] The Graphical Editing Framework, http://www.eclipse.orggef, 2013.
[15] The Graphical Modeling Framework, http://www.eclipse.orggmf, 2013.
[16] The Adobe Illustrator, http://www.adobe.com/it/products illustrator , 2013.
[17] Pentaho BI Server, http://community.pentaho.com/projectsbi_ platform , 2013.
[18] Kettle: Pentaho Data Integration, http:/kettle.pentaho.com, 2013.
[19] N. Ma, M. Yuan, Y. Bao, Z. Jin, and H. Zhou, "The Design of Meteorological Data Warehouse and Multidimensional Data Report," Proc. Second Int'l Conf. Information Technology and CS (ITCS), pp. 280-283, 2010.
[20] N. Ma, Y. Zhai, Y. Bao, and H. Zhou, "Design of Meteorological Information Display System Based on Data Warehouse," Proc. Int'l Conf. Management and Service Science (MASS), pp. 1-4, 2010.
[21] K. Hsu and M.-Z. Li, "Applying Clustering Analysis on Grouping Similar Olap Reports," Proc. Second Int'l Conf. Computer Eng. and Applications (ICCEA), pp. 417-423, 2010.
[22] H. Su and J. Su, "A Study and Practice of Report System Techniques Based on Three-Layer Calculating Architecture," Proc. Second Int'l Workshop Education Technology and CS (ETCS), pp. 654-657, 2010.
[23] T. Wojciechowski, B. Sakowicz, D. Makowski, and A. Napieralski, "Transaction System with Reporting Capability in a Web-Based Data Warehouse Application Developed in Oracle Application Express," Proc. 10th Int'l Conf. CAD Systems in Microelectronics (CADSM), pp. 273-276, 2009.
[24] F. Anfurrutia, O. Diaz, and S. Trujillo, "A Product-Line Approach to Database Reporting," IEEE Latin Am. Trans. (Revista IEEE Am. Latina), vol. 4, no. 2, pp. 70-76, Apr. 2006.
[25] P. Hanrahan, "Vizql: a Language for Query, Analysis and Visualization," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD), pp. 721-721, 2006.
[26] S. Mansmann and M.H. Scholl, "Exploring OLAP Aggregates with Hierarchical Visualization Techniques," Proc. ACM Symp. Applied computing (SAC), pp. 1067-1073, 2007.
42 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool