title: Application of an integrated multi-criteria decision making AHP-TOPSIS methodology for ETL software selection.
abstract: Actually, a set of ETL software (Extract, Transform and Load) is available to constitute a major investment market. Each ETL uses its own techniques for extracting, transforming and loading data into data warehouse, which makes the task of evaluating ETL software very difficult. However, choosing the right software of ETL is critical to the success or failure of any Business Intelligence project. As there are many impacting factors in the selection of ETL software, the same process is considered as a complex multi-criteria decision making (MCDM) problem. In this study, an application of decision-making methodology that employs the two well-known MCDM techniques, namely Analytic Hierarchy Process (AHP) and Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) methods is designed. In this respect, the aim of using AHP is to analyze the structure of the ETL software selection problem and obtain weights of the selected criteria. Then, TOPSIS technique is used to calculate the alternatives' ratings. An example is given to illustrate the proposed methodology. Finally, a software prototype for demonstrating both methods is implemented.
authors.affiliation: Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco.
authors.forename: Mohamed
authors.initials: M
authors.lastname: Hanine
authors.affiliation: Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco.
authors.forename: Omar
authors.initials: O
authors.lastname: Boutkhoum
authors.affiliation: Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco.
authors.forename: Abdessadek
authors.initials: A
authors.lastname: Tikniouine
authors.affiliation: Team of Telecommunications and Computer Networks, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco.
authors.forename: Tarik
authors.initials: T
authors.lastname: Agouti
keywords: AHP (analytic hierarchy process); Business Intelligence; ETL; ETL software selection problem; MCDM (multi-criteria decision making); TOPSIS (technique for order preference by similarity to ideal solution)