{"id":"https://openalex.org/W2295864763","doi":"https://doi.org/10.14778/2904483.2904489","title":"Scalable package queries in relational database systems","display_name":"Scalable package queries in relational database systems","publication_year":2016,"publication_date":"2016-03-01","ids":{"openalex":"https://openalex.org/W2295864763","doi":"https://doi.org/10.14778/2904483.2904489","mag":"2295864763"},"language":"en","primary_location":{"id":"doi:10.14778/2904483.2904489","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2904483.2904489","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5072749095","display_name":"Matteo Brucato","orcid":"https://orcid.org/0000-0003-2730-6432"},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Matteo Brucato","raw_affiliation_strings":["University of Massachusetts, Amherst, MA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts, Amherst, MA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091024220","display_name":"Juan Felipe Beltr\u00e1n","orcid":"https://orcid.org/0000-0002-2054-8079"},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Juan Felipe Beltran","raw_affiliation_strings":["New York University, Abu Dhabi, UAE"],"affiliations":[{"raw_affiliation_string":"New York University, Abu Dhabi, UAE","institution_ids":["https://openalex.org/I57206974"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044418740","display_name":"Azza Abouzied","orcid":"https://orcid.org/0000-0003-4273-2536"},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Azza Abouzied","raw_affiliation_strings":["New York University, Abu Dhabi, UAE"],"affiliations":[{"raw_affiliation_string":"New York University, Abu Dhabi, UAE","institution_ids":["https://openalex.org/I57206974"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019048013","display_name":"Alexandra Meliou","orcid":"https://orcid.org/0000-0001-7346-6002"},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexandra Meliou","raw_affiliation_strings":["University of Massachusetts, Amherst, MA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts, Amherst, MA","institution_ids":["https://openalex.org/I24603500"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5072749095"],"corresponding_institution_ids":["https://openalex.org/I24603500"],"apc_list":null,"apc_paid":null,"fwci":3.5305,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.93461951,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"9","issue":"7","first_page":"576","last_page":"587"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9919999837875366,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8416186571121216},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7139747142791748},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6567999720573425},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6023295521736145},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.565069317817688},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5519853234291077},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.49924564361572266},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.457955002784729},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.45509880781173706},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.4301576316356659},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.41525381803512573},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34170475602149963},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3250845670700073},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2626892328262329},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.22466883063316345},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.20305845141410828},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.15048179030418396}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8416186571121216},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7139747142791748},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6567999720573425},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6023295521736145},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.565069317817688},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5519853234291077},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.49924564361572266},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.457955002784729},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.45509880781173706},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4301576316356659},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.41525381803512573},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34170475602149963},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3250845670700073},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2626892328262329},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.22466883063316345},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.20305845141410828},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.15048179030418396},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2904483.2904489","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2904483.2904489","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W1544515183","https://openalex.org/W1596887828","https://openalex.org/W1673310716","https://openalex.org/W1899379166","https://openalex.org/W1977556410","https://openalex.org/W2005653178","https://openalex.org/W2008196645","https://openalex.org/W2008255868","https://openalex.org/W2009088535","https://openalex.org/W2020494112","https://openalex.org/W2029242918","https://openalex.org/W2048864522","https://openalex.org/W2061194905","https://openalex.org/W2091611534","https://openalex.org/W2101234009","https://openalex.org/W2123102196","https://openalex.org/W2145604831","https://openalex.org/W2150461219","https://openalex.org/W2150592063","https://openalex.org/W2165558283","https://openalex.org/W2170735271","https://openalex.org/W2250335649","https://openalex.org/W2295864763","https://openalex.org/W2338861484","https://openalex.org/W2406784934","https://openalex.org/W2950753773","https://openalex.org/W2997591727","https://openalex.org/W2999729612","https://openalex.org/W3099250505","https://openalex.org/W4298882835","https://openalex.org/W6644682428","https://openalex.org/W6703765554"],"related_works":["https://openalex.org/W2889903446","https://openalex.org/W2554271401","https://openalex.org/W3125756434","https://openalex.org/W2186703450","https://openalex.org/W4381740310","https://openalex.org/W2413368787","https://openalex.org/W1528266144","https://openalex.org/W4242370757","https://openalex.org/W2587993932","https://openalex.org/W3047138557"],"abstract_inverted_index":{"Traditional":[0],"database":[1,25,69,93],"queries":[2,60,70,134],"follow":[3],"a":[4,42,62,82,91,104,142,168,175,208],"simple":[5],"model:":[6],"they":[7],"define":[8],"constraints":[9,49,74],"that":[10,66,108,118,146,173,237,253],"each":[11,33],"tuple":[12,34],"in":[13,136],"the":[14,24,29,110,148],"result":[15,45],"must":[16],"satisfy.":[17],"This":[18],"model":[19,65],"is":[20,120,135,167,242,254],"computationally":[21],"efficient,":[22],"as":[23,123,125],"system":[26],"can":[27],"evaluate":[28],"query":[30,64,85,106,177,192],"conditions":[31],"on":[32,88],"individually.":[35,53],"However,":[36],"many":[37],"practical,":[38],"real-world":[39,230],"problems":[40],"require":[41],"collection":[43],"of":[44,90,113,132,150,164,170,257],"tuples":[46],"to":[47,71,156,159,178,194,196],"satisfy":[48],"collectively,":[50],"rather":[51],"than":[52,260],"In":[54],"this":[55],"paper,":[56],"we":[57,101,140,184,201,225],"present":[58,141,226],"package":[59,84,114,133,160,176,212,247],",":[61,207],"new":[63],"extends":[67],"traditional":[68,92],"handle":[72],"complex":[73],"and":[75,129,152,231,249],"preferences":[76],"over":[77,229,265],"answer":[78],"sets.":[79],"We":[80,116],"develop":[81],"full-fledged":[83],"system,":[86],"implemented":[87],"top":[89],"engine.":[94],"Our":[95],"work":[96],"makes":[97],"several":[98],"contributions.":[99],"First,":[100],"design":[102],"PaQL,":[103],"SQL-based":[105],"language":[107],"supports":[109],"declarative":[111],"specification":[112],"queries.":[115,161],"prove":[117],"PaQL":[119],"at":[121,244],"least":[122],"expressive":[124],"integer":[126,180],"linear":[127,181],"programming,":[128],"therefore,":[130],"evaluation":[131,144,193],"general":[137],"NP-hard.":[138],"Second,":[139],"fundamental":[143],"strategy":[145,190],"combines":[147],"capabilities":[149],"databases":[151],"constraint":[153],"optimization":[154],"solvers":[155,264],"derive":[157],"solutions":[158],"The":[162,234],"core":[163],"our":[165],"approach":[166],"set":[169],"translation":[171],"rules":[172],"transform":[174],"an":[179,186,255],"program.":[182],"Third,":[183],"introduce":[185,202],"offline":[187],"data":[188,198],"partitioning":[189],"allowing":[191],"scale":[195],"large":[197,266],"sizes.":[199],"Fourth,":[200],"S":[203,238],"ketch":[204,239],"R":[205,240],"efine":[206,241],"scalable":[209],"algorithm":[210],"for":[211],"evaluation,":[213],"with":[214],"strong":[215],"approximation":[216],"guarantees":[217],"((1":[218],"\u00b1":[219],"\u03b5)":[220],"6":[221],"-factor":[222],"approximation).":[223],"Finally,":[224],"extensive":[227],"experiments":[228],"benchmark":[232],"data.":[233],"results":[235],"demonstrate":[236],"effective":[243],"deriving":[245],"high-quality":[246],"results,":[248],"achieves":[250],"runtime":[251],"performance":[252],"order":[256],"magnitude":[258],"faster":[259],"directly":[261],"using":[262],"ILP":[263],"datasets.":[267]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}