{"id":179785,"date":"2024-05-14T14:20:21","date_gmt":"2024-05-14T13:20:21","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=179785"},"modified":"2024-02-25T16:38:46","modified_gmt":"2024-02-25T15:38:46","slug":"database-types-how-to-make-the-right-choice","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice","title":{"rendered":"Database Types: How to make the right choice"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"179785\" class=\"elementor elementor-179785\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9895b0b e-flex e-con-boxed e-con\" data-id=\"9895b0b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-08acde4 e-con-full e-flex e-con\" data-id=\"08acde4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cf50cc2 elementor-widget elementor-widget-heading\" data-id=\"cf50cc2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Data collection is the first step in creating a Machine Learning model. It is therefore essential to choose a database model that offers the features your application needs most.\nRelational and NoSQL databases are the two most widely used system families. They differ in structure, data storage and accessibility. In this article, we'll look at each of their specific features of different Database Types.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-310d6d1 e-flex e-con-boxed e-con\" data-id=\"310d6d1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-16e3ddc e-con-full e-flex e-con\" data-id=\"16e3ddc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ae03421 elementor-widget elementor-widget-heading\" data-id=\"ae03421\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Database Types - Relational databases:<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b484916 e-flex e-con-boxed e-con\" data-id=\"b484916\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cea6374 e-con-full e-flex e-con\" data-id=\"cea6374\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cf5dbdc elementor-widget elementor-widget-text-editor\" data-id=\"cf5dbdc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>They are the oldest type of general-purpose database still widely used today.<br \/><a href=\"https:\/\/datascientest.com\/en\/demystifying-mysql-a-comprehensive-guide-to-relational-data-managemen\">Relational databases<\/a> organize data using tables.<br \/>Tables are structures that impose a schema on the records they contain.<\/p><p>Each column in a table has a name and a <strong>data type.<\/strong> Each row represents a piece of data in the table, containing values for each column.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-122b6ed e-flex e-con-boxed e-con\" data-id=\"122b6ed\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-346f5b3 e-con-full e-flex e-con\" data-id=\"346f5b3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-49b9695 elementor-widget elementor-widget-image\" data-id=\"49b9695\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"480\" src=\"https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-relationnelle-1024x615.png\" class=\"attachment-large size-large wp-image-32547\" alt=\"bdd\" srcset=\"https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-relationnelle-1024x615.png 1024w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-relationnelle-300x180.png 300w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-relationnelle-768x461.png 768w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-relationnelle-1536x923.png 1536w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-relationnelle.png 1560w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f07c725 e-flex e-con-boxed e-con\" data-id=\"f07c725\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-2e30b7c e-con-full e-flex e-con\" data-id=\"2e30b7c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f72a4fc elementor-widget elementor-widget-text-editor\" data-id=\"f72a4fc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The<a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\"> SQL language<\/a> was created to access data stored in this format and to guarantee ACID properties. They are often suited to regular, predictable data. As they are schema-based, it can be more difficult to modify the data structure once it is in the system.<\/p><p>Overall, relational databases are a solid choice for many applications, as applications often generate well-ordered, structured data.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6b601be e-flex e-con-boxed e-con\" data-id=\"6b601be\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-24d6826 e-con-full e-flex e-con\" data-id=\"24d6826\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-be413c1 elementor-widget elementor-widget-heading\" data-id=\"be413c1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Database Types - NoSQL database<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-92dfdd5 e-flex e-con-boxed e-con\" data-id=\"92dfdd5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-15b49cf e-con-full e-flex e-con\" data-id=\"15b49cf\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9f44f8d elementor-widget elementor-widget-text-editor\" data-id=\"9f44f8d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The next types we&#8217;re going to look at belong to the <a href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\">NoSQL<\/a> database family: high-performance alternatives for data that doesn&#8217;t fit the relational model.<\/p><p>They excel in ease of use, scalability, resilience and availability.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-432ddf9 elementor-widget elementor-widget-heading\" data-id=\"432ddf9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Document-oriented database<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a9d7d4 elementor-widget elementor-widget-text-editor\" data-id=\"7a9d7d4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A good choice for rapid development, as you can change the properties of the <strong>data<\/strong> you wish to save at any time without modifying existing structures or data.<\/p><p>Each document is autonomous and has its own organization system. If you haven&#8217;t yet determined your data structure, this template could be a good starting point.<\/p><p>Be careful, however, as flexibility means that you are responsible for maintaining consistency, <strong>which can be extremely difficult.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5cf2af8 e-flex e-con-boxed e-con\" data-id=\"5cf2af8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-503a679 e-con-full e-flex e-con\" data-id=\"503a679\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cbf5135 elementor-widget elementor-widget-heading\" data-id=\"cbf5135\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Column-oriented database<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9f28ac5 e-flex e-con-boxed e-con\" data-id=\"9f28ac5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-c7d3dd9 e-con-full e-flex e-con\" data-id=\"c7d3dd9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7658a95 elementor-widget elementor-widget-text-editor\" data-id=\"7658a95\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Useful for<strong> applications requiring high performance for online operations and scalability<\/strong>. As all the data and metadata in an entry can be accessed with a single line identifier, no computationally expensive joins are needed to find and extract information.<\/p><p>However, they don&#8217;t work well in all cases. If you have <strong>highly relational data requiring joins,<\/strong> this is not the right model to use.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b936b6b e-flex e-con-boxed e-con\" data-id=\"b936b6b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-f3609d2 e-con-full e-flex e-con\" data-id=\"f3609d2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-13caccf elementor-widget elementor-widget-image\" data-id=\"13caccf\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"523\" src=\"https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-colonne-1024x669.png\" class=\"attachment-large size-large wp-image-32551\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-colonne-1024x669.png 1024w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-colonne-300x196.png 300w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-colonne-768x501.png 768w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-colonne.png 1435w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-809dc9a e-con-full e-flex e-con\" data-id=\"809dc9a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f928124 elementor-widget elementor-widget-heading\" data-id=\"f928124\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Graph-oriented database<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa756d6 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"aa756d6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>They are particularly useful when working with data with very large connections.<\/p><p>For example, finding the connection between two users of a<a href=\"https:\/\/datascientest.com\/en\/crm-customer-relationship-management-how-does-it-work\"> social network<\/a> in a relational database is likely to require multiple table joins and therefore be quite resource-intensive. This same query would be simple in a graphical database, which directly establishes correspondences between connections.<\/p><p>The <strong>aim of graphical databases<\/strong> is to make working with this type of data intuitive and powerful.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4b67b62 e-flex e-con-boxed e-con\" data-id=\"4b67b62\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-db7df32 e-con-full e-flex e-con\" data-id=\"db7df32\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-81563e5 elementor-widget elementor-widget-image\" data-id=\"81563e5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"475\" src=\"https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-graphe-1024x608.png\" class=\"attachment-large size-large wp-image-32552\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-graphe-1024x608.png 1024w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-graphe-300x178.png 300w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-graphe-768x456.png 768w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-graphe-1536x913.png 1536w, https:\/\/datascientest.com\/en\/files\/2021\/01\/Base-de-donnees-oriente-graphe.png 1727w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-90f2601 e-flex e-con-boxed e-con\" data-id=\"90f2601\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-ae07d27 e-con-full e-flex e-con\" data-id=\"ae07d27\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-354b332 elementor-widget elementor-widget-text-editor\" data-id=\"354b332\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Choosing the <strong>right database<\/strong> involves not only choosing the right typology, but also understanding the CAP theorem.<\/p><p>In the next article, we&#8217;ll take a look at the <strong>CAP theorem<\/strong>, so that you&#8217;re fully equipped to start your <strong>Data project.<\/strong><\/p><p>What if your Data project started with a <a href=\"https:\/\/datascientest.com\/en\/data-science-online-course-all-you-need-to-know\">Data Science training course<\/a> designed by experts and certified by the Sorbonne?<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ff93992 e-con-full e-flex e-con\" data-id=\"ff93992\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d9fb2cd elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d9fb2cd\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">All about Databases <\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c076180 e-flex e-con-boxed e-con\" data-id=\"c076180\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-658e1bf elementor-widget elementor-widget-html\" data-id=\"658e1bf\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"Relational Databases:\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"They are the oldest type of general-purpose database still widely used today. Relational databases organize data using tables. Tables are structures that impose a schema on the records they contain. Each column in a table has a name and a data type. Each row represents a piece of data in the table, which contains values for each column.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"NoSQL database\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The next types we're going to look at belong to the NoSQL database family: high-performance alternatives for data that don't fit the relational model. They excel in ease of use, scalability, resilience and availability features.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Graph-oriented database\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"These are particularly useful when working with data with very large connections. For example, finding the connection between two users of a social network in a relational database is likely to require multiple table joins and therefore be quite resource-intensive. This same query would be straightforward in a graphical database, which directly establishes correspondences between connections.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Data collection is the first step in creating a Machine Learning model. It is therefore essential to choose a database model that offers the features your application needs most. Relational and NoSQL databases are the two most widely used system families. They differ in structure, data storage and accessibility. In this article, we&#8217;ll look at [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":179793,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database Types: How to make the right choice<\/title>\n<meta name=\"description\" content=\"Delve into database typology to understand the intricacies of selecting the ideal database solution for your specific requirements, ensuring optimal functionality and performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Types: How to make the right choice\" \/>\n<meta property=\"og:description\" content=\"Data collection is the first step in creating a Machine Learning model. It is therefore essential to choose a database model that offers the features your\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-14T13:20:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-25T15:38:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/05\/database-types.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1406\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Database Types: How to make the right choice\",\"datePublished\":\"2024-05-14T13:20:21+00:00\",\"dateModified\":\"2024-02-25T15:38:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\"},\"wordCount\":511,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\",\"url\":\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\",\"name\":\"Database Types: How to make the right choice\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-05-14T13:20:21+00:00\",\"dateModified\":\"2024-02-25T15:38:46+00:00\",\"description\":\"Delve into database typology to understand the intricacies of selecting the ideal database solution for your specific requirements, ensuring optimal functionality and performance.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database Types: How to make the right choice","description":"Delve into database typology to understand the intricacies of selecting the ideal database solution for your specific requirements, ensuring optimal functionality and performance.","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:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice","og_locale":"en_GB","og_type":"article","og_title":"Database Types: How to make the right choice","og_description":"Data collection is the first step in creating a Machine Learning model. It is therefore essential to choose a database model that offers the features your","og_url":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-05-14T13:20:21+00:00","article_modified_time":"2024-02-25T15:38:46+00:00","og_image":[{"width":2560,"height":1406,"url":"https:\/\/datascientest.com\/en\/files\/2024\/05\/database-types.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Database Types: How to make the right choice","datePublished":"2024-05-14T13:20:21+00:00","dateModified":"2024-02-25T15:38:46+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice"},"wordCount":511,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice","url":"https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice","name":"Database Types: How to make the right choice","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-05-14T13:20:21+00:00","dateModified":"2024-02-25T15:38:46+00:00","description":"Delve into database typology to understand the intricacies of selecting the ideal database solution for your specific requirements, ensuring optimal functionality and performance.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/database-types-how-to-make-the-right-choice"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/179785"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=179785"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/179785\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/179793"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=179785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=179785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=179785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}