{"id":1271,"date":"2024-02-23T19:35:06","date_gmt":"2024-02-23T19:35:06","guid":{"rendered":"https:\/\/prlalmeida.com.br\/dsbd\/?page_id=1271"},"modified":"2024-11-27T00:56:33","modified_gmt":"2024-11-27T00:56:33","slug":"processamento-de-consultas-de-banco-de-dados-com-aceleracao-de-rede","status":"publish","type":"page","link":"https:\/\/prlalmeida.com.br\/dsbd\/pt\/processamento-de-consultas-de-banco-de-dados-com-aceleracao-de-rede\/","title":{"rendered":"Processamento de consultas de banco de dados com acelera\u00e7\u00e3o de rede"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1271\" class=\"elementor elementor-1271\">\n\t\t\t\t<div class=\"elementor-element elementor-element-658b2dd e-flex e-con-boxed e-con e-parent\" data-id=\"658b2dd\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e7587b5 elementor-widget elementor-widget-heading\" data-id=\"e7587b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Processamento de consultas de banco de dados com acelera\u00e7\u00e3o de rede<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a65652a e-flex e-con-boxed e-con e-parent\" data-id=\"a65652a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c11bcd0 elementor-widget elementor-widget-text-editor\" data-id=\"c11bcd0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>O objetivo deste projeto \u00e9 investigar o co-processamento distribu\u00eddo de consultas entre o sistema de banco de dados e o hardware de rede. No processamento distribu\u00eddo de consultas, o movimento de grandes quantidades de dados pela hierarquia de mem\u00f3ria pode impactar negativamente o desempenho e o consumo de energia do sistema de banco de dados.<\/p><p>Embora o componente de rede normalmente tenha o menor desempenho na hierarquia de mem\u00f3ria, desenvolvimentos recentes de hardware introduziram acesso a dados de baixa lat\u00eancia compar\u00e1vel \u00e0 mem\u00f3ria local. Esses avan\u00e7os tamb\u00e9m tornaram poss\u00edvel programar e executar opera\u00e7\u00f5es complexas de processamento de dados em switches de rede. Por exemplo, programando na linguagem P4.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5f53e13 e-flex e-con-boxed e-con e-parent\" data-id=\"5f53e13\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-388a4c3 elementor-widget elementor-widget-text-editor\" data-id=\"388a4c3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Quando um pacote \u00e9 recebido, o pipeline come\u00e7a parseando o pacote e criando uma m\u00e1quina de estados. Durante o processamento, os metadados e os dados dos pacotes acionam transi\u00e7\u00f5es de estado para determinar o encaminhamento do pacote. A l\u00f3gica de processamento para ingresso e sa\u00edda de pacotes est\u00e1 localizada nos pipelines MAU (Unidades de A\u00e7\u00e3o de Correspond\u00eancia), que consistem em l\u00f3gicas de correspond\u00eancia e a\u00e7\u00e3o. Uma combina\u00e7\u00e3o de MAUs constitui o plano de dados da rede usado para transmitir pacotes de usu\u00e1rio e implementar v\u00e1rios protocolos de rede ou, no contexto do processamento de consultas, opera\u00e7\u00f5es de consulta. O plano de controle \u00e9 um controlador centralizado baseado em software que coordena como os pacotes devem ser processados, possibilitando assim as fun\u00e7\u00f5es no plano de dados. Em termos gerais, um programa P4 define os objetos instalados no plano de dados como a m\u00e1quina de estados, tabelas de roteamento e l\u00f3gicas de correspond\u00eancia-a\u00e7\u00e3o, e o compilador gera a API que o plano de controle usa para se comunicar com o plano de dados.<\/p><p>A Figura abaixo mostra o pipeline de processamento de pacotes P4.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ee41606 e-flex e-con-boxed e-con e-parent\" data-id=\"ee41606\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cf1493f elementor-widget elementor-widget-image\" data-id=\"cf1493f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"351\" src=\"https:\/\/prlalmeida.com.br\/dsbd\/wp-content\/uploads\/2024\/02\/FluxoEduardo-1024x351-1.jpeg\" class=\"attachment-large size-large wp-image-1153\" alt=\"\" srcset=\"https:\/\/prlalmeida.com.br\/dsbd\/wp-content\/uploads\/2024\/02\/FluxoEduardo-1024x351-1.jpeg 1024w, https:\/\/prlalmeida.com.br\/dsbd\/wp-content\/uploads\/2024\/02\/FluxoEduardo-1024x351-1-300x103.jpeg 300w, https:\/\/prlalmeida.com.br\/dsbd\/wp-content\/uploads\/2024\/02\/FluxoEduardo-1024x351-1-768x263.jpeg 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9ae52fd e-flex e-con-boxed e-con e-parent\" data-id=\"9ae52fd\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c416644 elementor-widget elementor-widget-text-editor\" data-id=\"c416644\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>No entanto, as limita\u00e7\u00f5es da linguagem de programa\u00e7\u00e3o P4 para switches levantam quest\u00f5es de pesquisa dif\u00edceis que impulsionam nossa agenda de pesquisa. Entre em contato para aprofundar este t\u00f3pico.<\/p><p>Nosso projeto \u00e9 baseado em resultados que publicamos nas mais prestigiosas confer\u00eancias internacionais na \u00e1rea de banco de dados, como VLDB, ICDE, EDBT, DATE, CIKM e DEXA, bem como workshops de hardware de BD, como: ADMS@VLDB, Damon@SIGMOD, PhD@VLDB e SIGMOD-Research Competition. Os resultados tamb\u00e9m receberam pr\u00eamios de melhor tese de doutorado pela CAPES 2021, tese vice-campe\u00e3 pela SBC 2021 e ACM SIGMOD 2023. Os resultados esperados deste projeto envolvem algoritmos, metodologias e propostas de extens\u00f5es de hardware que podem ser implementadas pela ind\u00fastria de BD e fabricantes de hardware.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-447d031 e-flex e-con-boxed e-con e-parent\" data-id=\"447d031\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c852dbc elementor-widget elementor-widget-heading\" data-id=\"c852dbc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Este projeto \u00e9 apoiado pelo CNPq e pelo projeto SmartEdge.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-536fb7a e-flex e-con-boxed e-con e-parent\" data-id=\"536fb7a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3287b82 elementor-widget elementor-widget-text-editor\" data-id=\"3287b82\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Links CNPq: <a class=\"projects-title\" style=\"text-decoration: none;\" href=\"https:\/\/www.gov.br\/cnpq\/pt-br\">https:\/\/www.gov.br\/cnpq\/pt-br<\/a><\/p>\n\nSmartEdge: <a class=\"projects-title\" style=\"text-decoration: none;\" href=\"https:\/\/www.smart-edge.eu\">https:\/\/www.smart-edge.eu<\/a>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Processamento de consultas de banco de dados com acelera\u00e7\u00e3o de rede O objetivo deste projeto \u00e9 investigar o co-processamento distribu\u00eddo [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","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":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","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-1271","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages\/1271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/comments?post=1271"}],"version-history":[{"count":7,"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages\/1271\/revisions"}],"predecessor-version":[{"id":2088,"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages\/1271\/revisions\/2088"}],"wp:attachment":[{"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/media?parent=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}