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: |