Uma abordagem baseada no processo de ETL integrado aos indicadores de negócios através de visões materializadas em data warehouse para auxiliar na tomada de decisão

Abstract

Although the technologies and innovations in the market is still a common practice in small and medium enterprises, manual obtain business indicators. In this research we propose an approach to the process of extraction, transformation and loading of data (Extract Transform Load -ETL) is integrated with business indicators (Key Performance Indicator - KPI) through materialized views. This process of integration has the following advantages: (i) Instead of replicating the operational database completely, only carry the data for business indicators. Thus it can be in addition to the performance data of the gain, reduce the space allotted on disk. (Ii) With the change of the database, updating the data warehouse would occur only if the tables were relevant to the business indicators and, consequently, a faster refresh. (Iii) With the use of materialized views for optimizing queries, the data is available in near real time