Lecture

Vectorization: Optimizing Query Processing in Database Systems

In course

Fugiat qui in ea voluptate eu ex aliquip ea. Occaecat officia commodo ut ullamco incididunt irure ea nisi nisi in aliquip. Sunt sunt laboris sit reprehenderit sunt nisi. Consequat id adipisicing esse esse cupidatat eiusmod cillum commodo est. Excepteur excepteur reprehenderit sint irure eu est eu. Ea mollit occaecat irure anim ipsum dolor veniam consequat non est ipsum sunt elit.

Description

This lecture explores the concept of vectorization in query processing within database systems, comparing tuple-at-a-time and column-at-a-time execution models. It delves into the vectorization model, which emits a vector of tuples per operator, optimizing performance by processing multiple tuples at a time. The instructor presents the advantages of vectorization for OLAP queries, highlighting the reduction in operator invocations and the utilization of vectorized instructions for batch processing.

Instructor

tempor ad

Cillum qui ad Lorem Lorem tempor cupidatat in occaecat exercitation nulla pariatur fugiat. Excepteur nulla aliqua reprehenderit amet reprehenderit ullamco velit. Commodo proident laboris incididunt commodo minim ad fugiat est laborum occaecat anim. Eiusmod ipsum duis aute ea incididunt dolore est dolor sunt voluptate esse. Do consectetur aute excepteur consectetur sint consequat nostrud anim.

Official source

https://mediaspace.epfl.ch/media/0_79hcj9h1

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Ontological neighbourhood

Computer engineering

Databases: Relational databases

Related lectures (36)

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.