Essec\Faculty\Model\Contribution {#2216
  #_index: "academ_contributions"
  #_id: "587"
  #_source: array:26 [
    "id" => "587"
    "slug" => "a-uml-based-data-warehouse-design-method"
    "yearMonth" => "2006-12"
    "year" => "2006"
    "title" => "A UML-based Data Warehouse Design Method"
    "description" => "PRAT, N., AKOKA, J. et COMYN-WATTIAU, I. (2006). A UML-based Data Warehouse Design Method. <i>Decision Support Systems</i>, 42(3), pp. 1449-1473."
    "authors" => array:3 [
      0 => array:3 [
        "name" => "PRAT Nicolas"
        "bid" => "B00000434"
        "slug" => "prat-nicolas"
      ]
      1 => array:2 [
        "name" => "AKOKA Jacky"
        "bid" => "B00714200"
      ]
      2 => array:3 [
        "name" => "COMYN-WATTIAU Isabelle"
        "bid" => "B00000530"
        "slug" => "wattiau-isabelle"
      ]
    ]
    "ouvrage" => ""
    "keywords" => array:6 [
      0 => "Aide à la décision"
      1 => "Analyse de données en ligne (OLAP)"
      2 => "Conception logique"
      3 => "Conception physique"
      4 => "Entrepôt de données"
      5 => "Modélisation conceptuelle"
    ]
    "updatedAt" => "2020-12-17 17:55:06"
    "publicationUrl" => "https://doi.org/10.1016/j.dss.2005.12.001"
    "publicationInfo" => array:3 [
      "pages" => "1449-1473"
      "volume" => "42"
      "number" => "3"
    ]
    "type" => array:2 [
      "fr" => "Articles"
      "en" => "Journal articles"
    ]
    "support_type" => array:2 [
      "fr" => "Revue scientifique"
      "en" => "Scientific journal"
    ]
    "countries" => array:2 [
      "fr" => null
      "en" => null
    ]
    "abstract" => array:2 [
      "fr" => "Cet article décrit une méthode de conception d'entrepôts de données fondée sur UML et qui couvre les trois phases de la conception (conceptuelle, logique et physique). Notre méthode est fondée sur un ensemble de méta-modèles et un ensemble de transformations qui peuvent être semi-automatisées. Les méta-modèles sont décrits en UML et la spécification formelle est exprimée à l'aide du langage OCL. La méthode est illustrée à l'aide d'un cas pratique."
      "en" => "Data warehouses are a major component of data-driven decision support systems (DSS). They rely on multidimensional models. The latter provide decision makers with a business-oriented view to data, thereby easing data navigation and analysis via On-Line Analytical Processing (OLAP) tools. They also determine how the data are stored in the data warehouse for subsequent use, not only by OLAP tools, but also by other decision support tools (e.g. reporting or data mining). Data warehouse design is a complex task, which requires a systematic method. Few such methods have been proposed to date. This paper presents a UML-based data warehouse design method that spans the three design phases (conceptual, logical and physical). Starting from user requirements, the conceptual phase leads to an object-oriented model represented using the UML notation. For this purpose, UML is enriched with concepts relevant to multidimensional modeling. The logical phase maps the enriched UML model into a multidimensional schema, independently of any implementation tool. The physical phase allows the designer to map the multidimensional schema into a physical database schema depending on the implementation target tool, typically a native multidimensional (MOLAP) or a relational (ROLAP) tool. Our method comprises a set of metamodels used at each phase (in particular a unified multidimensional metamodel used at the logical phase), as well as a set of transformations that can be semi-automated. Following our object orientation, we represent all the metamodels using UML, and illustrate the formal specification of the transformations based on OMG¿s Object Constraint Language (OCL). Throughout the paper, we illustrate the application of our method to a case study."
    ]
    "authors_fields" => array:2 [
      "fr" => "Systèmes d'Information, Data Analytics et Opérations"
      "en" => "Information Systems, Data Analytics and Operations"
    ]
    "indexedAt" => "2024-12-03T17:21:44.000Z"
    "docTitle" => "A UML-based Data Warehouse Design Method"
    "docSurtitle" => "Journal articles"
    "authorNames" => "<a href="/cv/prat-nicolas">PRAT Nicolas</a>, AKOKA Jacky, <a href="/cv/wattiau-isabelle">COMYN-WATTIAU Isabelle</a>"
    "docDescription" => "<span class="document-property-authors">PRAT Nicolas, AKOKA Jacky, COMYN-WATTIAU Isabelle</span><br><span class="document-property-authors_fields">Information Systems, Data Analytics and Operations</span> | <span class="document-property-year">2006</span>"
    "keywordList" => "<a href="#">Aide à la décision</a>, <a href="#">Analyse de données en ligne (OLAP)</a>, <a href="#">Conception logique</a>, <a href="#">Conception physique</a>, <a href="#">Entrepôt de données</a>, <a href="#">Modélisation conceptuelle</a>"
    "docPreview" => "<b>A UML-based Data Warehouse Design Method</b><br><span>2006-12 | Journal articles </span>"
    "docType" => "research"
    "publicationLink" => "<a href="https://doi.org/10.1016/j.dss.2005.12.001" target="_blank">A UML-based Data Warehouse Design Method</a>"
  ]
  +lang: "en"
  +"_type": "_doc"
  +"_score": 9.19509
  +"parent": null
}