Essec\Faculty\Model\Contribution {#2216
  #_index: "academ_contributions"
  #_id: "2404"
  #_source: array:26 [
    "id" => "2404"
    "slug" => "relational-database-reverse-engineering"
    "yearMonth" => "1999-07"
    "year" => "1999"
    "title" => "Relational Database Reverse Engineering"
    "description" => "COMYN-WATTIAU, I. et AKOKA, J. (1999). Relational Database Reverse Engineering. <i>Ingenierie des Systemes D’Information</i>, pp. 345-378."
    "authors" => array:2 [
      0 => array:3 [
        "name" => "COMYN-WATTIAU Isabelle"
        "bid" => "B00000530"
        "slug" => "wattiau-isabelle"
      ]
      1 => array:2 [
        "name" => "AKOKA Jacky"
        "bid" => "B00714200"
      ]
    ]
    "ouvrage" => ""
    "keywords" => []
    "updatedAt" => "2021-07-13 14:30:52"
    "publicationUrl" => null
    "publicationInfo" => array:3 [
      "pages" => "345-378"
      "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" => "Dans cet article, nous présentons une approche de rétro-conception permettant d'extraire le schéma conceptuel d'une base de données relationnelle à partir de son schéma logique. Le processus de rétro-conception est formalisé au moyen de règles de rétro-conception définies sur deux méta-modèles. Le premier méta-modèle décrit la base de données relationnelle à rétro-concevoir. Il est alimenté par l'exploration des spécifications Data Definition Language (DDL) et Data Manipulation Language (DML) et par l'analyse de l'extension de la base. Le second méta-modèle représente le schéma conceptuel Entité-Relation Etendu (EER) issu du processus de rétro-conception. Les règles de rétro-conception sont mises en oeuvre en partant d'une présomption de sémantique, passant par une phase de consolidation pour finalement aboutir à sa confirmation. Un exemple non trivial illustre notre démarche, montrant à la fois la robustesse de l'approche et sa facilité de mise en oeuvre."
      "en" => "This paper presents a comprehensive framework for the conceptualization phase of relational database reverse engineering. Starting from a de-optimized 3NF relational scheme, our approach generates an Extended Entity Relationship scheme. To extract the conceptual scheme, the framework exploits the Data Definition Language specifications, the Data Manipulation Language specifications and the database extension. Reverse engineering rules are provided through a systematic mapping of a relational  database meta-model to a conceptual meta-model. Rules are defined through the application of heuristics. The rules are triggered at three levels of investigation: suspicion, reinforcement and confirmation. Our conceptualization framework has been applied to several fairly complex case - studies and proved to be robust and efficient."
    ]
    "authors_fields" => array:2 [
      "fr" => "Systèmes d'Information, Data Analytics et Opérations"
      "en" => "Information Systems, Data Analytics and Operations"
    ]
    "indexedAt" => "2024-11-21T15:21:45.000Z"
    "docTitle" => "Relational Database Reverse Engineering"
    "docSurtitle" => "Journal articles"
    "authorNames" => "<a href="/cv/wattiau-isabelle">COMYN-WATTIAU Isabelle</a>, AKOKA Jacky"
    "docDescription" => "<span class="document-property-authors">COMYN-WATTIAU Isabelle, AKOKA Jacky</span><br><span class="document-property-authors_fields">Information Systems, Data Analytics and Operations</span> | <span class="document-property-year">1999</span>"
    "keywordList" => ""
    "docPreview" => "<b>Relational Database Reverse Engineering</b><br><span>1999-07 | Journal articles </span>"
    "docType" => "research"
    "publicationLink" => "<a href="#" target="_blank">Relational Database Reverse Engineering</a>"
  ]
  +lang: "en"
  +"_type": "_doc"
  +"_score": 9.119175
  +"parent": null
}