 Methodology
 Open Access
 Published:
Application of an integrated multicriteria decision making AHPTOPSIS methodology for ETL software selection
SpringerPlus volume 5, Article number: 263 (2016)
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 multicriteria decision making (MCDM) problem. In this study, an application of decisionmaking methodology that employs the two wellknown 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.
Background
Business Intelligence (BI) is a field of information systems architecture. It allows implementing the means to collect, transform and restore data to assist decisionmakers in enterprises. The heart of BI is based on data warehouses powered by ETL, which is generally a part of BI and is usually the starting point for each project. With the development of the use of BI, ETL becomes a critical factor affecting the success of a BI project. In the surveys conducted to determine important questions touching decisionmakers and designers of BI projects (Simitsis et al. 2009; Wyatt et al. 2009), ETL software has been ranked among the highest priorities (Kimball and Caserta 2004).
One of the important and initial activities of a BI project is the selection of the most appropriate ETL software. In other words, the chosen software must be in accordance with the organizational goals and has to maximize the benefits of the organization. Then, choosing ETL software is a wise choice that limits the costs and risks associated with projects.
Moreover, decision making in the field of Business Intelligence software selection such as ETL, has become more complex due to a large number of software products in the market. For choosing the most appropriate software, in this regard, ISO/IEC 91261 (2001) has established six quality characteristics for any software products: Functionality, Reliability, Usability, Efficiency, and Maintainability.
Due to the multicriteria nature for selecting ETL software, multicriteria decision making (MCDM) has been found to be a powerful and suitable technique to solve this type of selection problems. The analytical model integrated with AHP (Analytical Hierarchy Process) method and TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) will help to determine the right judgment in ETL software selection based on decisionmakers’ specific requirements. This paper proposes an integrated AHPTOPSIS model considering both qualitative and quantitative factors. In this respect, AHP can be very useful in involving several decisionmakers with multiple conflicting criteria to arrive at a consensus in the decision making process. On the other side, TOPSIS technique is used to calculate the alternatives ratings.
The remainder of the paper is organized as follows. The second section gives a brief overview of existing methods and studies for software selection. In section three, the methods used in the proposed decisionmaking methodology are presented. The proposed methodology is concisely explained in the fourth section. As regards the next section, for better understanding of the methodology, an empirical study is illustrated, and sensitivity analysis is highlighted. The implementation of a software prototype for demonstrating the proposed methodology is given in section six. Finally, conclusions and further research are offered in the last section.
Software selection review
The problem of the choice of BI tools is one of the strategic decisions that have a significant impact on business performance. With the evolution of decision support systems, the making decision becomes increasingly critical. However, ETL software selection is considered to be a highly important research issue in BI (Simitsis et al. 2009), but it has not yet received much attention in research as further as research on this subject is necessary. One of the main motivations of this research is the absence of evidence in the literature that such papers do not employ a methodological approachsuch as AHPTOPSISfor evaluating and selecting ETL software.
The state of the art is very rich by various methods suggested for the selection problem (Amiri 2010). All the methods can be classified in four different categories: MCDM (multicriteria decision making) is the first category which contains different methods such as: AHP, ANP (Analytical Network Process), PROMETHEE (preference ranking organisation method for enrichment evaluations), ELECTRE (ELimination and Choice Expressing Reality) TOPSIS etc. Wei et al. (2005) used the AHP method to identify priority in selecting ERP System. Similarly, Yigit et al. (2014) developed an interactive model using AHP to facilitate the selection of Webbased learning object software. Besides, Göztepe (2012) applied ANP method to appraise and select the best Operating system with regard to organizational factors and strategic performance metrics. Behzadian et al. (2012) asserted a TOPSIS based model for multi criteria decision making in another study.
The second category concerns mathematical programming methods. Data Envelopment Analysis (DEA) and linear programming methods can be included in this category. Lengacher and Cammarata (2012) suggested a DEA model to evaluate and select Portfolio. As another model, Liu (2012) developed a weighted linear programming method for the site selection of distribution center problem.
Artificial Intelligence methods, as a third category, contain genetic algorithm, artificial neural network (ANN) and data mining methods. In this context, Guo et al. (2011) presented a Genetic Algorithm for Optimized Feature Selection with Resource Constraints in Software Product Lines. Similarly, Flintsch et al. (1998) suggested an artificial neural network model for project selection level pavement management system.
The last category is concerned with integrated approaches. There are so many studies about integrated methods for software selection problem in the literature. Onder and Dag (2013), proposed an approach based on AHP and improved TOPSIS for the supplier selection problem. In another study, KueiYang Wu (2010) proposed an integrated approach of Fuzzy AHP for Constructing Evaluation Model for Sustainable Development in Community Health and Welfare. Eldrandaly and Naguib (2013) from another scale, proposed an integrated approach of expert system and AHP to select the best GIS software. Similarly, Zaidan et al. (2015) presented an approach based on integrated AHP and TOPSIS to select the optimal opensource EMR software packages.
In this study, we choose an integrated approach which combines AHP and TOPSIS methods. AHP method is an excellent MCDM technique as it provides a structure and hierarchy method for synthesizing software selection problems which is used to calculate the weight of selected criteria (Lin et al. 2007), and TOPSIS technique is employed to rank the alternative software based on their overall performance.
The proposed integrated methodology has many advantages compared to the previously proposed techniques in the literature as follows: (1) it is suitable for the evaluation and selection of ETL software to consider the decisionmakers’ preferences depending on their knowledge and experiences; (2) the weights of multiple and conflicting criteria are obtained by using pairwise comparisons according to preferences of the decisionmakers; and (3) the global ranking of the software alternatives are provided.
Multicriteria decisionmaking methods
Analytical hierarchy process method (AHP)
AHP is a multicriteria decision making method that was proposed in the 1970s by Saaty. It has been used extensively for analyzing and structuring complex decision problems. The decision problem is first decomposed into different criteria (Dagdeviren et al. 2009). The AHP method can be used to assist decisionmakers to calculate the weight for each criterion by using pairwise comparison judgments (Liberatore and Nydick 1997; Yoo and Choi 2006; Panda et al. 2014).
AHP technique is a process that consists of the following steps (Saaty and Vargas 2001; Saaty 2008):

