PackageBuilder: Querying for packages of tuples

Kevin Fernandes, Matteo Brucato, Rahul Ramakrishna, Azza Abouzied, Alexandra Meliou

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

PackageBuilder is a system that extends query engines to support package generation. A package is a collection of tuples with certain global properties defined on the collection as a whole. In contrast to traditional query answers where each answer tuple needs to satisfy the query predicates, each answer package needs to satisfy global constraints on the collection of tuples: e.g., a package of recipes that collectively do not exceed 2,200 calories. PackageBuilder introduces simple extensions to the SQL language to support package-level predicates, and includes a simple interface that allows users to load datasets and interactively specify package queries. Our system allows users to interactively navigate through the result packages, and to provide feedback by fixing tuples within a package. PackageBuilder automatically processes this feedback to refine the package queries, and generate new sets of results.

Original languageEnglish (US)
Title of host publicationSIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data
PublisherAssociation for Computing Machinery
Pages1613-1614
Number of pages2
ISBN (Print)9781450323765
DOIs
StatePublished - Jan 1 2014
Event2014 ACM SIGMOD International Conference on Management of Data, SIGMOD 2014 - Snowbird, UT, United States
Duration: Jun 22 2014Jun 27 2014

Other

Other2014 ACM SIGMOD International Conference on Management of Data, SIGMOD 2014
CountryUnited States
CitySnowbird, UT
Period6/22/146/27/14

Fingerprint

Feedback
Engines

Keywords

  • Constraint optimization
  • Package queries
  • PackageBuilder

ASJC Scopus subject areas

  • Software
  • Information Systems

Cite this

Fernandes, K., Brucato, M., Ramakrishna, R., Abouzied, A., & Meliou, A. (2014). PackageBuilder: Querying for packages of tuples. In SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data (pp. 1613-1614). Association for Computing Machinery. https://doi.org/10.1145/2588555.2612667

PackageBuilder : Querying for packages of tuples. / Fernandes, Kevin; Brucato, Matteo; Ramakrishna, Rahul; Abouzied, Azza; Meliou, Alexandra.

SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data. Association for Computing Machinery, 2014. p. 1613-1614.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Fernandes, K, Brucato, M, Ramakrishna, R, Abouzied, A & Meliou, A 2014, PackageBuilder: Querying for packages of tuples. in SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data. Association for Computing Machinery, pp. 1613-1614, 2014 ACM SIGMOD International Conference on Management of Data, SIGMOD 2014, Snowbird, UT, United States, 6/22/14. https://doi.org/10.1145/2588555.2612667
Fernandes K, Brucato M, Ramakrishna R, Abouzied A, Meliou A. PackageBuilder: Querying for packages of tuples. In SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data. Association for Computing Machinery. 2014. p. 1613-1614 https://doi.org/10.1145/2588555.2612667
Fernandes, Kevin ; Brucato, Matteo ; Ramakrishna, Rahul ; Abouzied, Azza ; Meliou, Alexandra. / PackageBuilder : Querying for packages of tuples. SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data. Association for Computing Machinery, 2014. pp. 1613-1614
@inproceedings{b80b543a2cb94a3d8f15fcf8265a0318,
title = "PackageBuilder: Querying for packages of tuples",
abstract = "PackageBuilder is a system that extends query engines to support package generation. A package is a collection of tuples with certain global properties defined on the collection as a whole. In contrast to traditional query answers where each answer tuple needs to satisfy the query predicates, each answer package needs to satisfy global constraints on the collection of tuples: e.g., a package of recipes that collectively do not exceed 2,200 calories. PackageBuilder introduces simple extensions to the SQL language to support package-level predicates, and includes a simple interface that allows users to load datasets and interactively specify package queries. Our system allows users to interactively navigate through the result packages, and to provide feedback by fixing tuples within a package. PackageBuilder automatically processes this feedback to refine the package queries, and generate new sets of results.",
keywords = "Constraint optimization, Package queries, PackageBuilder",
author = "Kevin Fernandes and Matteo Brucato and Rahul Ramakrishna and Azza Abouzied and Alexandra Meliou",
year = "2014",
month = "1",
day = "1",
doi = "10.1145/2588555.2612667",
language = "English (US)",
isbn = "9781450323765",
pages = "1613--1614",
booktitle = "SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data",
publisher = "Association for Computing Machinery",

}

TY - GEN

T1 - PackageBuilder

T2 - Querying for packages of tuples

AU - Fernandes, Kevin

AU - Brucato, Matteo

AU - Ramakrishna, Rahul

AU - Abouzied, Azza

AU - Meliou, Alexandra

PY - 2014/1/1

Y1 - 2014/1/1

N2 - PackageBuilder is a system that extends query engines to support package generation. A package is a collection of tuples with certain global properties defined on the collection as a whole. In contrast to traditional query answers where each answer tuple needs to satisfy the query predicates, each answer package needs to satisfy global constraints on the collection of tuples: e.g., a package of recipes that collectively do not exceed 2,200 calories. PackageBuilder introduces simple extensions to the SQL language to support package-level predicates, and includes a simple interface that allows users to load datasets and interactively specify package queries. Our system allows users to interactively navigate through the result packages, and to provide feedback by fixing tuples within a package. PackageBuilder automatically processes this feedback to refine the package queries, and generate new sets of results.

AB - PackageBuilder is a system that extends query engines to support package generation. A package is a collection of tuples with certain global properties defined on the collection as a whole. In contrast to traditional query answers where each answer tuple needs to satisfy the query predicates, each answer package needs to satisfy global constraints on the collection of tuples: e.g., a package of recipes that collectively do not exceed 2,200 calories. PackageBuilder introduces simple extensions to the SQL language to support package-level predicates, and includes a simple interface that allows users to load datasets and interactively specify package queries. Our system allows users to interactively navigate through the result packages, and to provide feedback by fixing tuples within a package. PackageBuilder automatically processes this feedback to refine the package queries, and generate new sets of results.

KW - Constraint optimization

KW - Package queries

KW - PackageBuilder

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

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

U2 - 10.1145/2588555.2612667

DO - 10.1145/2588555.2612667

M3 - Conference contribution

AN - SCOPUS:84904301225

SN - 9781450323765

SP - 1613

EP - 1614

BT - SIGMOD 2014 - Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

PB - Association for Computing Machinery

ER -