A methodology for the design of a fuzzy data warehouse

A data warehouse is a special database used for storing business oriented information for future analysis and decision-making. In business scenarios, where some of the data or the business attributes are fuzzy, it may be useful to construct a warehouse that can support the analysis of fuzzy data. Here, we outline how Kimballpsilas methodology for the design of a data warehouse can be extended to the construction of a fuzzy data warehouse. A case study demonstrates the viability of the methodology.

[1]  Gleb Beliakov,et al.  Learning Weights in the Generalized OWA Operators , 2005, Fuzzy Optim. Decis. Mak..

[2]  R. Yager.  Families of OWA operators , 1993 .

[3]  George J. Klir,et al.  Fuzzy sets, uncertainty and information , 1988 .

[4]  Juan Miguel Medina,et al.  Towards the implementation of a generalized fuzzy relational database model , 1995, Fuzzy Sets Syst..

[5]  Ronald R. Yager,et al.  Centered OWA Operators , 2007, Soft Comput..

[6]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

[7]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[8]  T. S. Jayram,et al.  OLAP over uncertain and imprecise data , 2007, The VLDB Journal.

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

[10]  Olga Pons,et al.  GEFRED: A Generalized Model of Fuzzy Relational Databases , 1994, Inf. Sci..

[11]  Earl Cox,et al.  The fuzzy systems handbook , 1994 .

[12]  B. Barnes,et al.  Review: The Data Warehouse Toolkit (Second Edition) , 2003 .

[13]  Sumit Sarkar,et al.  PSQL: A Query Language for Probabilistic Relational Data , 1998, Data Knowl. Eng..

[14]  Zeshui Xu,et al.  An overview of methods for determining OWA weights , 2005, Int. J. Intell. Syst..

[15]  János C. Fodor,et al.  Characterization of the ordered weighted averaging operators , 1995, IEEE Trans. Fuzzy Syst..

[16]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[17]  Daniel Sánchez,et al.  A fuzzy multidimensional model for supporting imprecision in OLAP , 2004, 2004 IEEE International Conference on Fuzzy Systems (IEEE Cat. No.04CH37542).

[18]  Daniel Sánchez,et al.  On a Characterization of Fuzzy Bags , 2003, IFSA.

[19]  Hans-Jürgen Zimmermann,et al.  Fuzzy set theory , 1992 .