An Extraction, Transformation, and Loading Tool Applied to a Fuzzy Data Mining System

In this chapter, we address the problem of integrating semantically heterogeneous data (including data expressed in natural language), which are collected from various questionnaires published in different websites, into a Data Warehouse. We present an extension of the sentences and architecture of data mining Fuzzy Structured Query Language as an extraction, transformation, and loading tool to integrate semantically heterogeneous data from these websites. Moreover, we show a case study using the questionnaires (carried out during several years) about the courses on Information and Communication Technologies which are taught in the Business Studies implanted at the University of Granada (Spain). With this integrated information, the Data Warehouse user can make several analyses with the benefit of an easy linguistic interpretability. The solution proposed here can be used to similar integration problems.