Enhancing DWH models with the utilisation of multiple hierarchical schemata

Alzebdi, Mohammedsharaf, Chountas, Panagiotis and Atanassov, Krassimir T. (2010) Enhancing DWH models with the utilisation of multiple hierarchical schemata. In: Proceeding of the 2010 IEEE International Conference on Systems Man and Cybernetics (SMC), Istanbul, 10-13 Oct. 2010. IEEE, pp. 488-492. ISBN 9781424465866

Full text not available from this repository.
Official URL: http://dx.doi.org/10.1109/ICSMC.2010.5641968


Data Warehouse (DWH) Models are based on static dimensions having single hierarchies. With the evolution of World Wide Web, including external knowledge can enrich those models and provide better results of data analysis. Therefore, it would be useful to have intelligent transformation utilities that can mine various data structures and extract useful knowledge participating in the construction of flexible DWH models. This paper proposes a new approach towards intelligent transformation utilities that will allow the utilisation of multiple hierarchical schemata when defining the dimensions of data-warehouses. By allowing a particular dimension to have multiple but semantically close definitions, we allow same users to query same data with the aid of different semantics. To put it differently users are allowed to change or refine the axis of analysis with respect to a particular query, in their effort to achieve a more meaningful answer. We make use of Intuitionistic Fuzzy Logic to soften the rules of calculating the similarity between different hierarchies which in turn is used to decide if the hierarchies can be included in the definition of data warehouse dimension. Data transformations are used to transform the data from one hierarchy to another. With the aid of external data, some sort of estimation is used to estimate values of new hierarchy levels and then based on the user's request the desired hierarchy is used to view an OLAP cube.

Item Type: Book Section
Additional Information: 10-13 Oct. 2010
Subjects: University of Westminster > Science and Technology > Electronics and Computer Science, School of (No longer in use)
Depositing User: Rachel Wheelhouse
Date Deposited: 23 Jul 2012 09:51
Last Modified: 25 Jun 2013 11:30
URI: http://westminsterresearch.wmin.ac.uk/id/eprint/10889

Actions (login required)

Edit Item (Repository staff only) Edit Item (Repository staff only)