Enregistré dans:
Détails bibliographiques
Auteurs principaux: Capelli, Florent, Crosetti, Nicolas, Niehren, Joachim, Ramon, Jan
Format: Preprint
Publié: 2022
Sujets:
Accès en ligne:https://arxiv.org/abs/2210.16694
Tags: Ajouter un tag
Pas de tags, Soyez le premier à ajouter un tag!
_version_ 1866909280063455232
author Capelli, Florent
Crosetti, Nicolas
Niehren, Joachim
Ramon, Jan
author_facet Capelli, Florent
Crosetti, Nicolas
Niehren, Joachim
Ramon, Jan
contents In this paper, we study the problem of optimizing a linear program whose variables are the answers to a conjunctive query. For this we propose the language LP(CQ) for specifying linear programs whose constraints and objective functions depend on the answer sets of conjunctive queries. We contribute an efficient algorithm for solving programs in a fragment of LP(CQ). The natural approach constructs a linear program having as many variables as there are elements in the answer set of the queries. Our approach constructs a linear program having the same optimal value but fewer variables. This is done by exploiting the structure of the conjunctive queries using generalized hypertree decompositions of small width to factorize elements of the answer set together. We illustrate the various applications of LP(CQ) programs on three examples: optimizing deliveries of resources, minimizing noise for differential privacy, and computing the s-measure of patterns in graphs as needed for data mining.
format Preprint
id arxiv_https___arxiv_org_abs_2210_16694
institution arXiv
publishDate 2022
record_format arxiv
spellingShingle Linear Programs with Conjunctive Database Queries
Capelli, Florent
Crosetti, Nicolas
Niehren, Joachim
Ramon, Jan
Databases
In this paper, we study the problem of optimizing a linear program whose variables are the answers to a conjunctive query. For this we propose the language LP(CQ) for specifying linear programs whose constraints and objective functions depend on the answer sets of conjunctive queries. We contribute an efficient algorithm for solving programs in a fragment of LP(CQ). The natural approach constructs a linear program having as many variables as there are elements in the answer set of the queries. Our approach constructs a linear program having the same optimal value but fewer variables. This is done by exploiting the structure of the conjunctive queries using generalized hypertree decompositions of small width to factorize elements of the answer set together. We illustrate the various applications of LP(CQ) programs on three examples: optimizing deliveries of resources, minimizing noise for differential privacy, and computing the s-measure of patterns in graphs as needed for data mining.
title Linear Programs with Conjunctive Database Queries
topic Databases
url https://arxiv.org/abs/2210.16694