{"id":1151,"date":"2024-02-22T20:08:24","date_gmt":"2024-02-22T20:08:24","guid":{"rendered":"https:\/\/prlalmeida.com.br\/dsbd\/?page_id=1151"},"modified":"2024-11-27T00:49:12","modified_gmt":"2024-11-27T00:49:12","slug":"database-query-processing-with-network-acceleration","status":"publish","type":"page","link":"https:\/\/prlalmeida.com.br\/dsbd\/database-query-processing-with-network-acceleration\/","title":{"rendered":"Database query processing with network acceleration"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1151\" class=\"elementor elementor-1151\">\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\">Database query processing with network acceleration<\/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><span style=\"font-weight: 400;\">The goal of this project is to investigate distributed query co-processing between the database system and the network hardware. In distributed query processing, the movement of large amounts of data through the memory hierarchy can negatively impact the performance and energy consumption of the database system.<\/span><\/p><p><span style=\"font-weight: 400;\">While the network component typically has the lowest performance in the memory hierarchy, recent hardware developments have introduced low-latency data access comparable to local <\/span><span style=\"font-weight: 400;\">memory. These advances have also made it possible to program and run complex data processing operations on network switches. For example, programing in P4 language.<\/span><\/p><p>\u00a0<\/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><span style=\"font-weight: 400;\">When a packet is received, the pipeline begins by parsing the packet and creating a state machine. During processing, the metadata and data of the packets trigger state transitions to determine the packet forwarding. The processing logic for packet ingress and egress is located in the MAU pipelines which consist of match and action logics. A combination of MAUs constitutes the network data plane used to transmit user packets and implement various network protocols or, in the context of query processing, query operations. The control plane is a software-based centralized controller that coordinates how the packets should be processed hence enabling the functions in the data plane. Generally speaking, a P4 program defines the objects installed in the data plane like the state machine, routing tables and match-action logics, and the compiler generates the API that the control plane uses to communicate with the data plane.<\/span><\/p><p><span style=\"font-weight: 400;\">The Figure below shows the P4 packet processing pipeline.<\/span><\/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><span style=\"font-weight: 400;\">However, the limitations of the P4 switch programming language poses difficult research questions that drive our research agenda. Reach out to delve deeper into this topic.<\/span><\/p><p><span style=\"font-weight: 400;\">Our project is based on results that we published in the most prestigious international conferences in the database area, such as VLDB, ICDE, EDBT, DATE, CIKM and DEXA, as well as DB hardware workshops, such as: ADMS@ VLDB, Damon@SIGMOD, PhD@VLDB and SIGMOD-Research Competition. The results also received awards for best doctoral thesis by CAPES 2021, runner up thesis by SBC 2021 and ACM SIGMOD 2023. The expected results of this project involve algorithms, methodologies and proposals for hardware extensions that can be implemented by the DBMS industry and hardware manufacturers<\/span><\/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\">This project is supported  by CNPq and the SmartEdge project.<\/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>Database query processing with network acceleration The goal of this project is to investigate distributed query co-processing between the database [&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-1151","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages\/1151","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=1151"}],"version-history":[{"count":19,"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages\/1151\/revisions"}],"predecessor-version":[{"id":2067,"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/pages\/1151\/revisions\/2067"}],"wp:attachment":[{"href":"https:\/\/prlalmeida.com.br\/dsbd\/wp-json\/wp\/v2\/media?parent=1151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}