Essec\Faculty\Model\Contribution {#2216 ▼
#_index: "academ_contributions"
#_id: "8056"
#_source: array:26 [
"id" => "8056"
"slug" => "8056-from-uml-to-rolap-multidimensional-databases-using-a-pivot-model"
"yearMonth" => "2001-07"
"year" => "2001"
"title" => "From UML to ROLAP Multidimensional Databases Using a Pivot Model"
"description" => "AKOKA, J., COMYN-WATTIAU, I. et PRAT, N. (2001). <i>From UML to ROLAP Multidimensional Databases Using a Pivot Model</i>. DR-01021, ESSEC Business School. 
AKOKA, J., COMYN-WATTIAU, I. et PRAT, N. (2001). <i>From UML to ROLAP Multidimensional Databases Usi "
"authors" => array:3 [
0 => array:2 [
"name" => "AKOKA Jacky"
"bid" => "B00714200"
]
1 => array:3 [
"name" => "COMYN-WATTIAU Isabelle"
"bid" => "B00000530"
"slug" => "wattiau-isabelle"
]
2 => array:3 [
"name" => "PRAT Nicolas"
"bid" => "B00000434"
"slug" => "prat-nicolas"
]
]
"ouvrage" => ""
"keywords" => []
"updatedAt" => "2020-12-17 21:00:33"
"publicationUrl" => null
"publicationInfo" => array:3 [
"pages" => null
"volume" => null
"number" => null
]
"type" => array:2 [
"fr" => "Documents de travail"
"en" => "Working Papers"
]
"support_type" => array:2 [
"fr" => "Editeur"
"en" => "Publisher"
]
"countries" => array:2 [
"fr" => null
"en" => null
]
"abstract" => array:2 [
"fr" => "Pour être efficace, la conception d'entrepôts de données doit s'appuyer sur une phase de modélisation conceptuelle. Ce document de recherche décrit une méthode des conception d'entrepôts de données. La méthode s'appuie sur les trois niveaux de modélisation qui ont été définis pour la conception de systèmes transactionnels: les niveaux conceptuel, logique et physique. La phase conceptuelle crée un schéma orienté-objet représenté avec le formalisme UML. A cet effet, UML est enrichi de concepts propres aux systèmes multidimensionnels. La phase logique consiste à transformer le schéma UML enrichi en schéma multidimensionnel. Nous proposons un ensemble de règles qui facilitent le processus de conception. Les règles se fondent sur un modèle multidimensionnel qui unifie les principaux concepts du décisionnel, tels que les concepts mis en œuvre dans les outils ROLAP. La phase physique permet au concepteur de transformer le schéma multidimensionnel en un schéma physique, en fonction de l'outil décisionnel cible. Nous illustrons notre approche par une étude de cas et la situons par rapport à l'état de l'art. Pour être efficace, la conception d'entrepôts de données doit s'appuyer sur une phase de modélisatio "
"en" => "Effective data warehouse design requires a conceptual modeling phase. This paper describes a method for data warehouse design. The method relies on the three modeling levels that have been defined for transactional systems design : conceptual, logical and physical. The conceptual phase creates an object-oriented schema which is represented using the UML notation. To this end, UML is enriched with concepts relevant to multidimensional systems. The logical phase consists in mapping the enriched UML schema into a multidimensional one. We propose a set of rules facilitating the design process. The rules are based on a multidimensional model unifying the main decisional concepts as provided by ROLAP tools. The physical phase allows the designer to map the multidimensional schema into a physical schema, depending on the target decisional tool. We illustrate our approach on a case study and compare it to the state-of-the-art. Effective data warehouse design requires a conceptual modeling phase. This paper describes a method "
]
"authors_fields" => array:2 [
"fr" => "Systèmes d'Information, Data Analytics et Opérations"
"en" => "Information Systems, Data Analytics and Operations"
]
"indexedAt" => "2025-03-30T06:21:40.000Z"
"docTitle" => "From UML to ROLAP Multidimensional Databases Using a Pivot Model"
"docSurtitle" => "Working Papers"
"authorNames" => "AKOKA Jacky, <a href="/cv/wattiau-isabelle">COMYN-WATTIAU Isabelle</a>, <a href="/cv/prat-nicolas">PRAT Nicolas</a> AKOKA Jacky, <a href="/cv/wattiau-isabelle">COMYN-WATTIAU Isabelle</a>, <a href="/cv/prat-nicolas">P "
"docDescription" => "<span class="document-property-authors">AKOKA Jacky, COMYN-WATTIAU Isabelle, PRAT Nicolas</span><br><span class="document-property-authors_fields">Information Systems, Data Analytics and Operations</span> | <span class="document-property-year">2001</span> <span class="document-property-authors">AKOKA Jacky, COMYN-WATTIAU Isabelle, PRAT Nicolas</span><br> "
"keywordList" => ""
"docPreview" => "<b>From UML to ROLAP Multidimensional Databases Using a Pivot Model</b><br><span>2001-07 | Working Papers </span> <b>From UML to ROLAP Multidimensional Databases Using a Pivot Model</b><br><span>2001-07 | Working P "
"docType" => "research"
"publicationLink" => "<a href="#" target="_blank">From UML to ROLAP Multidimensional Databases Using a Pivot Model</a>"
]
+lang: "en"
+"_type": "_doc"
+"_score": 9.1734
+"parent": null
}
