André Andrade Menolli
ABSTRACT
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.
- Logi Analytics. [n.d.]. What is Agile BI? - Logi Report BI Defined. https://www.jinfonet.com/resources/bi-defined/agile-bi/Google Scholar
- 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.Google Scholar
- K. Collier. 2013. Agile analytics: a value-driven approach to business intelligence and data warehousing. Addison-Wesley.Google ScholarDigital Library
- 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.xGoogle ScholarCross Ref
- 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.1893180Google ScholarDigital Library
- J. Hyde. [n.d.]. Mondrian Documentation. https://mondrian.pentaho.com/documentation/architecture.phpGoogle Scholar
- W. Inmon. 2002. Building the data warehouse. Wiley.Google ScholarDigital Library
- R. Kimball and M. Ross. 2002. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley.Google Scholar
- 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.304215Google ScholarDigital Library
- 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.Google Scholar
- 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.Google ScholarDigital Library
- L. Serbanescu. 2017. QLIKVIEW APPLICATION - SUPPORT IN DECISION MAKING. Scientific Bulletin - Economic Sciences 16, 2 (2017), 3–10.Google Scholar
- 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.567Google ScholarDigital Library
Index Terms
- An Agile Data Warehouse Virtualization Framework for ROLAP Server
Recommendations
Design of ETL Tool for Structured Data Based on Data Warehouse
CSAE '20: Proceedings of the 4th International Conference on Computer Science and Application EngineeringThis paper takes the current business system of a mobile communication-equipment-chain sales-service-company as an example, and analyzes the problem that the data from multiple data sources cannot directly be loaded into the data warehouse by the ...
Agile Data Warehouse -- The Final Frontier: How a Data Warehouse Redevelopment Is Being Done in an Agile and Pragmatic Way
AGILE '12: Proceedings of the 2012 Agile ConferenceAlthough much progress has been made to plan and execute Software Development projects in an agile manner, Data Warehouse or Business Intelligence projects seem to still execute in a more traditional manner. Data Warehouse projects are quite different ...
Alliance Rules for Data Warehouse Cleansing
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing SystemsData Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in ...
Comments