Multi-criteria Decisional Approach of the OLAP Analysis by Fuzzy Logic: Green Logistics as a Case Study

This study aims to propose a decision-making approach combining multi-criteria analysis and fuzzy logic within the online analytical processing data cube model (OLAP). Indeed, most decision-making systems are based on models of operational research. These models are often composed of quantitative data and postulate the existence of a single objective function (criterion) representing the preferences of decision-makers. However, in reality, we are faced with a more complex situation where several criteria (quantitative and/or qualitative) should be taken into account. It is therefore natural to consider different types of data (more criteria) in the design of OLAP cubes and decision-making systems. Multi-criteria decision analysis (MCDA) combined with fuzzy sets theory offers an efficient approach to solve complex decision problems. So we believe it is useful and necessary to envisage, for OLAP cubes, an optimized data model taking into account several criteria, on which we can apply new methods of MCDA. We end our contribution by applying the decision support process of this paper to propose a scheme of green logistics for large industrial zones in the city of Casablanca, Morocco.

[1]  Selim Zaim,et al.  Selecting "The Best" ERP system for SMEs using a combination of ANP and PROMETHEE methods , 2015, Expert Syst. Appl..

[2]  Bernard W. Taylor,et al.  Introduction to Management Science , 2006 .

[3]  Rodger Tomlinson,et al.  Comparison of Fuzzy-AHP and AHP in a spatial multi-criteria decision making model for urban land-use planning , 2015, Comput. Environ. Urban Syst..

[4]  Sylvain Kubler,et al.  Group fuzzy AHP approach to embed relevant data on "communicating material" , 2014, Comput. Ind..

[5]  Juite Wang,et al.  Combining fuzzy AHP and fuzzy Kano to optimize product varieties for smart cameras: A zero-one integer programming perspective , 2014, Appl. Soft Comput..

[6]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[7]  Zahari Taha,et al.  A hybrid fuzzy AHP-PROMETHEE decision support system for machine tool selection in flexible manufacturing cell , 2011, Journal of Intelligent Manufacturing.

[8]  Nick Antonopoulos,et al.  Cloud BI: Future of business intelligence in the Cloud , 2015, J. Comput. Syst. Sci..

[9]  Angélica Urrutia,et al.  Fuzzy OLAP: A Formal Definition , 2009 .

[10]  Matteo Golfarelli,et al.  Shrink: An OLAP operation for balancing precision and size of pivot tables , 2014, Data Knowl. Eng..

[11]  José Galindo,et al.  Fuzzy Databases: Modeling, Design, and Implementation , 2006 .

[12]  Yoon Joon Lee,et al.  Efficient Indexing for OLAP Query Processing with MapReduce , 2015 .

[13]  Ching-Chow Yang,et al.  KEY QUALITY PERFORMANCE EVALUATION USING FUZZY AHP , 2004 .

[14]  Mahdi Karbasian,et al.  The application of ISM model in evaluating agile suppliers selection criteria and ranking suppliers using fuzzy TOPSIS-AHP methods , 2015, Expert Syst. Appl..

[15]  Robert LIN,et al.  NOTE ON FUZZY SETS , 2014 .

[16]  Reda Alhajj,et al.  Development of multidimensional academic information networks with a novel data cube based modeling method , 2014, Inf. Sci..

[17]  Xiaojun Wang,et al.  A comprehensive decision making model for the evaluation of green operations initiatives , 2015 .

[19]  Ting-Yu Chen,et al.  An interval type-2 fuzzy PROMETHEE method using a likelihood-based outranking comparison approach , 2015, Inf. Fusion.

[20]  T. Saaty,et al.  The Analytic Hierarchy Process , 1985 .

[21]  Cécile Favre,et al.  Combining OLAP and information networks for bibliographic data analysis: a survey , 2015, Scientometrics.

[22]  Kwai-Sang Chin,et al.  A hybrid OLAP-association rule mining based quality management system for extracting defect patterns in the garment industry , 2013, Expert Syst. Appl..

[23]  T. Laosirihongthong,et al.  A fuzzy AHP to prioritize enabling factors for strategic management of university business incubators: Resource-based view , 2014 .

[24]  Michael Schrefl,et al.  Active data warehouses: complementing OLAP with analysis rules , 2001, Data Knowl. Eng..

[25]  Matteo Golfarelli,et al.  A collaborative filtering approach for recommending OLAP sessions , 2015, Decis. Support Syst..

[26]  Alev Taskin Gumus,et al.  Evaluation of hazardous waste transportation firms by using a two step fuzzy-AHP and TOPSIS methodology , 2009, Expert Syst. Appl..

[27]  R. Parameshwaran,et al.  An integrated framework for mechatronics based product development in a fuzzy environment , 2015, Appl. Soft Comput..

[28]  Kamal Ahmed,et al.  Weighting Methods and their Effects on Multi-Criteria Decision Making Model Outcomes in Water Resources Management , 2014 .

[29]  José Galindo,et al.  New characteristics in FSQL, a fuzzy SQL for fuzzy databases , 2005 .

[30]  Jeng-Fung Chen,et al.  Evaluating teaching performance based on fuzzy AHP and comprehensive evaluation approach , 2015, Appl. Soft Comput..

[31]  Guandong Xu,et al.  OLAP*: Effectively and Efficiently Supporting Parallel OLAP over Big Data , 2013, MEDI.

[32]  Ge Yu,et al.  HaoLap: A Hadoop based OLAP system for big data , 2015, J. Syst. Softw..

[33]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[34]  Panos Vassiliadis,et al.  CineCubes: Aiding data workers gain insights from OLAP queries , 2015, Inf. Syst..

[35]  Ravi Kant,et al.  A fuzzy AHP-TOPSIS framework for ranking the solutions of Knowledge Management adoption in Supply Chain to overcome its barriers , 2014, Expert Syst. Appl..

[36]  Andrew Rau-Chaplin,et al.  Scalable real-time OLAP on cloud architectures , 2015, J. Parallel Distributed Comput..

[37]  Armando Calabrese,et al.  Using Fuzzy AHP to manage Intellectual Capital assets: An application to the ICT service industry , 2013, Expert Syst. Appl..

[38]  Maria Lexhagen,et al.  Integration of Data Mining Results into Multi-dimensional Data Models , 2015, ENTER.

[39]  Osman Taylan,et al.  Construction projects selection and risk assessment by fuzzy AHP and fuzzy TOPSIS methodologies , 2014, Appl. Soft Comput..

[40]  Jin Qi,et al.  An integrated AHP and VIKOR for design concept evaluation based on rough number , 2015, Adv. Eng. Informatics.