Evaluation d'une requete en SQL

TL;DR

This paper examines how an SQL query processing system translates and executes queries, detailing the roles of the compiler and evaluation components in the process.

Contribution

It provides an analysis of the SQL query processing pipeline, highlighting the separation between compilation and execution phases.

Findings

The interrogation processor is divided into compilation and evaluation stages.

The compiler translates SQL into an execution plan.

The evaluation component executes the plan to retrieve results.

Abstract

The objective of this paper is to show how the interrogation processor responds to SQL interrogation. The interrogation processor is split into two parts. The first, called the interrogation compiler translates an SQL query into a plan of physical execution. The second, called evaluation query runs the execution plan.