Search Approach for External Data Sources for Data Warehouse Enrichment in Business Intelligence Context

In Business Intelligence (BI) systems, decision-making is based on data warehouses (DW), alimented, generally, from internal sources to the organization. Decision-making based solely on this data, sometimes, gives a partial and limited view of certain activities. Consequently, the decision maker finds himself constrained to search additional information on the Web in order to understand the external environment. This information can be found in external data sources as the Open Data (OD), to complete a decisional analysis. Therefore, it is valuable to enrich DWs with external data sources. In this context, we propose, in this paper, an approach that aims to explore the Web in order to search and select appropriate OD sources for DW enrichment. This approach is carried out on the basis of Natural Language Processing (NLP) techniques as well as a scrapping process related to the Google Dataset Search engine, in order to provide an efficient solution for making decisions to validate this approach, a tool called "Open Data Search" is developed and the obtained results are presented.