{"id":65,"date":"2020-03-19T02:32:30","date_gmt":"2020-03-19T07:32:30","guid":{"rendered":"https:\/\/opuscumdata.com\/?p=65"},"modified":"2020-03-20T02:52:15","modified_gmt":"2020-03-20T07:52:15","slug":"ejemplo-diseno-fisico-bases-de-datos","status":"publish","type":"post","link":"https:\/\/opuscumdata.com\/?p=65","title":{"rendered":"Ejemplo de un dise\u00f1o f\u00edsico de base de datos"},"content":{"rendered":"\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"204\" height=\"178\" src=\"https:\/\/opuscumdata.com\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-19-at-18.42.50.png\" alt=\"\" class=\"wp-image-149\"\/><\/figure><\/div>\n\n\n\n<p class=\"has-drop-cap\">El dise\u00f1o f\u00edsico\ntiene como objetivo definir las especificaciones de implementaci\u00f3n que\nconlleven a la materializaci\u00f3n de la base de datos. <\/p>\n\n\n\n<p>Para realizar el\ndise\u00f1o f\u00edsico se requiere como insumos:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>El dise\u00f1o l\u00f3gico<\/li><li>Las transacciones de datos<\/li><li>La selecci\u00f3n del SGBD a usar<\/li><li>La proyecci\u00f3n de la cantidad de \u00edtems a\nalmacenar<\/li><li>El an\u00e1lisis transaccional<\/li><\/ul>\n\n\n\n<p>En el documento adjunto se muestra el proceso de dise\u00f1o f\u00edsico de una base de datos Oracle para el caso de estudio FILMES<\/p>\n\n\n\n<div class=\"wp-block-cgb-block-algori-pdf-viewer\"><iframe class=\"wp-block-cgb-block-algori-pdf-viewer-iframe\" src=\"https:\/\/opuscumdata.com\/wp-content\/plugins\/algori-pdf-viewer\/dist\/web\/viewer.html?file=https%3A%2F%2Fopuscumdata.com%2Fwp-content%2Fuploads%2F2020%2F03%2FDisenoFisicoDeUnaBaseDeDatosOracle_v3.pdf\" style=\"width:600px;height:400px\"><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>El dise\u00f1o f\u00edsico tiene como objetivo definir las especificaciones de implementaci\u00f3n que conlleven a la materializaci\u00f3n de la base de datos. Para realizar el dise\u00f1o f\u00edsico se requiere como insumos: El dise\u00f1o l\u00f3gico Las transacciones de datos La selecci\u00f3n del SGBD a usar La proyecci\u00f3n de la cantidad de \u00edtems a almacenar El an\u00e1lisis transaccional&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[6,13],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-diseno-de-bases-de-datos","tag-bases-de-datos","tag-diseno-fisico"],"_links":{"self":[{"href":"https:\/\/opuscumdata.com\/index.php?rest_route=\/wp\/v2\/posts\/65"}],"collection":[{"href":"https:\/\/opuscumdata.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opuscumdata.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opuscumdata.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opuscumdata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":13,"href":"https:\/\/opuscumdata.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/opuscumdata.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/opuscumdata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opuscumdata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opuscumdata.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}