{"id":94,"date":"2007-12-13T21:06:40","date_gmt":"2007-12-14T02:06:40","guid":{"rendered":"https:\/\/www.cavsi.com\/blog\/que-5\/"},"modified":"2007-12-13T21:06:40","modified_gmt":"2007-12-14T02:06:40","slug":"que-es-esquema-en-estrella","status":"publish","type":"post","link":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/","title":{"rendered":"\u00bfQu\u00e9 es un esquema en estrella?"},"content":{"rendered":"<p>En las bases de datos usadas para <strong>data warehousing<\/strong>, un <strong>esquema en estrella <\/strong>es aquel que tiene una tabla fact de hechos que contiene los datos de an\u00e1lisis, rodeada de las tablas lookup o de dimensiones. Este aspecto, de tabla de hechos (o central) m\u00e1s grande rodeada de radios o tablas m\u00e1s peque\u00f1as es lo que asemeja con una estrella.<\/p>\n<p>Este esquema es ideal por su simplicidad y velocidad para ser usado para an\u00e1lisis: DataMarts (Mercado de datos) y EIS (Sistemas de informaci\u00f3n ejecutiva). Permite acceder tanto a datos agregados como de detalle.<\/p>\n<p>Adem\u00e1s, permite reducir el n\u00famero de joins entre tablas y deja a los usuarios establecer jerarqu\u00edas y niveles entre las dimensiones.<\/p>\n<p>Finalmente, es la opci\u00f3n con mejor rendimiento y velocidad pues permite indexar las dimensiones de forma individualizada sin que repercuta en el rendimiento de la base de datos en su conjunto.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En las bases de datos usadas para data warehousing, un esquema en estrella es aquel que tiene una tabla fact de hechos que contiene los datos de an\u00e1lisis, rodeada de las tablas lookup o de dimensiones. Este aspecto, de tabla de hechos (o central) m\u00e1s grande rodeada de radios o tablas m\u00e1s peque\u00f1as es lo que asemeja con una estrella.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[81],"tags":[200],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-software","tag-bases-de-datos"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00bfQu\u00e9 es un esquema en estrella? - CAVSI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfQu\u00e9 es un esquema en estrella? - CAVSI\" \/>\n<meta property=\"og:description\" content=\"En las bases de datos usadas para data warehousing, un esquema en estrella es aquel que tiene una tabla fact de hechos que contiene los datos de an\u00e1lisis, rodeada de las tablas lookup o de dimensiones. Este aspecto, de tabla de hechos (o central) m\u00e1s grande rodeada de radios o tablas m\u00e1s peque\u00f1as es lo que asemeja con una estrella.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\" \/>\n<meta property=\"og:site_name\" content=\"CAVSI\" \/>\n<meta property=\"article:published_time\" content=\"2007-12-14T02:06:40+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\"},\"headline\":\"\u00bfQu\u00e9 es un esquema en estrella?\",\"datePublished\":\"2007-12-14T02:06:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\"},\"wordCount\":161,\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"keywords\":[\"Bases de datos\"],\"articleSection\":[\"Software\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\",\"name\":\"\u00bfQu\u00e9 es un esquema en estrella? - CAVSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\"},\"datePublished\":\"2007-12-14T02:06:40+00:00\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"name\":\"CAVSI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\",\"name\":\"CAVSI\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"width\":300,\"height\":70,\"caption\":\"CAVSI\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.cavsi.com\/espanol\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfQu\u00e9 es un esquema en estrella? - CAVSI","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:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfQu\u00e9 es un esquema en estrella? - CAVSI","og_description":"En las bases de datos usadas para data warehousing, un esquema en estrella es aquel que tiene una tabla fact de hechos que contiene los datos de an\u00e1lisis, rodeada de las tablas lookup o de dimensiones. Este aspecto, de tabla de hechos (o central) m\u00e1s grande rodeada de radios o tablas m\u00e1s peque\u00f1as es lo que asemeja con una estrella.","og_url":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/","og_site_name":"CAVSI","article_published_time":"2007-12-14T02:06:40+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/#article","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/"},"author":{"name":"admin","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff"},"headline":"\u00bfQu\u00e9 es un esquema en estrella?","datePublished":"2007-12-14T02:06:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/"},"wordCount":161,"publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"keywords":["Bases de datos"],"articleSection":["Software"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/","url":"https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/","name":"\u00bfQu\u00e9 es un esquema en estrella? - CAVSI","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/#website"},"datePublished":"2007-12-14T02:06:40+00:00","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cavsi.com\/espanol\/blog\/que-es-esquema-en-estrella\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.cavsi.com\/espanol\/#website","url":"https:\/\/www.cavsi.com\/espanol\/","name":"CAVSI","description":"","publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.cavsi.com\/espanol\/#organization","name":"CAVSI","url":"https:\/\/www.cavsi.com\/espanol\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","width":300,"height":70,"caption":"CAVSI"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.cavsi.com\/espanol"]}]}},"_links":{"self":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":0,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}