PackageBuilder

From tuples to packages

Matteo Brucato, Rahul Ramakrishna, Azza Abouzied, Alexandra Meliou

Research output: Contribution to journalArticle

Abstract

In this demo, we present PACKAGEBUILDER, a system that extends database systems to support package queries. A package is a collection of tuples that individually satisfy base constraints and collectively satisfy global constraints. The need for package support arises in a variety of scenarios: For example, in the creation of meal plans, users are not only interested in the nutritional content of individual meals (base constraints), but also care to specify daily consumption limits and control the balance of the entire plan (global constraints). We introduce PaQL, a declarative SQL-based package query language, and the interface abstractions which allow users to interactively specify package queries and easily navigate through their results. To efficiently evaluate queries, the system employs pruning and heuristics, as well as state-of-the-art constraint optimization solvers. We demonstrate PACKAGEBUILDER by allowing attendees to interact with the system's interface, to define PaQL queries and to observe how query evaluation is performed.

Original languageEnglish (US)
Pages (from-to)1593-1596
Number of pages4
JournalProceedings of the VLDB Endowment
Volume7
Issue number13
DOIs
StatePublished - Jan 1 2014

Fingerprint

Query languages

ASJC Scopus subject areas

  • Computer Science (miscellaneous)
  • Computer Science(all)

Cite this

PackageBuilder : From tuples to packages. / Brucato, Matteo; Ramakrishna, Rahul; Abouzied, Azza; Meliou, Alexandra.

In: Proceedings of the VLDB Endowment, Vol. 7, No. 13, 01.01.2014, p. 1593-1596.

Research output: Contribution to journalArticle

Brucato, Matteo ; Ramakrishna, Rahul ; Abouzied, Azza ; Meliou, Alexandra. / PackageBuilder : From tuples to packages. In: Proceedings of the VLDB Endowment. 2014 ; Vol. 7, No. 13. pp. 1593-1596.
@article{967d751deb6c4878af8bdde2ac9bfe3c,
title = "PackageBuilder: From tuples to packages",
abstract = "In this demo, we present PACKAGEBUILDER, a system that extends database systems to support package queries. A package is a collection of tuples that individually satisfy base constraints and collectively satisfy global constraints. The need for package support arises in a variety of scenarios: For example, in the creation of meal plans, users are not only interested in the nutritional content of individual meals (base constraints), but also care to specify daily consumption limits and control the balance of the entire plan (global constraints). We introduce PaQL, a declarative SQL-based package query language, and the interface abstractions which allow users to interactively specify package queries and easily navigate through their results. To efficiently evaluate queries, the system employs pruning and heuristics, as well as state-of-the-art constraint optimization solvers. We demonstrate PACKAGEBUILDER by allowing attendees to interact with the system's interface, to define PaQL queries and to observe how query evaluation is performed.",
author = "Matteo Brucato and Rahul Ramakrishna and Azza Abouzied and Alexandra Meliou",
year = "2014",
month = "1",
day = "1",
doi = "10.14778/2733004.2733038",
language = "English (US)",
volume = "7",
pages = "1593--1596",
journal = "Proceedings of the VLDB Endowment",
issn = "2150-8097",
publisher = "Very Large Data Base Endowment Inc.",
number = "13",

}

TY - JOUR

T1 - PackageBuilder

T2 - From tuples to packages

AU - Brucato, Matteo

AU - Ramakrishna, Rahul

AU - Abouzied, Azza

AU - Meliou, Alexandra

PY - 2014/1/1

Y1 - 2014/1/1

N2 - In this demo, we present PACKAGEBUILDER, a system that extends database systems to support package queries. A package is a collection of tuples that individually satisfy base constraints and collectively satisfy global constraints. The need for package support arises in a variety of scenarios: For example, in the creation of meal plans, users are not only interested in the nutritional content of individual meals (base constraints), but also care to specify daily consumption limits and control the balance of the entire plan (global constraints). We introduce PaQL, a declarative SQL-based package query language, and the interface abstractions which allow users to interactively specify package queries and easily navigate through their results. To efficiently evaluate queries, the system employs pruning and heuristics, as well as state-of-the-art constraint optimization solvers. We demonstrate PACKAGEBUILDER by allowing attendees to interact with the system's interface, to define PaQL queries and to observe how query evaluation is performed.

AB - In this demo, we present PACKAGEBUILDER, a system that extends database systems to support package queries. A package is a collection of tuples that individually satisfy base constraints and collectively satisfy global constraints. The need for package support arises in a variety of scenarios: For example, in the creation of meal plans, users are not only interested in the nutritional content of individual meals (base constraints), but also care to specify daily consumption limits and control the balance of the entire plan (global constraints). We introduce PaQL, a declarative SQL-based package query language, and the interface abstractions which allow users to interactively specify package queries and easily navigate through their results. To efficiently evaluate queries, the system employs pruning and heuristics, as well as state-of-the-art constraint optimization solvers. We demonstrate PACKAGEBUILDER by allowing attendees to interact with the system's interface, to define PaQL queries and to observe how query evaluation is performed.

UR - http://www.scopus.com/inward/record.url?scp=84905851510&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84905851510&partnerID=8YFLogxK

U2 - 10.14778/2733004.2733038

DO - 10.14778/2733004.2733038

M3 - Article

VL - 7

SP - 1593

EP - 1596

JO - Proceedings of the VLDB Endowment

JF - Proceedings of the VLDB Endowment

SN - 2150-8097

IS - 13

ER -