Step 1: Structure the decision hierarchy taking into account the goal of the study and determine the criteria and subcriteria.

Step 2: Establish a set of all judgments in the comparison matrix in which the set of elements is compared to itself by using the fundamental scale of pairwise comparison shown in Table 1.

Step 3: Determine the relative importance of factors by calculating the corresponding Eigenvectors to the maximum Eigen values of comparison.

Step 4: Verify the consistency of judgments across the Consistency Index (CI) and the Consistency Ratio (CR).
$$CI = \frac{\lambda_{\rm max}  n}{n  1}$$(1)where λ_{max} is the Eigen value corresponding to the matrix of pairwise comparisons and n is the number of elements being compared.
Consistency ratio (CR) is defined by:
where, (RCI) is a random consistency index defined in Table 2.
A value of CR less than 0.1 is generally acceptable; otherwise the pairwise comparisons should be revised to reduce incoherence.
Technique for order preference by similarity to ideal solution (TOPSIS)
TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) method was developed by Hwang, and Yoon (1981), for solving multiple criteria decision making (MCDM) problems based upon the concept that the chosen alternative should have the shortest distance to the positive ideal solution (A*) and the longest distance from the negative ideal solution (A−). For instance, the positive ideal solution maximizes the functionality and minimizes the cost, whereas the negative ideal solution maximizes the cost and minimizes the functionality. In the process of TOPSIS, the performance ratings and the weights of the criteria are given as exact values (Lengacher and Cammarata 2012). Recently, several interesting studies have focused on the TOPSIS technique and applied it in many fields, including supplier selection, tourism destination evaluation, financial performance evaluation, location selection, company evaluation, and ranking the carrier alternatives. Examples of these studies can be found in the literature such as ERP software selection (Huiqun and Guang 2012), customerdriven product design process (Lin et al. 2008), opensource EMR software packages (Zaidan et al. 2015). The steps of TOPSIS model are as follows (Tsaur 2011; Ding 2012):

