{"id":3498,"date":"2020-07-19T09:29:00","date_gmt":"2020-07-19T09:29:00","guid":{"rendered":"https:\/\/staging.novelis.io\/?post_type=scientific-pub&#038;p=3498"},"modified":"2022-02-25T10:54:53","modified_gmt":"2022-02-25T10:54:53","slug":"generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents","status":"publish","type":"scientific-pub","link":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/","title":{"rendered":"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents"},"content":{"rendered":"\n<p>D\u00e9couvrez notre article de conf\u00e9rence&nbsp;<a href=\"https:\/\/link.springer.com\/chapter\/10.1007\/978-3-030-53970-2_17\" target=\"_blank\" rel=\"noopener\">SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks<\/a>&nbsp;<a href=\"https:\/\/link.springer.com\/conference\/a2ia\" target=\"_blank\" rel=\"noopener\">\u2013 Conf\u00e9rence internationale sur l\u2019intelligence artificielle et les applications industrielles<\/a>&nbsp;\u2013&nbsp;<a href=\"https:\/\/link.springer.com\/bookseries\/15179\" target=\"_blank\" rel=\"noopener\">Lecture Notes in Networks and Systems<\/a>, publi\u00e9 dans Springer Link. Cette \u00e9tude est en anglais.<\/p>\n\n\n\n<p>Merci \u00e0 l\u2019<a href=\"https:\/\/novelis.io\/fr\/laboratoire-rd\/\">\u00e9quipe de recherche de Novelis<\/a> pour son savoir-faire et son expertise.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">&nbsp;<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"resume\">R\u00e9sum\u00e9<\/h2>\n\n\n\n<p>Les bases de donn\u00e9es stockent une grande quantit\u00e9 de donn\u00e9es et d\u2019informations d\u2019aujourd\u2019hui, et pour acc\u00e9der \u00e0 ces donn\u00e9es, les utilisateurs doivent ma\u00eetriser le langage SQL ou un langage d\u2019interface \u00e9quivalent. Par cons\u00e9quent, l\u2019utilisation d\u2019un syst\u00e8me capable de convertir une requ\u00eate en langage naturel en requ\u00eate SQL \u00e9quivalente rendrait les donn\u00e9es plus accessibles (SQL generation). Dans ce sens, la construction d\u2019interfaces en langage naturel pour les bases de donn\u00e9es relationnelles est un probl\u00e8me important et difficile dans le traitement du langage naturel (NLP) et un domaine largement \u00e9tudi\u00e9, qui a trouv\u00e9 r\u00e9cemment un nouvel \u00e9lan en raison de l\u2019introduction d\u2019ensembles de donn\u00e9es \u00e0 grande \u00e9chelle. Dans cet article, nous pr\u00e9sentons notre approche bas\u00e9e sur l\u2019int\u00e9gration de mots et les r\u00e9seaux neuronaux r\u00e9currents (RNN), plus pr\u00e9cis\u00e9ment sur les cellules de m\u00e9moire \u00e0 long terme (LSTM) et les unit\u00e9s r\u00e9currentes \u00e0 d\u00e9clenchement (GRU). Nous pr\u00e9sentons \u00e9galement le jeu de donn\u00e9es utilis\u00e9 pour l\u2019entra\u00eenement et le test de nos mod\u00e8les, bas\u00e9 sur WikiSQL, et enfin nous montrons o\u00f9 nous sommes arriv\u00e9s en termes de pr\u00e9cision.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">&nbsp;<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a-propos-de-l-etude\">A propos de l\u2019\u00e9tude<\/h2>\n\n\n\n<p>\u201cVast amount of today\u2019s information is stored in relational database and provide the foundation of applications such as medical records [1], financial markets [2], and cus- tomer relations management [3]. However, accessing relational databases requires an understanding of query languages such as SQL, which, while powerful, is difficult to master for non-technical users. Even for an expert, writing SQL queries can be chal- lenging, as it requires knowing the exact schema of the database and the roles of various entities in the query. Hence, researches has recently appeared to approach systems that map natural language to SQL query, and a long-standing goal has been to allow users to interact with the database through natural language [4,5]. We refer to this task as Text-to-SQL.\u201d<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"lire-l-article-complet\"><a href=\"https:\/\/link.springer.com\/chapter\/10.1007\/978-3-030-53970-2_17\" target=\"_blank\" rel=\"noopener\">Lire l\u2019article complet<\/a><\/h3>\n\n\n\n<p><a href=\"https:\/\/link.springer.com\/bookseries\/15179\" target=\"_blank\" rel=\"noopener\">Lecture Notes in Networks and Systems<\/a>&nbsp;(LNNS, volume 144)<\/p>\n\n\n\n<p><strong>SpringerLink fournit aux chercheurs l\u2019acc\u00e8s \u00e0 des millions de documents scientifiques provenant de revues, livres, s\u00e9ries, protocoles et ouvrages de r\u00e9f\u00e9rence<\/strong>.<\/p>\n","protected":false},"featured_media":2295,"template":"","categories":[24],"custom_tag":[167],"class_list":["post-3498","scientific-pub","type-scientific-pub","status-publish","has-post-thumbnail","hentry","category-publication-scientifique","custom_tag-sql-fr"],"acf":{"summary":"","filter_opacity":"70","subtitle":"","reading_time":"","authors":"","document_to_download":{"upload_a_file":false,"download_without_form":false,"file":false,"url":""},"externel_link":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez notre article de conf\u00e9rence\u00a0SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couvrez notre article de conf\u00e9rence\u00a0SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/\" \/>\n<meta property=\"og:site_name\" content=\"Novelis innovation\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/novelis.io\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-25T10:54:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@novelis_io\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/\",\"url\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/\",\"name\":\"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents\",\"isPartOf\":{\"@id\":\"https:\/\/novelis.io\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png\",\"datePublished\":\"2020-07-19T09:29:00+00:00\",\"dateModified\":\"2022-02-25T10:54:53+00:00\",\"description\":\"D\u00e9couvrez notre article de conf\u00e9rence\u00a0SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks.\",\"breadcrumb\":{\"@id\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#primaryimage\",\"url\":\"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png\",\"contentUrl\":\"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/novelis.io\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/novelis.io\/fr\/#website\",\"url\":\"https:\/\/novelis.io\/fr\/\",\"name\":\"Novelis innovation\",\"description\":\"Novelis innovation\",\"publisher\":{\"@id\":\"https:\/\/novelis.io\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/novelis.io\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/novelis.io\/fr\/#organization\",\"name\":\"Novelis innovation\",\"url\":\"https:\/\/novelis.io\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/novelis.io\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/novelis.io\/wp-content\/uploads\/2021\/12\/logo-1.png\",\"contentUrl\":\"https:\/\/novelis.io\/wp-content\/uploads\/2021\/12\/logo-1.png\",\"width\":479,\"height\":98,\"caption\":\"Novelis innovation\"},\"image\":{\"@id\":\"https:\/\/novelis.io\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/novelis.io\",\"https:\/\/x.com\/novelis_io\",\"https:\/\/www.linkedin.com\/company\/novelis-consulting\/\",\"https:\/\/www.youtube.com\/channel\/UCJ5eJR22n2GtfKaTWueWRPQ\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents","description":"D\u00e9couvrez notre article de conf\u00e9rence\u00a0SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/","og_locale":"fr_FR","og_type":"article","og_title":"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents","og_description":"D\u00e9couvrez notre article de conf\u00e9rence\u00a0SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks.","og_url":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/","og_site_name":"Novelis innovation","article_publisher":"https:\/\/www.facebook.com\/novelis.io","article_modified_time":"2022-02-25T10:54:53+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@novelis_io","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/","url":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/","name":"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents","isPartOf":{"@id":"https:\/\/novelis.io\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#primaryimage"},"image":{"@id":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#primaryimage"},"thumbnailUrl":"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png","datePublished":"2020-07-19T09:29:00+00:00","dateModified":"2022-02-25T10:54:53+00:00","description":"D\u00e9couvrez notre article de conf\u00e9rence\u00a0SQL Generation from Natural Language Using Supervised Learning and Recurrent Neural Networks.","breadcrumb":{"@id":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#primaryimage","url":"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png","contentUrl":"https:\/\/novelis.io\/wp-content\/uploads\/2022\/02\/images-12.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/novelis.io\/fr\/scientific-pub\/generation-de-sql-a-partir-du-langage-naturel-a-laide-de-lapprentissage-supervise-et-des-reseaux-neuronaux-recurrents\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/novelis.io\/fr\/"},{"@type":"ListItem","position":2,"name":"G\u00e9n\u00e9ration de SQL \u00e0 partir du langage naturel \u00e0 l\u2019aide de l\u2019apprentissage supervis\u00e9 et des r\u00e9seaux neuronaux r\u00e9currents"}]},{"@type":"WebSite","@id":"https:\/\/novelis.io\/fr\/#website","url":"https:\/\/novelis.io\/fr\/","name":"Novelis innovation","description":"Novelis innovation","publisher":{"@id":"https:\/\/novelis.io\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/novelis.io\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/novelis.io\/fr\/#organization","name":"Novelis innovation","url":"https:\/\/novelis.io\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/novelis.io\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/novelis.io\/wp-content\/uploads\/2021\/12\/logo-1.png","contentUrl":"https:\/\/novelis.io\/wp-content\/uploads\/2021\/12\/logo-1.png","width":479,"height":98,"caption":"Novelis innovation"},"image":{"@id":"https:\/\/novelis.io\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/novelis.io","https:\/\/x.com\/novelis_io","https:\/\/www.linkedin.com\/company\/novelis-consulting\/","https:\/\/www.youtube.com\/channel\/UCJ5eJR22n2GtfKaTWueWRPQ"]}]}},"_links":{"self":[{"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/scientific-pub\/3498"}],"collection":[{"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/scientific-pub"}],"about":[{"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/types\/scientific-pub"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/media\/2295"}],"wp:attachment":[{"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/media?parent=3498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/categories?post=3498"},{"taxonomy":"custom_tag","embeddable":true,"href":"https:\/\/novelis.io\/fr\/wp-json\/wp\/v2\/custom_tag?post=3498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}