Abstract:In database-as-a-service platforms, automated verification of query equivalence helps eliminate redundant computation in the form of overlapping sub-queries. Researchers have proposed two pragmatic techniques to tackle this problem. The first approach consists of reducing the queries to algebraic expressions and proving their equivalence using an algebraic theory. The limitations of this technique are threefold. It cannot prove the equivalence of queries with significant differences in the attributes of their relational operators. It does not support certain widely-used SQL features. Its verification procedure is computationally intensive. The second approach transforms this problem to a constraint satisfaction problem and leverages a general-purpose solver to determine query equivalence. This technique consists of deriving the symbolic representation of the queries and proving their equivalence by determining the query containment relationship between the symbolic expressions. While the latter approach addresses all the limitations of the former technique, it only proves the equivalence of queries under set semantics. However, in practice, database applications use bag semantics. In this paper, we introduce a novel symbolic approach for proving query equivalence under bag semantics. We transform the problem of proving query equivalence under bag semantics to that of proving the existence of a bijective, identity map between tuples returned by the queries on all valid inputs. We implement this symbolic approach in SPES and demonstrate that SPES proves the equivalence of a larger set of query pairs (95/232) under bag semantics compared to the state-of-the-art tools based on algebraic (30/232) and symbolic approaches (67/232) under set and bag semantics, respectively. Furthermore, SPES is 3X faster than the symbolic tool that proves equivalence under set semantics.

L'évaluation Partielle Et Son Application Pour Coupler Prolog Et Les SGBD

Product technical document integration based on SGL

23 European Symposium on Computer Aided Process Engineering: A Parallel Method with Hybrid Algorithms for Mixed Integer Nonlinear Programming

Nested Heuristic and Gradient-Based Method for Generalized Disjunctive Programming

SyPSE: A Symbolic Computation Toolbox for Process Systems Engineering Part II─Design for PSE Applications

Completely Automated Equivalence Proofs

Customisable Handling of Java References in Prolog Programs

Analyse et structuration automatique des guides de bonnes pratiques cliniques : essai d'évaluation

Using Partial Evaluation in Holistic Subgraph Search.

Gestion Dynamique des Services Techniques pour Modele a Composants

Politiques de Tests Partiels \& Systèmes de Sécurité

General comprehensive evaluation system adopting multiple evaluation methods

A partial evaluation approach for the School Bus Routing Problem

Towards Bidirectional Live Programming for Incomplete Programs

Multi-objective optimization algorithms applied to the class integration and test order problem

A Symbolic Approach to Proving Query Equivalence Under Bag Semantics

A Lightweight Data Sharing System Based on Bidirectional Transformations.

Application of a method of processing inconsistency in the judgements of numerous experts

Pairing Functions, Boolean Evaluation and Binary Decision Diagrams in Prolog

S<sub>YNTH</sub>BX: an Example-guided Synthesizer for Bidirectional Programs on Relations