Desenvolvendo soluções de Business Intelligence para empresas sergipanas

Abstract

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.