{"id":179785,"date":"2024-05-14T14:20:21","date_gmt":"2024-05-14T13:20:21","guid":{"rendered":"https:\/\/liora.io\/en\/?p=179785"},"modified":"2026-02-06T08:02:08","modified_gmt":"2026-02-06T07:02:08","slug":"database-types-how-to-make-the-right-choice","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/database-types-how-to-make-the-right-choice","title":{"rendered":"Database Types: How to make the right choice"},"content":{"rendered":"<style>\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><p><strong>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&#8217;ll look at each of their specific features of different Database Types.<\/strong><\/p>\t\t\n\t\t\t<h3>Database Types &#8211; Relational databases:<\/h3>\t\t\n\t\t<p>They are the oldest type of general-purpose database still widely used today.<br><a href=\"https:\/\/liora.io\/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\n\t\t\t<style>\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>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"480\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-relationnelle-1024x615.png\" alt=\"bdd\" loading=\"lazy\" srcset=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-relationnelle-1024x615.png 1024w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-relationnelle-300x180.png 300w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-relationnelle-768x461.png 768w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-relationnelle-1536x923.png 1536w, https:\/\/liora.io\/app\/uploads\/sites\/9\/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><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t<p>The<a href=\"https:\/\/liora.io\/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\n\t\t\t<h3>Database Types &#8211; NoSQL database<\/h3>\t\t\n\t\t<p>The next types we&#8217;re going to look at belong to the <a href=\"https:\/\/liora.io\/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\n\t\t\t<h4>Document-oriented database<\/h4>\t\t\n\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\n\t\t\t<h4>Column-oriented database<\/h4>\t\t\n\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\n\t\t\t\t\t\t\t\t\t\t\t\t<figure>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"523\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-colonne-1024x669.png\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-colonne-1024x669.png 1024w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-colonne-300x196.png 300w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-colonne-768x501.png 768w, https:\/\/liora.io\/app\/uploads\/sites\/9\/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><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t<h4>Graph-oriented database<\/h4>\t\t\n\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:\/\/liora.io\/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\n\t\t\t\t\t\t\t\t\t\t\t\t<figure>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"475\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-graphe-1024x608.png\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-graphe-1024x608.png 1024w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-graphe-300x178.png 300w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-graphe-768x456.png 768w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2021\/01\/Base-de-donnees-oriente-graphe-1536x913.png 1536w, https:\/\/liora.io\/app\/uploads\/sites\/9\/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><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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:\/\/liora.io\/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\n\t\t\t\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><div class=\"wp-block-button \"><a class=\"wp-block-button__link wp-element-button \" href=\"\/formation\/data-ia\/\">All about Databases<\/a><\/div><\/div>\n","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":76,"featured_media":179793,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-179785","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/179785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=179785"}],"version-history":[{"count":1,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/179785\/revisions"}],"predecessor-version":[{"id":205739,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/179785\/revisions\/205739"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/179793"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=179785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=179785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}