Step 1: Establish a decision matrix for the ranking.

Step 2: Normalize the decision matrix using the following equation.
$$e' = \left[ {\frac{{g_{j} (a_{i} )}}{{\sqrt {\sum\nolimits_{i = 1}^{m} {\left[ {g_{i} (a_{i} )} \right]^{2} } } }}} \right]; \, \quad {\text{i}} = 1, \, 2,\ldots,{\text{ m}};{\text{ and j}} = 1,2, \ldots, {\text{ n}}$$(3)where gi is deterministic value of alternative i for criterion j.

Step 3: Calculate the weighted normalized decision matrix by multiplying the normalized decision matrix with its associated weights as:
$$e^{*}_{ij} = \pi_{j} \times e^{\prime}_{ij} ;\quad {\text{ i}} = 1,{ 2},\ldots,{ m};{\text{ and }}\,\, {\text{j}} = 1, 2,\ldots,{\text{ n}}$$(4)where π_{j} is the weight of jth criterion.

Step 4: Identify the positive ideal solution (A*) and negative ideal solution (A −).
$$\begin{aligned} &{\text{Positive}}{:} \\ &A^{*} = \left\{ {e_{j}^{*} , j = 1, 2, \ldots, n} \right\} = \left\{ {e_{ 1}^{*} , e_{ 2}^{*} ,\ldots, e_{n}^{*} .} \right\};e_{j}^{*} = Max_{i} \left\{ {e_{ij}^{''} } \right\} \\ &A^{*}  = \{ Min_{i} .e_{ij}^{*} ,\,\, i = 1, \ldots, m; \,\, and\,\, j = 1,\ldots, n\} \\ \end{aligned}$$(5)$$\begin{aligned} {\text{Negative}}{:} \hfill \\ A  =& \left\{Min_{i}\, {e_{ij}^{''} \left. {,\quad i = 1,\ldots,m;and \, j = 1,\ldots, n}\right\}} \right.;\quad e_{j^*} = Min_{i} \{ e_{ij}^{''} \} \hfill \\ A  =& \left\{ {e_{j^*} ,j = 1,2,\ldots,n} \right\} = \{ e_{1^*} ,e_{2^*}, \ldots, e_{n^*} \} \hfill \\ \end{aligned}$$(6) 
Step 5: Determine the Euclidean distance of each alternative from the positive and negative ideal solutions.
$$D_{i}^{*} = \sqrt {\sum\limits_{j = 1}^{n} \left(e^{*}_{ij}  e^{*}_{j} \right)^{2}} ,\quad {\text{ i}} = 1, 2, \ldots {\text{m}}$$(7)$$D_{i}^{} = \sqrt {\sum\limits_{j = 1}^{n} \left( e^{*}_{ij}  e_{j^{*}} \right)^{2}} ,\quad {\text{ i}} = 1, 2, \ldots {\text{m}}$$(8) 
Step 6: Calculate the relative closeness coefficient of the i th alternative to ideal solution using the following equation:
$$C_{i}^{*} = \frac{{D_{i}^{  } }}{{D_{i}^{*} + D_{i}^{  } }}, \, \quad {\text{i}} = 1, 2, \ldots,{\text{m}}$$(9)With, 0 ≤ Ci* ≤ 1.

Step 7: Rank all alternatives based on decreasing values of Ci* and selecting the optimal one.
Proposed integrated multicriteria decision methodology
Over the last decades, many researchers have devoted their effort to design the best methodologies for decisionmaking. The proposed methodology is designed in such a way that makes the use of MCDM techniques as efficient as possible. Two different techniques, namely AHP and TOPSIS, are combined in order to rank alternative software according to criteria. The reason for using the wellknown AHP technique is to structure the decision hierarchy of the problem. Finally, to rank the alternatives, one of the most efficient MCDM techniques such as TOPSIS is used.
Hereafter, the main steps of the proposed integrated methodology to be elaborated by decisionsmakers for the ETL software selection problem are as follows:

