Authors:
Fadila Bentayeb
and
Rym Khemiri
Affiliation:
University of Lyon and Lumière Lyon 2, France
Keyword(s):
Analysis Level, Constrained K-means Clustering, OLAP, Personalization, PRoCK, Semantic Dimension Hierarchy, User Constraints.
Related
Ontology
Subjects/Areas/Topics:
Artificial Intelligence
;
Artificial Intelligence and Decision Support Systems
;
Data Mining
;
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Group Decision Support Systems
;
Sensor Networks
;
Signal Processing
;
Soft Computing
Abstract:
The objective of this paper is to provide a personalized on-line aggregate operator, namely PRoCK (Personalized Rollup operator with Constrained K-means), based on data mining techniques. The use of data mining techniques, and more precisely constrained K-means clustering method, helps to discover new grouping sets with respect to users requirements. In the context of data warehouses, PRoCK allows to adapt dimension hierarchies to the user constraints. Indeed, applied on a given dimension hierarchy instances, constrained k-means clustering method gives a new natural classification. The obtained clustering results constitute a new hierarchy level semantically richer, namely personalized level on which user may elaborate more sophisticated OLAP analysis. PRoCK is integrated inside Oracle RDBMS (Relational DataBase Management System) and we have carried out some experimentation which validated the relevance of our operator.