Integração de dados de redes sociais a armazéns de dados

Abstract

Organizations are looking for different solutions to increase their competitiveness, because they need supply the market demands. Hence, fast and correct decisions are important to a company achieve better results. A company becomes more competitive when it has access to many data and information. In this context, a company can improve its competitiveness using valued information enriching its Data Warehouse with the unstructured web data (which increase every day). However, integrating unstructured and structured data is a challenge. Therefore, this work proposes a methodology for integrating unstructured and structured data increasing the aggregated value in a company's data warehouse. Such methodology was applied in a case study whose context is an online saless data warehouse to verify its viability. The data warehouse was enriched with five dimensions, which were extracted from the unstructured data gathered from Twitter. Metrics were defined to the analysis, and the results show that is a valid methodology to the data integration process, because such methodology can guides standardized actions to get better results in a company. Thus, gathered web data are transformed in useful information with strategic value to help the decision making process, as well as the increasing of knowledge database of an organization.