Building Fuzzy OLAP Using Multi-attribute Summarization

Data Warehouse helps the decision makers of an organization in taking decisions that helps in improving the profitability of business by consolidating and aggregating data from many heterogeneous sources. Information available in this aggregated data is raw numbers. These raw numbers does not provide semantics about the data to decision makers. For example, " A sale of amount 100000 is good or bad is unclear". Usually the relationship between the data and requirements to the decision maker are fuzzy in nature, rather than crisp numbers. There is a need to design data-warehouse in such a way that it should address the requirements of intelligent decision-making. In this paper, we build a fuzzy OLAP cube to support qualitative data analysis by using multi-attribute summarization. Data is fuzzified and assigned membership values using a cluster-based approach. To demonstrate the model, we developed a prototype data warehouse for foreign exchange currency transactions and analyzed these transactions with fuzzy OLAP operations.

[1]  P. Radha Krishna,et al.  A fuzzy approach to build an intelligent data warehouse , 2001, J. Intell. Fuzzy Syst..

[2]  Siegfried Gottwald,et al.  Fuzzy Sets and Fuzzy Logic , 1993 .

[3]  Peter J. Rousseeuw,et al.  Finding Groups in Data: An Introduction to Cluster Analysis , 1990 .

[4]  B. Silverman,et al.  Wavelet thresholding via a Bayesian approach , 1998 .

[5]  D Christopher Durairaj,et al.  Integration of color and boundary information for improved region of interest identification in electron magnetic resonance images. , 2004, Computerized medical imaging and graphics : the official journal of the Computerized Medical Imaging Society.

[6]  R Murugesan.  Chapter-22 EPR Imaging for Biomedical Applications , 2005 .

[7]  I. Turksen.  Measurement of membership functions and their acquisition , 1991 .

[8]  George J. Klir,et al.  Fuzzy sets and fuzzy logic , 1995 .

[9]  Ramachandran Murugesan,et al.  Evaluation of Algebraic Iterative Algorithms for Reconstruction of Electron Magnetic Resonance Images , 2004, ICVGIP.

[10]  D. Christopher Durairaj,et al.  A neural network approach for image reconstruction in electron magnetic resonance tomography , 2007, Comput. Biol. Medicine.

[11]  Ali S. Hadi,et al.  Finding Groups in Data: An Introduction to Chster Analysis , 1991 .

[12]  Tharam S. Dillon,et al.  Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses , 2003, IEEE Trans. Knowl. Data Eng..

[13]  P. Radha Krishna,et al.  Fuzzy OLAP cube for qualitative analysis , 2005, Proceedings of 2005 International Conference on Intelligent Sensing and Information Processing, 2005..

[14]  Elke A. Rundensteiner,et al.  Evaluating aggregates in possibilistic relational databases , 1992, Data Knowl. Eng..

[15]  Kim-Fung Man,et al.  Design and optimization of IIR filter structure using hierarchical genetic algorithms , 1998, IEEE Trans. Ind. Electron..

[16]  Alin Achim,et al.  Novel Bayesian multiscale method for speckle removal in medical ultrasound images , 2001, IEEE Transactions on Medical Imaging.

[17]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[18]  Robert D. Nowak,et al.  Wavelet-based statistical signal processing using hidden Markov models , 1998, IEEE Trans. Signal Process..

[19]  Michael Unser,et al.  Wavelets in Medical Imaging , 2003, IEEE Trans. Medical Imaging.

[20]  Periannan Kuppusamy,et al.  In vivo imaging of free radicals: Applications from mouse to man , 2002, Molecular and Cellular Biochemistry.

[21]  Neil Salkind.  Encyclopedia of Measurement and Statistics , 2006 .

[22]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.