An Agile Data Warehouse Virtualization Framework for ROLAP Server

  • André Andrade Menolli Universidade Estadual do Norte do Paraná / Universidade Estadual de Londrina
  • Ricardo Gonçalves Coelho Universidade Estadual do Norte do Paraná
  • Glauco Carlos Silva Universidade Estadual do Norte do Paraná
  • Elielson Barbosa Tribunal Regional do Trabalho

Resumo


In order to adapt to a competitive business scenario, the decision-making needs to be fast and reliable. In this panorama, agile business intelligence emerges as a resource to provide agile solutions. To achieve agile business intelligence solutions, organizations consider real-time data warehousing a powerful technique. Thus, we propose in this paper a framework based on data warehouse virtualization and real-time data warehousing concepts, called Agile ROLAP. The framework is comprised of an approach designed to be compatible with the main consolidated DW concepts. Furthermore, a set of components that enable the deployment of each step of the Agile ROLAP process was implemented. We evaluated our proposed approach in an experimental study where we deployed dimensional models from three distinct databases. It was analyzed the approach viability and the performance through query performance. The results indicate that the approach is viable, and the performance is satisfactory for no very large databases.

Palavras-chave: data warehouse, real-time data warehousing, agile business intelligence, virtualization, ROLAP server

Referências

Logi Analytics. [n.d.]. What is Agile BI? - Logi Report BI Defined. https://www.jinfonet.com/resources/bi-defined/agile-bi/

R. Bruckner, B. List, and J. Schiefer. 2002. Striving towards Near Real-Time Data Integration for Data Warehouses. In Data Warehousing and Knowledge Discovery. Springer Berlin Heidelberg, Berlin, Heidelberg, 317–326. 

K. Collier. 2013. Agile analytics: a value-driven approach to business intelligence and data warehousing. Addison-Wesley. 

F. Farooq. 2013. The data warehouse virtualization framework for operational business intelligence. Expert Systems 30, 5 (2013), 451–472. https://doi.org/10.1111/j.1468-0394.2012.00651.x arXiv: https://onlinelibrary.wiley.com/doi/pdf/10.1111/j.1468-0394.2012.00651.x

O. Grabova, J. Darmont, J. Chauchat, and I. Zolotaryova. 2010. Business Intelligence for Small and Middle-Sized Entreprises. SIGMOD Rec. 39, 2 (Dec. 2010), 39–50. https://doi.org/10.1145/1893173.1893180

J. Hyde. [n.d.]. Mondrian Documentation. https://mondrian.pentaho.com/documentation/architecture.php

W. Inmon. 2002. Building the data warehouse. Wiley. 

R. Kimball and M. Ross. 2002. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley. 

Y. Kotidis and N. Roussopoulos. 1999. DynaMat: A Dynamic View Management System for Data Warehouses. In Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data (Philadelphia, Pennsylvania, USA) (SIGMOD ’99). Association for Computing Machinery, New York, NY, USA, 371–382. https://doi.org/10.1145/304182.304215

Kimball R.; Reeves L.; Ross M. and Thornthwaite W.1998. The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses. John Wiley & Sons Inc. 

S. T. March and A. Hevner. 2007. Integrated decision support systems: A data warehousing perspective. Decision Support Systems 43, 3 (2007), 1031 – 1043. https://doi.org/10.1016/j.dss.2005.05.029 Integrated Decision Support.

L. Serbanescu. 2017. QLIKVIEW APPLICATION - SUPPORT IN DECISION MAKING. Scientific Bulletin - Economic Sciences 16, 2 (2017), 3–10.

M. Zimmer, H. Baars, and H. Kemper. 2012. The Impact of Agility Requirements on Business Intelligence Architectures. In 2012 45th Hawaii International Conference on System Sciences. 4189–4198. https://doi.org/10.1109/HICSS.2012.567
Publicado
07/06/2021
MENOLLI, André Andrade; COELHO, Ricardo Gonçalves; SILVA, Glauco Carlos; BARBOSA, Elielson. An Agile Data Warehouse Virtualization Framework for ROLAP Server. In: SIMPÓSIO BRASILEIRO DE SISTEMAS DE INFORMAÇÃO (SBSI), 17. , 2021, Uberlândia. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2021 .