{"id":133,"date":"2008-11-15T13:31:25","date_gmt":"2008-11-15T12:31:25","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=133"},"modified":"2008-11-15T13:46:51","modified_gmt":"2008-11-15T12:46:51","slug":"une-quinzaine-de-raisons-pour-choisir-ou-ne-pas-choisir-un-sgbdr","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2008\/11\/15\/une-quinzaine-de-raisons-pour-choisir-ou-ne-pas-choisir-un-sgbdr\/","title":{"rendered":"Une quinzaine de raisons pour choisir ou ne pas choisir un SGBDR"},"content":{"rendered":"<p>Faire le choix d&rsquo;un SGBDR pour g\u00e9rer ses donn\u00e9es est devenu un r\u00e9flexe, mais est ce toujours n\u00e9cessaire ?<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Avantages<\/strong><\/span><\/p>\n<ul>\n<li>Contr\u00f4le de la redondance des donn\u00e9es (normalisation)<\/li>\n<li>Coh\u00e9rence des donn\u00e9es (ACID)<\/li>\n<li>Int\u00e9grit\u00e9 des donn\u00e9es (ACID)<\/li>\n<li>Standards (SQL ANSI)<\/li>\n<li>Am\u00e9lioration de la productivit\u00e9<\/li>\n<li>Permet une meilleur concurrence en lecture comme en \u00e9criture<\/li>\n<li>M\u00e9canismes de sauvegarde et de restauration<\/li>\n<li>Facilit\u00e9 pour manipuler les donn\u00e9es gr\u00e2ce \u00e0 un langage d\u00e9di\u00e9 SQL<\/li>\n<li>Fonctionnalit\u00e9s avanc\u00e9es (haute disponibilit\u00e9s, r\u00e9plication, clustering, proc\u00e9dure stock\u00e9es,&#8230;)<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\"><strong>Inconv\u00e9nients<\/strong><\/span><\/p>\n<ul>\n<li>Apprentissage d&rsquo;un logiciel (plus ou moins complexe)<\/li>\n<li>Taille (espace disque et m\u00e9moire non n\u00e9gligeable)<\/li>\n<li>Co\u00fbt (Jusqu&rsquo;a tres couteux pour une solution propri\u00e9taire, \u00e0 beaucoup moins pour une solution open source)<\/li>\n<li>Co\u00fbts suppl\u00e9mentaires en materiel (espace de stockage, RAM, r\u00e9seaux, &#8230;)<\/li>\n<li>Co\u00fbt de la migration des donn\u00e9es<\/li>\n<li>Performances (d\u00e9pendent de la solution retenue et surtout des comp\u00e9tences du dba et des d\u00e9veloppeurs)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Faire le choix d&rsquo;un SGBDR pour g\u00e9rer ses donn\u00e9es est devenu un r\u00e9flexe, mais est ce toujours n\u00e9cessaire ?<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[3,8],"tags":[48],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry","category-divers","category-mysql","tag-sgbdr"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-29","jetpack-related-posts":[{"id":26,"url":"https:\/\/dasini.net\/blog\/2008\/10\/29\/mysql-50-un-sgbdr-mature-part-34\/","url_meta":{"origin":133,"position":0},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 3\/4)","author":"Olivier DASINI","date":"29 octobre 2008","format":false,"excerpt":"Les proc\u00e9dures stock\u00e9es sont des listes de commandes qui peuvent \u00eatre compil\u00e9es et stock\u00e9es sur le serveur. Elles permettent de d\u00e9placer une partie de la logique m\u00e9tier d'une application de base de donn\u00e9es du client vers le serveur. Les clients n\u2019ont plus besoin de soumettre \u00e0 nouveau toute la commande,\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":41,"url":"https:\/\/dasini.net\/blog\/2008\/10\/30\/mysql-50-un-sgbdr-mature-part-44\/","url_meta":{"origin":133,"position":1},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 4\/4)","author":"Olivier DASINI","date":"30 octobre 2008","format":false,"excerpt":"Les d\u00e9clencheurs (triggers) sont des ordres de d\u00e9clenchement d'op\u00e9rations quand un \u00e9v\u00e8nement survient sur une table.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":127,"url":"https:\/\/dasini.net\/blog\/2008\/11\/14\/presentation-mysql-50-un-sgbdr-mature\/","url_meta":{"origin":133,"position":2},"title":"Pr\u00e9sentation : MySQL 5.0, un SGBDR mature ?","author":"Olivier DASINI","date":"14 novembre 2008","format":false,"excerpt":"MySQL est le SGBDR Open Source le plus populaire au monde. Sa cinqui\u00e8me version, sortie en octobre 2005, permet de mieux r\u00e9pondre aux probl\u00e9matiques d\u2019entreprise. Au menu des nouveaut\u00e9s fonctionnelles : les vues, les proc\u00e9dures stock\u00e9es, les d\u00e9clencheurs, de nouveaux moteurs de stockage, la base de donn\u00e9es INFORMATION_SCHEMA et diverses\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":192,"url":"https:\/\/dasini.net\/blog\/2008\/11\/23\/mysql-5-les-vues-part-17\/","url_meta":{"origin":133,"position":3},"title":"MySQL 5 : Les vues &#8212; (part 1\/7)","author":"Olivier DASINI","date":"23 novembre 2008","format":false,"excerpt":"Le langage SQL acronyme de Structured Query Language (Langage Structur\u00e9 de Requ\u00eates), a \u00e9t\u00e9 con\u00e7u pour g\u00e9rer les donn\u00e9es dans un SGBDR. A l'aide des DML (Data Manipulation Language ie les requ\u00eates SELECT, INSERT, UPDATE, DELETE) il est possible de manipuler ces donn\u00e9es qui sont stock\u00e9es dans des tables. SQL\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14,"url":"https:\/\/dasini.net\/blog\/2008\/10\/28\/mysql-50-un-sgbdr-mature-part-24\/","url_meta":{"origin":133,"position":4},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 2\/4)","author":"Olivier DASINI","date":"28 octobre 2008","format":false,"excerpt":"Les vues sont la plupart du temps utiles pour donner aux utilisateurs l\u2019acc\u00e8s \u00e0 un ensemble de relations repr\u00e9sent\u00e9es sous la forme d'une table. Une vue est une table virtuelle ; les donn\u00e9es de la vue sont en fait des champs de diff\u00e9rentes tables regroup\u00e9es, ou des r\u00e9sultats d\u2019op\u00e9rations sur\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1445,"url":"https:\/\/dasini.net\/blog\/2013\/07\/10\/lemug-fr-a-la-radio\/","url_meta":{"origin":133,"position":5},"title":"LeMug.fr \u00e0 la radio","author":"Olivier DASINI","date":"10 juillet 2013","format":false,"excerpt":"L\u2019association LeMug.fr (MySQL User Group Francophone) fut l\u2019invit\u00e9 \u00e0 l\u2019\u00e9mission Cyberculture de la radio Ici et Maintenant samedi 6 juillet pour parler des bases de donn\u00e9es webs et principalement de la base de donn\u00e9es la plus utilis\u00e9e sur internet : MySQL. Le podcast de l\u2019\u00e9mission est disponible ici : Les\u2026","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":5,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"predecessor-version":[{"id":145,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/133\/revisions\/145"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}