Projeto e implementação de uma arquitetura ROLAP para auxiliar o ensino de ferramentas de suporte à decisão

Abstract

ROLAP tools represent a significant part of the software market focused on analysis and query generation in decision support environments. Knowledge of the architecture of these tools is crucial for professionals working in the area of business-minded intelligence. This knowledge facilitates the process of implementation, maintenance, migration to other technologies and procurement of products. However, the existing tools in the market, whether commercial or not, due to their complexity, prevent students and professionals from being able to understand their main modules and realize that the different tools use the same principles. In this work, through the definition of a minimum set of requirements required for a ROLAP solution, a prototype was developed to assist in teaching about architectural features and modules of this class of tool. The first evaluations of the prototype, carried out through the use of dimensional modeling exercises and the analysis of its code, have shown that it can be a strong ally in the teaching of decision support tools.