JointOLAP - Information System for Exploration Joint Structured and Text Data: A case study in the electric sector
Abstract
With the increasing generation of structured and unstructured data, internally and externally to the enterprises, approaches have been proposed to process and present this information, enriching their analytical capabilities. But few have addressed it in an integrated way, joint exploration and taking advantage from the analytical processing facilities offered by OLAP tools. Thus, this paper proposes JointOLAP, an integrated architecture for joint exploration of structure and unstructured data applied in a real scenario with the development of an analytical information system, called PowerOLAP. It allows the enrichment of the analyses of disturbances on the Brazilian integrated electrical system with their impact reflected in the news. Examples of analyses illustrate its analytical potential.
References
Cardoso, C., & Polidoro, M. (2011). Gestão do Risco da Imagem Institucional. Congresso de Comunicação Empresarial ABERJE.
Chakaravarthy, V. T., Gupta, H., Roy, P., & Mohania, M. (2006). Efficiently linking text documents with relevant structured information.
Costa, P. R., Souza, F. F., Times, V. C., & Benevenuto, F. (2012, Julho). Towards integrating Online Social Networks and Business Intelligence.
Heuseler, F. M. (2010). Uma abordagem multifacetada para exploração integrada de dados estruturados e não-estruturados em ambientes OLAP. Dissertação de Mestrado .
Inmon, W. (2005). Building the Data Warehouse. Wiley.
Inmon, W. H., Strauss, D., & Neushloss, G. (2008). DW 2.0: The Architecture for the Next Generation of Data Warehousing. Kimball, R. (2004). The Data Warehouse ETL Toolkit. Wiley.
Kimball, R., & Ross, M. (2002). The Data Warehouse Toolkit. Wiley.
Malinowski, E., & Zimányi, E. (2011). Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications.
Moreira, J. L., Cordeiro, K. F., & Campos, M. L. (2009). DoctorOLAP: Ambiente para análise multifacetada de prontuários médicos. Artigo apresentado no SBBD 2009 .
Nelson, G. S. (2010). Business Intelligence 2.0: Are we there yet? SAS Global Forum .
Nesavich, A., & Inmon, W. H. (2007). Tapping into Unstructured Data: Integrating Unstructured Data and Textual Analytics into Business Intelligence.
ONS. (2009). Procedimentos de Rede – http://www.ons.org.br/procedimentos
Park, B.-K., & Song, I.-Y. (2011). Toward Total Business Intelligence Incorporating Structured and Unstructured Data.
Perez, J. M., Pedersen, T. B., Berlanga, R., & Aramburu, M. J. (2005). IR and OLAP in XML document warehouses.
Roy, P., Mohania, M., Bamba, B., & Raman, S. (2005). Towards automatic association of relevant unstructured content with structured query results.
Russom, P. (2007). BI Search and Text Analysis Tics: New Additions to the BI Technology Stack.
