FLOC 2018: FEDERATED LOGIC CONFERENCE 2018
A Coq formalisation of SQL’s execution engines

Authors: Véronique Benzaken, Evelyne Contejean, Chantal Keller and Eunice Martins

Paper Information

Title:A Coq formalisation of SQL’s execution engines
Authors:Véronique Benzaken, Evelyne Contejean, Chantal Keller and Eunice Martins
Proceedings:ITP Papers
Editors: Jeremy Avigad and Assia Mahboubi
Keywords:Coq, Databases, SQL, Certified execution engine
Abstract:

ABSTRACT. In this article, we use the Coq proof assistant to specify and verify the low level layer of SQL’s execution engines. To reach our goals, we first design a high level Coq specification for data and data-centric operators intended to capture their essence. We, then, provide two Coq implementations of our specification. The first one, the physical algebra, consists in the low level operators found in systems such as Postgresql or Oracle. The second, SQL algebra, is an extended relational algebra that provides a semantics for SQL. Last, we formally relate physical algebra and SQL algebra. By proving that the physical algebra implements SQL algebra, we give high level assurances that physical algebraic and SQL algebra expressions enjoy the same semantics. All this yields the first, to our best knowledge, formalisation in Coq of the low level primitives that constitute the main part of SQL execution engines.

Pages:19
Talk:Jul 10 15:00 (Session 55C)
Paper: