Essec\Faculty\Model\Contribution {#2216
  #_index: "academ_contributions"
  #_id: "1185"
  #_source: array:26 [
    "id" => "1185"
    "slug" => "extracting-generalization-hierarchies-from-relational-databases-a-reverse-engineering-approach"
    "yearMonth" => "2007-01"
    "year" => "2007"
    "title" => "Extracting Generalization Hierarchies from Relational Databases - A Reverse Engineering Approach"
    "description" => "LAMMARI, N., COMYN-WATTIAU, I. et AKOKA, J. (2007). Extracting Generalization Hierarchies from Relational Databases - A Reverse Engineering Approach. <i>Data and Knowledge Engineering</i>, pp. 568-589."
    "authors" => array:3 [
      0 => array:3 [
        "name" => "COMYN-WATTIAU Isabelle"
        "bid" => "B00000530"
        "slug" => "wattiau-isabelle"
      ]
      1 => array:2 [
        "name" => "AKOKA Jacky"
        "bid" => "B00714200"
      ]
      2 => array:1 [
        "name" => "LAMMARI N."
      ]
    ]
    "ouvrage" => ""
    "keywords" => array:5 [
      0 => "Base de données relationnelle"
      1 => "Hiérarchie de généralisation"
      2 => "Hiérarchie d'héritage"
      3 => "Modèle ER étendu "
      4 => "Rétro-conception"
    ]
    "updatedAt" => "2020-12-17 17:55:06"
    "publicationUrl" => null
    "publicationInfo" => array:3 [
      "pages" => "568-589"
      "volume" => null
      "number" => null
    ]
    "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 rétroconception de base de données qui inclut la recherche des liens de généralisation masqués dans les bases de données relationnelles, en combinant des approches algorithmiques et heuristiques. Nous proposons des règles de détection des contraintes d'intersection et des dépendances d'inclusion. Des heuristiques sont fournies pour la compréhension de la sémantique des valeurs nulles, ainsi que des règles de détection des dépendances d'existence et leur traduction en hiérarchies ISA entre entités."
      "en" => "This paper describes a reverse engineering method which particularly deals with the elicitation of inheritance links embedded in a relational database, combining heuristic and algorithmic approaches. We provide rules for detecting intersection constraints and inclusion dependencies. Heuristics are proposed for understanding null value semantics. Finally, we present decision rules for detecting existence dependencies and translating them into IS-A hierarchies among entities. An example is used to illustrate our approach."
    ]
    "authors_fields" => array:2 [
      "fr" => "Systèmes d'Information, Data Analytics et Opérations"
      "en" => "Information Systems, Data Analytics and Operations"
    ]
    "indexedAt" => "2024-12-21T16:21:43.000Z"
    "docTitle" => "Extracting Generalization Hierarchies from Relational Databases - A Reverse Engineering Approach"
    "docSurtitle" => "Journal articles"
    "authorNames" => "<a href="/cv/wattiau-isabelle">COMYN-WATTIAU Isabelle</a>, AKOKA Jacky, LAMMARI N."
    "docDescription" => "<span class="document-property-authors">COMYN-WATTIAU Isabelle, AKOKA Jacky, LAMMARI N.</span><br><span class="document-property-authors_fields">Information Systems, Data Analytics and Operations</span> | <span class="document-property-year">2007</span>"
    "keywordList" => "<a href="#">Base de données relationnelle</a>, <a href="#">Hiérarchie de généralisation</a>, <a href="#">Hiérarchie d'héritage</a>, <a href="#">Modèle ER étendu </a>, <a href="#">Rétro-conception</a>"
    "docPreview" => "<b>Extracting Generalization Hierarchies from Relational Databases - A Reverse Engineering Approach</b><br><span>2007-01 | Journal articles </span>"
    "docType" => "research"
    "publicationLink" => "<a href="#" target="_blank">Extracting Generalization Hierarchies from Relational Databases - A Reverse Engineering Approach</a>"
  ]
  +lang: "en"
  +"_type": "_doc"
  +"_score": 9.269113
  +"parent": null
}