Fuzzy Extended Dependencies to Support Decision-Making in Project Management

Project management is becoming an important key process in industrial engineering in order to choose suitable and profitable projects for the companies. We have focused our interest from the manager point of view that needs quality data to make decisions about which kind of projects are more suitable for the company. But nowadays the suitability of the projects don’t depend only on quantitative and monetary profits other profits are more and more relevant in the decision for choosing a project such as subjective ones (group satisfaction, cohesiveness of the group, etc.). The managers have a database with data referred to past projects but usually this database has a huge amount of data that overload the manager in order to study and detect the information he/she needs. Therefore, in this paper we propose a Data Mining process able to deal with quantitative and qualitative features using fuzzy logic (Fuzzy SQL language) to discover the knowledge that the manager needs to make decisions about the more suitable projects for the company. The Data Mining process proposed will obtain Fuzzy Functional Dependencies and Fuzzy Gradual Dependencies by using a flexible query language as the Fuzzy SQL (FSQL), which will provide the information that will support project managers decisions about which type of projects are more suitable for the company based on the projects already done and on objective and subjective features.

[1]  Philip S. Yu,et al.  Data Mining: An Overview from a Database Perspective , 1996, IEEE Trans. Knowl. Data Eng..

[2]  Heikki Mannila,et al.  Dependency Inference , 1987, VLDB.

[3]  Gregory Piatetsky-Shapiro,et al.  Knowledge Discovery in Databases: An Overview , 1992, AI Mag..

[4]  Satoru Miyano,et al.  A simple greedy algorithm for finding functional relations: efficient implementation and average case analysis , 2003, Theor. Comput. Sci..

[5]  Fatemah Ghotb,et al.  A Case Study Comparison of the Analytic Hierarchy Process and a Fuzzy Decision Methodology , 1995 .

[6]  Bülent Çatay,et al.  Strategic level three-stage production distribution planning with capacity expansion , 2006, Comput. Ind. Eng..

[7]  Willy Herroelen,et al.  A hierarchical approach to multi-project planning under uncertainty , 2004 .

[8]  José L. Verdegay,et al.  Linguistic decision‐making models , 1992, Int. J. Intell. Syst..

[9]  Mario Piattini,et al.  Representation of fuzzy knowledge in relational databases , 2004, Proceedings. 15th International Workshop on Database and Expert Systems Applications, 2004..

[10]  Pandian Vasant,et al.  Fuzzy decision making of profit function in production planning using S-curve membership function , 2006, Comput. Ind. Eng..

[11]  Usama M. Fayyad,et al.  Knowledge Discovery in Databases: An Overview , 1997, ILP.

[12]  Lotfi A. Zadeh,et al.  Fuzzy Sets , 1996, Inf. Control..

[13]  E. Ertugrul Karsak,et al.  Fuzzy multiple objective programming framework to prioritize design requirements in quality function deployment , 2004, Comput. Ind. Eng..

[14]  Heikki Mannila,et al.  Approximate Dependency Inference from Relations , 1992, ICDT.

[15]  Mao-Jiun J. Wang,et al.  A fuzzy multi-criteria decision-making method for facility site selection , 1991 .

[16]  Rosine Cicchetti,et al.  Functional and embedded dependency inference: a data mining point of view , 2001, Inf. Syst..

[17]  Jian-Bo Yang,et al.  A Fuzzy Model for Design Evaluation Based on Multiple Criteria Analysis in Engineering Systems , 2006, Int. J. Uncertain. Fuzziness Knowl. Based Syst..

[18]  Bernadette Bouchon-Meunier,et al.  IPMU '92 : advanced methods in artificial intelligence : 4th International Conference on Information Processing and Management of Uncertainty in Knowledge-Based Systems, Palma de Mallorca, Spain, July 6-10, 1992 : proceedings , 1993 .

[19]  L. A. ZADEH,et al.  The concept of a linguistic variable and its application to approximate reasoning - I , 1975, Inf. Sci..

[20]  S. Han,et al.  Evaluation of CITIS as a collaborative virtual organization for construction project management , 2007 .

[21]  José Galindo,et al.  Clustering and Fuzzy Classification in a Financial Data Mining Environment , 1999, IIA/SOCO.

[22]  Donald H. Kraft,et al.  Fuzzy sets in database and information systems: Status and opportunities , 2005, Fuzzy Sets Syst..

[23]  Li Lin,et al.  A structured approach to measuring functional dependency and sequencing of coupled tasks in engineering design , 2003, Comput. Ind. Eng..

[24]  Atsuhiro Takasu,et al.  Inferring approximate functional dependencies from example data , 1993 .

[25]  Juan C. Cubero,et al.  A new definition of fuzzy functional dependency in fuzzy relational databases , 1994, Int. J. Intell. Syst..

[26]  Francisco Herrera,et al.  Managing non-homogeneous information in group decision making , 2005, Eur. J. Oper. Res..

[27]  Yuan Zhao,et al.  Automated elicitation of functional dependencies from source codes of database transactions , 2004, Inf. Softw. Technol..

[28]  Lotfi A. Zadeh,et al.  The Concepts of a Linguistic Variable and its Application to Approximate Reasoning , 1975 .

[29]  Olga Pons,et al.  A Server for Fuzzy SQL Queries , 1998, FQAS.

[30]  Didier Dubois,et al.  Gradual inference rules in approximate reasoning , 1992, Inf. Sci..

[31]  Olga Pons,et al.  Fuzzy loss less decompositions in databases , 1998, Fuzzy Sets Syst..

[32]  Ronald R. Yager,et al.  Finding fuzzy and gradual functional dependencies with SummarySQL , 1999, Fuzzy Sets Syst..

[33]  Ramón Alberto Carrasco,et al.  dmFSQL: a Language for Data Mining , 2006, 17th International Workshop on Database and Expert Systems Applications (DEXA'06).

[34]  R. Dyson,et al.  On the strategic project management process in the UK upstream oil and gas sector , 2007 .

[35]  Francisco Herrera,et al.  Linguistic decision analysis: steps for solving decision problems under linguistic information , 2000, Fuzzy Sets Syst..