Desenvolvendo soluções de Business Intelligence para empresas sergipanas

• Autor(a) principal: Aragão, Felipe Morais
• Data de Publicação: 2019
• Tipo de documento: Trabalho de conclusão de curso
• Idioma: por
• Título da fonte: Repositório Institucional da UFS
• Texto Completo: http://ri.ufs.br/jspui/handle/riufs/12495
• topic: Ciência da computação; Ensino de ciência da computação; Extract; Transform e Load (ETL); Banco de dados; Data Warehouse (DW); Business Intelligence (BI); Change Data Capture (CDC); CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::METODOLOGIA E TECNICAS DA COMPUTACAO::BANCO DE DADOS

Nowadays, the acquisition of real-time information is necessary to support decision making. A common characteristic among companies that have developed this type of solution is the nondistinction between the On-Line Transaction Process (OLTP) and On-Line Analytical Process (OLAP). Therefore, user’s satisfaction may decline over the years. This paper aims to build an OLAP environment to support real-time analytic queries with the integration through an Extract, Transform and Load (ETL) in conjunction with Change Data Capture (CDC) for continuous loads. Data was collected from Sergipe’s market focusing on specific information on the use of its workloads.The results demonstrated that the vast majority of companies uses Microsoft SQL Server database management system. In addition, we selected one company as a tester to perform code analysis in Structured Query Language (SQL), interviews and requirements collection. The achieved outcomes were satisfactory as the large majority of the comparative aspects expressed superiority, thus solving the company’s performance issues and incapacity to provide real-time information. CDC is a great choice for analytical environments once it works asynchronously and has a low impact on the OLTP environment. Therefore, CDC is a good choice for updating information on a low latency DW.