Datenschutzerklärung|Data Privacy

K. Forster

17.12.2018, 16 Uhr c.t. TU Berlin, EN building, seminar room EN 719 (7th floor), Einsteinufer 17, 10587 Berlin: "The Case for Network-Accelerated Query Processing" (Dr. Alberto Lerner, eXascale Infolab at the University of Fribourg, Switzerland)

The fastest plans in MPP databases are usually those with the least amount of data movement across nodes. That's because data does not get processed while in transit. The network switches that connect MPP nodes are hard-wired to strictly perform packet-forwarding logic. In a recent paradigm shift, however, network devices are becoming “programmable.” The quotes here are cautionary. Switches had not become general purpose computers suddenly. But now the set of tasks they can perform can be encoded in software -- and that means such switch can be instructed to manipulate the data it is forwarding.

In this talk we explore this programmability to accelerate OLAP queries. We found that we can offload onto the switch some very common and expensive query patterns. Moving data through networking equipment can hence for the first time contribute to query execution. Our preliminary results show that we can improve response times on even the best agreed upon plans by more than 2x using 25 Gbps networks. We also see the promise of linear performance improvement with faster speeds. The use of programmable switches can open new possibilities of architecting rack- and datacenter-sized database systems, with implications across the stack.