Step 1: Define criteria and subcriteria that are most affecting in the ETL software selection problem.

Step 2: Construct a hierarchy decision model for the problem.

Step 3: Determine the comparison matrix for each level (level of criteria and subcriteria) by using AHP technique to obtain the local weight of each criterion and subcriterion.

Step 4: Determine the global weight by normalizing the local weight.

Step 5: Use the TOPSIS technique to assess the alternatives where the most appropriate one can be easily selected.

Step 6: Select the best ETL software alternative.
Figure 1 illustrates the process of the proposed integrated methodology to evaluate and select the ETL software.
Numerical illustration
In this section, to better understand of the proposed integrated methodology, an application is provided. The ETL software selection decision is very important in longterm planning for any Business Intelligence project and is required due to various reasons, such as very expensive and opensource software available in the market. Then each tool uses its own methodology for extracting, transforming, and loading of data. Hence, decisionmakers should select the software for a new project that not only performs well, but also is flexible enough to accommodate future changes in the project. The success or failure of any project depends on the consideration of various criteria when selecting new ETL software, such as: Functionality, Vendor, Usability, Cost, and Reliability (Wyatt et al. 2009; Kimball and Caserta 2004). In fact, conflicting criteria have high impact on the software performance. In this case, selection of the suitable ETL software involves the consideration of multiple feasible alternatives under multiple influential criteria. The problem is then solved by using the proposed approach explained in Fig. 1.
The integrated methodology is applied step by step to solve the ETL software selection problem for the BI project. After preliminary screening, five software: S1, S2, S3, S4 and S5, are chosen for further assessment. Hereafter, the main steps of the application of the proposed multicriteria decision methodology for ETL software selection is elaborated.
Furthermore, the identification of the criteria and the subcriteria is the first step of the proposed methodology. Based on the literature review and recent experiences of some specialists, in order to identify some general decisionmaking attributes (criteria) for selecting the best ETL software, we propose five main criteria and fifteen subcriteria, which are the most prevalent and important in the selection of ETL software (Step 1).
The five main criteria Functionality, Vendor, Usability, Cost, and Reliability, are further broken down into subcriteria. Functionality is characterized by compatibility, scheduler, category, support BI (Business Intelligence) and security. Vendor is divided into technical capability, reputation and provides permanent services. Additionally, Usability is associated with ease of use and completeness of the GUI (graphical user interface), while Cost criterion is broken down into maintenance cost, consultant expense and price. Reliability is finally divided into stability and recovery ability.
In the following, decisionmakers follow the computational procedure of weights for selected criteria using AHP method, and then rank the alternatives with TOPSIS method. In the first step of AHP technique, we developed a hierarchy model of ETL software selection based on the criteria, subcriteria, and alternatives (Step 2). As shown in Fig. 2, the highest and the lowest levels of the hierarchy denote the overall objective (selecting the most appropriate ETL software) and the software proposed (S1, S2, S3, S4, and S5) respectively. The five main criteria are included in the second level (Mousavi et al. 2012) and are further broken down into subcriteria in the third level.
Once the hierarchy has been constructed through the AHP technique, the next step is dedicated to obtain the weights of elements at each level of the hierarchy. A set of comparison matrices of all elements for each level of the hierarchy with respect to elements of the higher level are realized. The preferences of decisionmakers are identified using Saaty scale (Saaty 2008) as shown in Table 1.
The initial pairwise comparison matrix for the main criteria provided by decision makers is presented in Table 3. Moreover, the matrix of subcriteria of the first main criterion C1 (i.e., Functionality) presented by decisionmakers is given in Table 4 (Step 3). Other comparison matrices of the subcriteria are not shown here. But, Table 5 shows all weight vectors calculated by pairwise comparisons as similar to C1 in Table 4 (Step 4). Ultimately, the consistency ratio (CR) of each pairwise comparison judgment matrices is also shown below in each matrix. It can be seen that the CR of each matrix is less than 0.1.
At the final step, TOPSIS method is applied in order to rank the alternative software. The global weights of each subcriterion which are calculated by AHP can be used as the input in TOPSIS method. Then using the scale in Table 1, the decisionmakers are asked to evaluate the alternatives according to each subcriterion (Table 6) (Step 5.1). The second step in TOPSIS technique is the normalizing of the aggregate ratings matrix, using the Eqs. (3), (4), as illustrated in Table 7 and thereafter, by using the Eqs. (5), (6), we can calculate the positive and negative ideal solutions (i.e., A* and A−) for the five alternatives (Step 5.2).
The ranking of alternative software are calculated by using the Eqs. (7), (8), and (9). Table 8 shows the evaluation results and final ranking of alternatives. Therefore, the best alternative is the one with the shortest distance to the positive ideal solution and with the longest distance to the negative ideal solution. The proposed model results show that software 3 is the best alternative with Ci value of 0.0084 (Step 6).
A sensitivity analysis is performed to analyze the two phases AHP and TOPSIS methodology proposed in this paper. For this reason, the criteria weights obtained from AHP are exchanged between two criteria while the others are constant. In other words, the weight of the first criterion C11 is exchanged with C12, C13 … and C52, sequentially, while the others are constant. For each case, the A*, A− and the closeness coefficient (Ci) are calculated to display the new results and hence sixteen combinations (by adding the equal weight criterion) of the fifteen subcriteria are analyzed (Gumus 2009). Then, the details of all the cases are summarized in Table 9 and the closeness coefficient with ranking of the alternatives are shown both in Table 10 and graphically represented in Fig. 3.
From Table 10 and Fig. 3, it can be seen that the first case describes the original results of the integrated methodology. Also, out of sixteen cases, alternative software S3 has the highest score in all cases. Moreover, the results of the sensitivity analysis indicate that the alternatives’ ranking has changed significantly according to equal weights of the criteria. Therefore, we can say that, based on the evaluations obtained, our decision making process is relatively insensitive to the criteria weights with S3 emerging as the winner of all the cases (Mousavi et al. 2012).
Proposed software
As can be easily proved, AHP and TOPSIS require many timeconsuming calculations, depending upon the number of the criteria, subcriteria and alternatives that are necessary to make all calculations in order to reach the final solution (Duran 2011). As the number of criteria increases, the dimension of the problem expands. This could lead to a great number of mathematical operations. Therefore, software aid may be very useful to automatically carry out the methodology process. A software prototype for this methodology (AHPTOPSIS) application is developed. This software is programmed by using JAVA on a PC platform. The operation sequence will be demonstrated in the following paragraphs through the use of several screenshots.
Initially, the user must supply the criteria and subcriteria chosen for the evaluation of the ETL software. The software prototype keeps a series of attributes that the user can select to perform the comparison analysis in a database. Moreover, the database contains a set of generic criteria and subcriteria labeled as ‘‘criterion i’’ and “subcriterion j” where ‘‘i and j’’ stands for the number of a given criterion and subcriterion in order. Then, the user must fill the pairwise comparisons matrix for the criteria and subcriteria. Figure 4 shows the Combo Box where the analyst can input the pairwise comparisons among the software’s criteria (using the scale of AHP). Once the comparison matrix is entirely filled with importance values, the ratio of consistency (CR) is computed automatically. In Fig. 5, the system provides the Eigenvector of the five criteria and the fifteen subcriteria according to the information inputted by the user.
In the second part of the software, concerning the application of TOPSIS method, it is assumed that users must input the pairwise comparisons of the five specific ETL software proposed. This task is made accordingly to each one of the considered subcriteria (Fig. 6). In the next step, the weighted normalized decision matrix is calculated, and the system must identify the positive A* and negative A− ideal solutions (Fig. 7).
Finally, the software finds the scores of the ETL alternatives with respect to criteria and subcriteria. It displays the results using the calculation of the distance between positive and negative ideal solutions. Therefore, the values and the priority scores for the ETL software alternatives are obtained. The ranked list indicates that in this case the alternative software with the higher value of Ci has to be selected by the users as illustrated in Fig. 8.
Conclusion
Nowadays, ETL software play an essential role in Business Intelligence (BI) projects, selecting suitable ETL software has become one of the most important issues for starting a BI project. Our contribution presents an application of methodology based on a hybrid multicriteria decision making process. The methodology consists of two techniques: analytical hierarchy process (AHP) and technique for order preference by similarity to ideal solution (TOPSIS). This methodology is tested by an example and it was found that it functions satisfactorily. Five software of ETL are chosen to demonstrate how the approach is applied and lead to the selection of the software consistent with the maximization of the underlying techniques for all the decisionmakers. Additionally, an AHPTOPSIS methodology based software for selecting ETL software was proposed.
Although, the integrated methodology and the software prototype are introduced for ETL software selection problem, it can also be applied for any other software selection problem involving multiple and conflicting criteria. For further studies, different techniques of MCDM, such as ELECTRE, MACBETH, PROMETHEE, can be used and comparison of the results can be explored. Probably, the pairwise comparison of the proposed methodology seems insufficient and too imprecise to capture exactly the judgments of decisionmakers, which is serious limitation. Regarding this point, the methodology can be considered under the fuzzy environment.
References
Amiri MP (2010) Project selection for oilfields development by using the AHP and fuzzy TOPSIS methods. Expert Syst Appl 37(9):6218–6224. doi:10.1016/j.eswa.2010.02.103
Behzadian M, Otaghsara SK, Yazdani M (2012) Ignatius J (2012) A stateof theart survey of TOPSIS applications. Expert Syst Appl 39(17):13051–13069
Dağdeviren M, Yavuz S, Kılınç N (2009) Weapon selection using the AHP and TOPSIS methods under fuzzy environment. Expert Syst Appl 36(4):8143–8151
Ding JF (2012) Using Fuzzy MCDM Model to Select Middle Managers for Global Shipping Carrierbased Logistics Service Providers. WSEAS Transactions On Systems, 11(3)
Duran O (2011) Computeraided maintenance management systems selection based on a fuzzy AHP approach. Adv Eng Software 42(10):821–829
Eldrandaly K, Naguib S (2013) A KnowledgeBased System for GIS Software Selection. Int Arab J Inf Technol 10(2):2013
Flintsch G, Zaniewski J, Delton J, Medina A (1998) Artificial Neural Network Based Project Selection Level Pavement Management System. In 4th International Conference on Managing Pavements
Göztepe K (2012) A Study on OS Selection Using ANP Based Choquet Integral in Terms of Cyber Threats. Int J Inf Security Sci. 1(2)
Gumus AT (2009) Evaluation of hazardous waste transportation firms by using a two step fuzzyAHP and TOPSIS methodology. Expert Syst Appl 36(2):4067–4074. doi:10.1016/j.eswa.2008.03.013
Guo J, White J, Wang G, Li J, Wang Y (2011) A genetic algorithm for optimized feature selection with resource constraints in software product lines. J Syst Software 84(12):2208–2221
Huiqun Huang, Guang Sun (2012) ERP Software Selection Using The Rough Set And TPOSIS Methods Under Fuzzy Environment. Int J Adv Inf Sci Serv Scis 4(3):111–118. doi:10.4156/aiss.vol4.issue3.15
Hwang CL, Yoon K (1981) Multiple attribute decision making: methods and applications. In Springer, Heidelberg
ISO/IEC 91261 (2001) Software EngineeringProduct Quality—Part 1: Quality Model, International Organization for Standardization
Kimball R, Caserta J, (2004) The data warehouse ETL toolkit practical techniques for extracting, cleaning, conforming, and delivering data. In chapter 2 eISBN: 0764579231
Lengacher D, Cammarata C (2012) A TwoPhase Data Envelopment Analysis Model for Portfolio Selection”. Adv Decision Sci 2012:1–9
Liberatore MJ, Nydick RL (1997) Group Decision Making In Higher Education Using The Analytic Hierarchy Process. Res Higher Educ 38(5):593–614
Lin HY, Hsu PY, Sheen GJ (2007) A fuzzybased decisionmaking procedure for data warehouse system selection. Expert Syst Appl 32(3):939–953
Lin MC, Wang CC, Chen MS, Chang CA (2008) Using AHP and TOPSIS approaches in customerdriven product design process. Comput Industry 59(1):17–31. doi:10.1016/j.compind.2007.05.013
Liu X (2012) The site selection of distribution center based on linear programming transportation method. In Proceedings of the 10th World Congress on Intelligent Control and Automation
Mousavi S, TavakkoliMoghaddam MR, Heydar M, Ebrahimnejad S (2012) MultiCriteria Decision Making for Plant Location Selection: an Integrated Delphi–AHP–PROMETHEE Methodology. Arab J Sci Eng 38(5):1255–1268
Onder E, Dag S (2013) Combining Analytical Hierarchy Process And TOPSIS Approaches For Supplier Selection In A Cable Company. J Business, Econ Finance 2(2):2013
Panda BN, Biswal BB, Deepak BBLV (2014) Integrated AHP and fuzzy TOPSIS Approach for the Selection of a Rapid Prototyping Process under MultiCriteria Perspective
Saaty TL (2008) Decision Making With The Analytic Hierarchy Process. Int J Serv Sci 1(1):83
Saaty TL, Vargas LG (2001) Models, Methods, Concepts & Applications of the Analytic Hierarchy Process. International Series in Operations Research and Management Science
Simitsis A, Vassiliadis P, Dayal U, Karagiannis A, Tziovara V (2009) Benchmarking ETL Workflows. Lecture Notes in Computer Science. pp 199–220
Tsaur RC (2011) Decision risk analysis for an interval TOPSIS method. Appl Maths Comput 218(8):4295–4304
Wei CC, Chien CF, Wang MJ (2005) An AHPbased approach to ERP system selection. Int J Prod Econ 96(1):47–62
Wu KY (2010) Constructing Evaluation Model for Sustainable Development Community Health and Welfare. WSEAS Trans Syst 9(10):1073–1085
Wyatt L, Caufield B, Pol D (2009) Principles for an ETL Benchmark. Lecture Notes in Computer Science. pp 183–198
Yigit T, Isik AH, Ince M (2014) Webbased learning object selection software using analytical hierarchy process. IET Software 8(4):174–183. doi:10.1049/ietsen.2013.0116
Yoo KE, Choi YC (2006) Analytic hierarchy process approach for identifying relative importance of factors to improve passenger security checks at airports. J Air Trans Manage 12(3):135–142
Zaidan AA, Zaidan BB, AlHaiqi A, Kiah MLM, Hussain M, Abdulnabi M (2015) Evaluation and selection of opensource EMR software packages based on integrated AHP and TOPSIS. J Biomed Inform 53:390–404. doi:10.1016/j.jbi.2014.11.012
Authors’ contributions
TA and BO conceived the idea behind the proposed methodology and prepared the manuscripts. HM and AT carried out the study, developed the system and performed the experiments. All authors read and approved the final manuscript.
Acknowledgements
The authors wish to acknowledge the contributions of other members of the department of computer science for their helpful discussions and the availability of all resources that have helped make this work in the best conditions. They wish also to thank Mr. Redouane Boulguid for pointing out many English corrections that lead to the improvement of the paper. The authors also like to thank the reviewers for their remarks and suggestions.
Competing interests
The authors declare that they have no competing interests.
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
Open Access This article is distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made.
About this article
Cite this article
Hanine, M., Boutkhoum, O., Tikniouine, A. et al. Application of an integrated multicriteria decision making AHPTOPSIS methodology for ETL software selection. SpringerPlus 5, 263 (2016). https://doi.org/10.1186/s400640161888z
Received:
Accepted:
Published:
DOI: https://doi.org/10.1186/s400640161888z
Keywords
 ETL
 ETL software selection problem
 Business Intelligence
 MCDM (multicriteria decision making)
 AHP (analytic hierarchy process)
 TOPSIS (technique for order preference by similarity to ideal solution)