{"id":1732,"date":"2019-03-25T17:36:24","date_gmt":"2019-03-25T20:36:24","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/"},"modified":"2019-03-25T17:36:24","modified_gmt":"2019-03-25T20:36:24","slug":"kb27358-bancos-de-dados-vs-tabelas-vs-campos","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/","title":{"rendered":"KB-27358: Bancos de Dados vs. Tabelas vs. Campos."},"content":{"rendered":"<div style=\"text-align:justify;\" align=\"justify\"><span style=\"font-weight:bold;\">Descri\u00e7\u00e3o:<\/span><\/p>\n<p>Em uma aplica\u00e7\u00e3o, \u00e9 preciso gravar os valores de 25 vari\u00e1veis em um banco de dados Access para serem carregadas por um E3Chart. Quais das op\u00e7\u00f5es abaixo \u00e9 a melhor para isto?<\/p>\n<ol>\n<li>Um \u00fanico banco de dados com uma tabela de Hist\u00f3rico com 25 campos.<\/li>\n<li>Um \u00fanico banco de dados com 25 tabelas de Hist\u00f3ricos com apenas um campo em cada tabela.<\/li>\n<li>25 bancos de dados com uma \u00fanica tabela de Hist\u00f3rico com apenas um campo em cada tabela. <\/li>\n<\/ol>\n<p><br style=\"font-weight:bold;\"><span style=\"font-weight:bold;\">Solu\u00e7\u00e3o:<\/span><\/p>\n<p>Para isso, as op\u00e7\u00f5es 1 e 2 s\u00e3o as melhores, mas os dados devem ser configurados para que sejam descartados periodicamente, para que n\u00e3o haja risco do limite de tamanho do arquivo de banco de dados ser atingido. Se for necess\u00e1rio, pode-se trocar o banco de dados corrente por outro mais robusto, como o SQL Server ou o Oracle.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Descri\u00e7\u00e3o: Em uma aplica\u00e7\u00e3o, \u00e9 preciso gravar os valores de 25 vari\u00e1veis em um banco de dados Access para serem carregadas por um E3Chart. Quais das op\u00e7\u00f5es abaixo \u00e9 a&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[583],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-27358: Bancos de Dados vs. Tabelas vs. Campos. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-27358: Bancos de Dados vs. Tabelas vs. Campos.\" \/>\n<meta property=\"og:description\" content=\"Descri\u00e7\u00e3o: Em uma aplica\u00e7\u00e3o, \u00e9 preciso gravar os valores de 25 vari\u00e1veis em um banco de dados Access para serem carregadas por um E3Chart. Quais das op\u00e7\u00f5es abaixo \u00e9 a&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:36:24+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-27358: Bancos de Dados vs. Tabelas vs. Campos.\",\"datePublished\":\"2019-03-25T20:36:24+00:00\",\"dateModified\":\"2019-03-25T20:36:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\"},\"wordCount\":155,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\",\"url\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\",\"name\":\"[:pt]KB-27358: Bancos de Dados vs. Tabelas vs. Campos.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:36:24+00:00\",\"dateModified\":\"2019-03-25T20:36:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-27358: Bancos de Dados vs. Tabelas vs. Campos.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-27358: Bancos de Dados vs. Tabelas vs. Campos. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-27358: Bancos de Dados vs. Tabelas vs. Campos.[:] - Elipse Knowledgebase","og_description":"Descri\u00e7\u00e3o: Em uma aplica\u00e7\u00e3o, \u00e9 preciso gravar os valores de 25 vari\u00e1veis em um banco de dados Access para serem carregadas por um E3Chart. Quais das op\u00e7\u00f5es abaixo \u00e9 a&hellip;","og_url":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:36:24+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-27358: Bancos de Dados vs. Tabelas vs. Campos.","datePublished":"2019-03-25T20:36:24+00:00","dateModified":"2019-03-25T20:36:24+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/"},"wordCount":155,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/","url":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/","name":"[:pt]KB-27358: Bancos de Dados vs. Tabelas vs. Campos.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:36:24+00:00","dateModified":"2019-03-25T20:36:24+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/kb27358-bancos-de-dados-vs-tabelas-vs-campos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-27358: Bancos de Dados vs. Tabelas vs. Campos."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1732"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=1732"}],"version-history":[{"count":0,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1732\/revisions"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=1732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=1732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=1732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}