A Layered Multidimensional Model of Complex Objects

Doulkifli Boukraa

doulkifli boukraa

Short-bio

I obtained my Engineer degree (1998), my Magister degree (2005) and my PhD (2013) from Ecole Nationale Supérieure d'Informatique (www.esi.dz). In 2003, I became a certified Oracle Forms Developer.

Before joining the University of Jijel in 2005, I worked in ETM Ibnrochd (currently It-Comp) in Algiers as an Oracle SQL, PL/SQL and Forms consultant and developer.

Currently, I am an associate professor and researcher at the University of Jijel. I am responsible of the SIAD master (Systèmes d'information et aide à la décision) at the University of Jijel. I am teaching information systems, advanced methods and Data warehouses for the Master 1 SIAD Class.

My research interests lay in multidimensional modeling of data warehouses, XML warehouses and performance optimization of data warehouses

Abstract

Multidimensional modeling is nowadays recognized to best reflect the decision makers' analytical view on data. In this paper, we address some modeling features that we believe existing multidimensional models do not fully cover, such as considering real life entities that are meant to be analyzed as complex objects, allowing for simple and complex measures, treating facts and dimension members equally and observing hierarchies within and between complex entities. We propose a layered multidimensional model based on the concept of complex object which encapsulates data and structure complexity and eases the creation and manipulation of complex data cubes. We need to define our model at three layers. The first layer class diagram describes complex objects and captures the hierarchical organization of their attributes. The second layer package of classes describes the multidimensional model as a set of complex objects that are connected by relationships and some of which are organized in hierarchies. The third layer package of packages describes complex cubes which are derived from the multidimensional model. We show the benefits and feasibility of our proposals through their implementation in a real-life case study.