# Generating Plans from Proofs: The Interpolation-based Approach to Query Reformulation

@inproceedings{Benedikt2016GeneratingPF,
title={Generating Plans from Proofs: The Interpolation-based Approach to Query Reformulation},
author={Michael Benedikt and Julien Leblay and Balder ten Cate and Efthymia Tsamoura},
booktitle={Synthesis Lectures on Data Management},
year={2016}
}
• Published in
Synthesis Lectures on Data…
15 March 2016
• Computer Science
Abstract Query reformulation refers to a process of translating a source query—a request for information in some high-level logic-based language—into a target plan that abides by certain interface ...
49 Citations
• Computer Science
• 2021
A compiler and optimizer that compiles relational queries and updates with respect to a given database schema to source code in C with minimal extra-logical annotations is presented.
PIE is a Prolog-embedded environment for automated reasoning on the basis of first-order logic. It includes a versatile formula macro system and supports the creation of documents that intersperse
PIE is a Prolog-embedded environment for automated reasoning on the basis of first-order logic that supports a workflow based on documents that intersperse macro definitions, invocations of reasoners, and LaTeX-formatted natural language text.
• Computer Science
• 2019
Abstract The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website ...
• Computer Science
ESWC
• 2020
It is shown how queries can be rewritten into equivalent execution plans, which are guaranteed to deliver the same results as the query on all databases, and how this method can be used to answer queries on real-world Web services.
• Computer Science
A Comprehensive Guide Through the Italian Database Research
• 2018
This work considers first-order ontology systems playing the role of a conceptual model of a database represented as a classical finite relational store, either with an open world or a closed world reading.
This work shows that one can synthesize transformations from proofs that a formula provides an implicit definition, where the proof is in an intuitionistic calculus that captures a natural style of reasoning about nested collections.
• Computer Science
SOQE@KR
• 2021
This talk elaborates on how logic-based approaches can be used to capture both the high-level conceptual views of information and the low-level physical layout of data and presents the design of a relational query optimizer based on Craig interpolation that allows users to compile both queries and updates to low- level code that operates directly over a physical encoding of the data.
• Computer Science
Proc. ACM Program. Lang.
• 2021
This work shows that one can synthesize transformations from proofs that a formula provides an implicit definition, where the proof is in an intuitionistic calculus that captures a natural style of reasoning about nested collections.
• Computer Science
ArXiv
• 2020
This work shows that NRC has a strong connection with first-order logic: it contains exactly the transformations that are implicitly definable by formulas $\varphi$ in first- order logic with quantification suited for nested collections.

## References

SHOWING 1-10 OF 47 REFERENCES

• Computer Science
PODS
• 2014
This work starts by overviewing a correspondence between proofs and restricted-interface plans in the context of arbitrary first-order constraints, based on interpolation, and provides direct plan-generation algorithms for schemas based on tuple-generating dependencies.
• Computer Science
J. Artif. Intell. Res.
• 2013
A non-trivial application of the framework with ontologies in the very expressive ALCHOIQ description logic is presented, by providing effective means to compute safe-range first-order exact reformulations of queries.
• Computer Science
PODS '95
• 1995
This work shows how to decide with a nondeterministic polynomial-time algorithm whether the given query can be answered and extends the results to allow arithmetic comparisons in the givenquery and in the templates.
• R. Reiter
• Computer Science
On Conceptual Modelling
• 1982
Insofar as database theory can be said to owe a debt to logic, the currency on loan is model theoretic in the sense that a database can be viewed as a particular kind of first order interpretation,
• Computer Science
STOC '77
• 1977
It is shown that while answering conjunctive queries is NP complete (general queries are PSPACE complete), one can find an implementation that is within a constant of optimal.
• Chen Li
• Computer Science
TODS
• 2001
This article proposes a query-planning framework to answer queries in the presence of limited access patterns, and develops algorithms to solve optimization problems in this framework, and thus construct an efficient program to answer a query.
• Computer Science
Proc. VLDB Endow.
• 2014
PDQ (Proof-Driven Query Answering), a system for determining a query plan in the presence of web-based sources, is introduced, taking the novel approach of generating query plans from proofs that a query is answerable.
• Computer Science
Proc. VLDB Endow.
• 2015
This paper presents a system in which classical cost-based join optimization is extended to support both access-restrictions and constraints, and explores a space of proofs that witness the answering of the query, where each proof has a direct correspondence with a query plan.
• Computer Science
SIGMOD '05
• 2005
The architecture and algorithms behind Clio are revisited, some implementation issues, optimizations needed for scalability, and general lessons learned in the road towards creating an industrial-strength tool are discussed.