{"id":1185,"date":"2025-01-03T18:49:08","date_gmt":"2025-01-03T17:49:08","guid":{"rendered":"https:\/\/palocatelli.com\/?p=1185"},"modified":"2025-01-07T16:38:13","modified_gmt":"2025-01-07T15:38:13","slug":"base-de-donnees-inspiree-de-the-binding-of-isaac","status":"publish","type":"post","link":"https:\/\/palocatelli.com\/index.php\/2025\/01\/03\/base-de-donnees-inspiree-de-the-binding-of-isaac\/","title":{"rendered":"Base de donn\u00e9es inspir\u00e9e de The Binding of Isaac"},"content":{"rendered":"\n<p>Pendant l&#8217;\u00e9t\u00e9 2024, dans le cadre de ma <a href=\"https:\/\/gamingcampus.fr\/pro\/developpement-jeux-video.html\">formation professionnelle de Game Developpement<\/a> aupr\u00e8s de l&#8217;\u00e9cole Gaming Campus, j&#8217;ai men\u00e9 un projet de r\u00e9alisation de Base de Donn\u00e9es. Le cahier des charges exigeait de repr\u00e9senter en partie les donn\u00e9es pr\u00e9sentes dans un jeu vid\u00e9o, celui de notre choix.<\/p>\n\n\n\n<p>J&#8217;ai choisi de m&#8217;inspirer du jeu vid\u00e9o The Binding of Isaac : Rebirth, un jeu d&#8217;action-aventure &#8220;roguelite&#8221; d\u00e9velopp\u00e9 par Edmund McMillen et sorti en 2014.<\/p>\n\n\n\n<p>La pr\u00e9sentation de ce projet dans un rapport et au cours d&#8217;un oral m&#8217;ont permis de valider ma formation et d&#8217;obtenir un dipl\u00f4me de &#8220;L&#8217;\u00c9cole Gaming Campus pour les pros&#8221;, pour l&#8217;ensemble du programme de &#8220;D\u00e9veloppement de jeux vid\u00e9o, en ligne&#8221;. Cela conclut une formation professionnelle en ligne de 6 mois aupr\u00e8s de l&#8217;\u00e9cole. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9thodologie :<\/h2>\n\n\n\n<p>J&#8217;ai r\u00e9alis\u00e9 enti\u00e8rement la base de donn\u00e9e, de sa conception \u00e0 ses tests, en suivant les diff\u00e9rentes \u00e9tapes de la <a href=\"https:\/\/www.base-de-donnees.com\/merise\/\" target=\"_blank\" rel=\"noreferrer noopener\">M\u00e9thode Merise<\/a> appliqu\u00e9e \u00e0 la conception des bases de donn\u00e9es :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formalisation : identification des donn\u00e9es, cr\u00e9ation d&#8217;un dictionnaire de donn\u00e9es, cr\u00e9ation d&#8217;un Mod\u00e8le Conceptuel de Donn\u00e9es (MCD) puis d&#8217;un Mod\u00e8le Logique de Donn\u00e9es (MLD).<\/li>\n\n\n\n<li>Cr\u00e9ation et remplissage de la base<\/li>\n\n\n\n<li>Automatisation de la base, via des d\u00e9clencheurs, s\u2019activant au moment des requ\u00eates pour assurer la coh\u00e9rence des donn\u00e9es.<\/li>\n\n\n\n<li>Contr\u00f4le de la base, via des requ\u00eates test et des vues servant \u00e0 v\u00e9rifier son fonctionnement.<\/li>\n\n\n\n<li>Sa sauvegarde et son encryptage.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Outils utilis\u00e9s<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Looping pour le MLD et le MCD<\/li>\n\n\n\n<li>DB Browser for SQLite pour la cr\u00e9ation, l&#8217;automatisation et le contr\u00f4le de la base de donn\u00e9es.<\/li>\n\n\n\n<li>DB Browser for SQLCipher pour l&#8217;encryptage de la base.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"593\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1024x593.png\" alt=\"\" class=\"wp-image-1196\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1024x593.png 1024w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-300x174.png 300w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-768x445.png 768w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-330x190.png 330w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-104x60.png 104w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image.png 1129w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><sub>Mod\u00e8le Conceptuel de Donn\u00e9es<\/sub><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"471\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1.png\" alt=\"\" class=\"wp-image-1197\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1.png 813w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1-300x174.png 300w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1-768x445.png 768w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1-330x190.png 330w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-1-104x60.png 104w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><figcaption class=\"wp-element-caption\"><sub>Mod\u00e8le Logique de Donn\u00e9es<\/sub><\/figcaption><\/figure>\n\n\n\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-e3e06330 wp-block-group-is-layout-flex\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"677\" height=\"434\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-6.png\" alt=\"\" class=\"wp-image-1202\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-6.png 677w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-6-300x192.png 300w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-6-94x60.png 94w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"312\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-7.png\" alt=\"\" class=\"wp-image-1203\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-7.png 256w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-7-246x300.png 246w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-7-49x60.png 49w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"648\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-9.png\" alt=\"\" class=\"wp-image-1205\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-9.png 356w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-9-165x300.png 165w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-9-33x60.png 33w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/figure>\n<\/div>\n\n\n\n<p><sub>Tables repr\u00e9sentant les items du jeu et leurs cat\u00e9gories, dans la base de donn\u00e9es.<\/sub><\/p>\n\n\n\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-e3e06330 wp-block-group-is-layout-flex\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"365\" height=\"395\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-4.png\" alt=\"\" class=\"wp-image-1200\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-4.png 365w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-4-277x300.png 277w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-4-55x60.png 55w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><figcaption class=\"wp-element-caption\"><sub>Liste des personnages dans le jeu<\/sub><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"677\" height=\"287\" src=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-5.png\" alt=\"\" class=\"wp-image-1201\" srcset=\"https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-5.png 677w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-5-300x127.png 300w, https:\/\/palocatelli.com\/wp-content\/uploads\/2025\/01\/image-5-142x60.png 142w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><figcaption class=\"wp-element-caption\"><sub>Liste \u00e9quivalente dans une vue de la base<\/sub><\/figcaption><\/figure>\n<\/div>\n\n\n\n<p>Pour mon compte rendu complet et ma pr\u00e9sentation de soutenance, <a href=\"https:\/\/drive.google.com\/drive\/folders\/1_xMP2aM3TxttWLmspiVb1_O7TlGL974o?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">cliquez ici<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pendant l&#8217;\u00e9t\u00e9 2024, dans le cadre de ma formation professionnelle de Game Developpement aupr\u00e8s de l&#8217;\u00e9cole Gaming Campus, j&#8217;ai men\u00e9 un projet de r\u00e9alisation de Base de Donn\u00e9es. Le cahier des charges exigeait de repr\u00e9senter en partie les donn\u00e9es pr\u00e9sentes dans un jeu vid\u00e9o, celui de notre choix. J&#8217;ai choisi de m&#8217;inspirer du jeu vid\u00e9o &hellip; <\/p>\n","protected":false},"author":1,"featured_media":1215,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,24,21],"tags":[17,20],"class_list":["post-1185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-game-dev","category-informatique","category-jeu-video","tag-gamedev","tag-jeu-video"],"_links":{"self":[{"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/posts\/1185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/comments?post=1185"}],"version-history":[{"count":4,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/posts\/1185\/revisions"}],"predecessor-version":[{"id":1208,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/posts\/1185\/revisions\/1208"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/media\/1215"}],"wp:attachment":[{"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/media?parent=1185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/categories?post=1185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/palocatelli.com\/index.php\/wp-json\/wp\/v2\/tags?post=1185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}