{"id":1016,"date":"2024-07-31T10:04:56","date_gmt":"2024-07-31T08:04:56","guid":{"rendered":"https:\/\/blog.sutilweb.eu\/?page_id=1016"},"modified":"2024-07-31T10:04:57","modified_gmt":"2024-07-31T08:04:57","slug":"02-conceptos-basicos-de-las-bases-de-datos","status":"publish","type":"page","link":"https:\/\/sutilweb.eu\/index.php\/databases\/diseno-de-bases-de-datos\/02-conceptos-basicos-de-las-bases-de-datos\/","title":{"rendered":"02. Conceptos b\u00e1sicos de las bases de datos"},"content":{"rendered":"\n<p>Para el <strong>modelado de base de datos<\/strong> es muy importante entender algunos conceptos. El mundo moderno est\u00e1 completamente centrado en la <strong>informaci\u00f3n<\/strong> y los <strong>datos.<\/strong><\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Informaci\u00f3n y datos (diferencia)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Dato<\/h3>\n\n\n\n<p>Un dato es una unidad singular de conocimiento. Es la <strong>m\u00ednima cantidad de informaci\u00f3n<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Informaci\u00f3n<\/h3>\n\n\n\n<p>La informaci\u00f3n es la que nos permite dar el contexto a los datos para poder dotarles de significado. Es un <strong>conjunto de datos<\/strong> que nos van a generar conocimiento, el cual nos va a permitir resolver necesidades o circunstancias.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Que es una base de datos<\/h2>\n\n\n\n<p>Es una colecci\u00f3n de <strong>informaci\u00f3n<\/strong> cuidadosamente organizada en un sistema, y por sistema hablamos desde <strong>libretas, agendas&#8230;<\/strong> hasta <strong>ordenadores&#8230;<\/strong> No tiene porque ser algo digital, aunque con los avances, todo ello se traslad\u00f3 a los entornos digitales.<\/p>\n\n\n\n<p>La <strong>tecnolog\u00eda<\/strong> que nos permite organizar los datos y representar lo esencial para un sistema de informaci\u00f3n se va a denominar sistema gestor de bases de datos, tambi\u00e9n conocido como <strong>SGBD<\/strong> (<strong>sistema gestor de bases de datos<\/strong>) \/ <strong>DBMS<\/strong> (<strong>database management system<\/strong>). Este software nos va a permitir manipular dichos <strong>datos.<\/strong><\/p>\n\n\n\n<p>Decir que <strong>MongoDB, Firebase, MySQ&#8230;<\/strong> son bases de datos no es correcto, son <strong>sistemas gestores de bases de datos<\/strong>. Estos nos permiten gestionar la informaci\u00f3n de una base de datos de forma digital.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ventajas de utilizar SGBD<\/h2>\n\n\n\n<p>Est\u00e1n optimizados para almacenar grandes vol\u00famenes de informaci\u00f3n, a diferencia de lo que podemos gestionar en una agenda. Nos ofrece mayor seguridad y administraci\u00f3n de la informaci\u00f3n. Van a garantizar la integridad de los datos.<\/p>\n\n\n\n<p>Los SGBD los podemos clasificar en dos grandes grupos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sistemas Gestores relacionales, vinculados con el c\u00f3digo SQL.<\/li>\n\n\n\n<li>Sistemas gestores no relacionales, denominados NoSQL.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Para el modelado de base de datos es muy importante entender algunos conceptos. El mundo moderno est\u00e1 completamente centrado en [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1009,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-1016","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Sutil Web","author_link":"https:\/\/sutilweb.eu\/index.php\/author\/sutilweb\/"},"uagb_comment_info":0,"uagb_excerpt":"Para el modelado de base de datos es muy importante entender algunos conceptos. El mundo moderno est\u00e1 completamente centrado en [&hellip;]","_links":{"self":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/comments?post=1016"}],"version-history":[{"count":1,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1016\/revisions"}],"predecessor-version":[{"id":1017,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1016\/revisions\/1017"}],"up":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1009"}],"wp:attachment":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/media?parent=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}