eprintid: 29732
rev_number: 12
eprint_status: archive
userid: 19147
dir: disk0/00/02/97/32
datestamp: 2019-03-27 14:27:49
lastmod: 2021-04-02 15:59:23
status_changed: 2019-03-27 14:27:49
type: article
metadata_visibility: show
creators_name: Hassan, Ali
creators_name: Ravat, Franck
creators_name: Teste, Olivier
creators_name: Tournier, Ronan
creators_name: Zurfluh, Gilles
creators_idrefppn: 187880379
creators_idrefppn: 127663711
creators_idrefppn: 076013286
creators_idrefppn: 125954727
creators_idrefppn: 061081493
title: Multidimensional database modelling with differentiated multiple aggregations
ispublished: pub
subjects: subjects_INFO
abstract: Many solutions have been defined for multidimensional database modelling. These propositions consider the same aggregation function to determine the values of an indicator according to different levels of granularity into the multidimensional space. We provide a more flexible conceptual model that supports multiple differentiated aggregations. Multiple aggregations allow associating different aggregation functions to the same measure for each dimension and for each hierarchy. Differentiated aggregation allows specific aggregations at each level (parameter). Our model is based on a double graphical formalism, expressive enough to control the validity of aggregation functions. We also study the consequences of this conceptual modelling for building lattices of pre-computed aggregates in a relational online analytical processing (R-OLAP) environment.
date: 2014
date_type: published
publisher: Hermès Science
faculty: info
divisions: IRIT
keywords: Multiple aggregations - Multidimensional database - Data warehouse conceptual modelling - Multidimensional lattices
language: en
has_fulltext: TRUE
view_date_year: 2014
full_text_status: public
publication: Journal of Decision Systems
volume: 23
number: 4
pagerange: 437-459
refereed: TRUE
issn: 1246-0125
harvester_local_overwrite: eprintid
harvester_local_overwrite: userid
harvester_local_overwrite: date
harvester_local_overwrite: official_url
harvester_local_overwrite: issn
harvester_local_overwrite: dir
harvester_local_overwrite: keywords
harvester_local_overwrite: pagerange
harvester_local_overwrite: publisher
harvester_local_overwrite: volume
harvester_local_overwrite: creators_name
harvester_local_overwrite: faculty
harvester_local_overwrite: site
harvester_local_overwrite: abstract
harvester_local_overwrite: title
harvester_local_overwrite: publication
harvester_local_overwrite: type
harvester_local_overwrite: number
harvester_local_overwrite: note
harvester_local_overwrite: ispublished
harvester_local_overwrite: id_number
harvester_local_overwrite: event_title
harvester_local_overwrite: pres_type
harvester_local_overwrite: event_location
harvester_local_overwrite: series
harvester_local_overwrite: isbn
harvester_local_overwrite: book_title
harvester_local_overwrite: editors_name
harvester_local_overwrite: department
harvester_local_overwrite: thesis_type
harvester_local_overwrite: pages
harvester_local_overwrite: place_of_pub
harvester_local_overwrite: divisions
harvester_local_overwrite: subjects
harvester_local_overwrite: date_type
harvester_local_overwrite: language
harvester_local_overwrite: refereed
harvester_local_overwrite: creators_idrefppn
site: ut1
citation:   Hassan, Ali <https://www.idref.fr/187880379>, Ravat, Franck <https://www.idref.fr/127663711>, Teste, Olivier <https://www.idref.fr/076013286>, Tournier, Ronan <https://www.idref.fr/125954727> and Zurfluh, Gilles <https://www.idref.fr/061081493>  (2014) Multidimensional database modelling with differentiated multiple aggregations.    Journal of Decision Systems, 23 (4).  pp. 437-459.       
document_url: https://publications.ut-capitole.fr/id/eprint/29732/1/assistant_12258574_1894637245_0.pdf