Affiliations: [a] MIRACL Laboratory, ISIMS, Technology Center of Sfax, Sakiet Ezzit, Sfax, Tunisia | [b] MIRACL Laboratory, University of Sfax, Sfax, Tunisia
Correspondence:
[*]
Corresponding author: Hana Mallek, MIRACL Laboratory, ISIMS, Technology Center of Sfax, Sakiet Ezzit, Sfax, 3021, Tunisia. E-mail: mallekhana@gmail.com.
Abstract: As the amount of information exceeds the management and storage capacity of traditional data management systems, several domains need to take into account this growth of data, in particular the decision-making domain known as Business Intelligence (BI). Since the accumulation and reuse of these massive data stands for a gold mine for businesses, several insights that are useful and essential for effective decision making have to be provided. However, it is obvious that there are several problems and challenges for the BI systems, especially at the level of the ETL (Extraction-Transformation-Loading) as an integration system. These processes are responsible for the selection, filtering and restructuring of data sources in order to obtain relevant decisions. In this research paper, our central focus is especially upon the adaptation of the extraction phase inspired from the first step of MapReduce paradigm in order to prepare the massive data to the transformation phase. Subsequently, we provide a conceptual model of the extraction phase which is composed of a conversion operation that guarantees obtaining NoSQL structure suitable for Big Data storage, and a vertical partitioning operation for presenting the storage mode before submitting data to the second ETL phase. Finally, we implement through Talend for Big Data our new component which helps the designer extract data from semi-structured data.
Keywords: Extraction phase, ETL processes, big data, conceptual modeling
