{"id":"https://openalex.org/W2753109262","doi":"https://doi.org/10.14778/3137628.3137648","title":"Reverse engineering aggregation queries","display_name":"Reverse engineering aggregation queries","publication_year":2017,"publication_date":"2017-08-01","ids":{"openalex":"https://openalex.org/W2753109262","doi":"https://doi.org/10.14778/3137628.3137648","mag":"2753109262"},"language":"en","primary_location":{"id":"doi:10.14778/3137628.3137648","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3137628.3137648","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/A5026021699","display_name":"Wei Chit Tan","orcid":"https://orcid.org/0009-0002-0078-547X"},"institutions":[{"id":"https://openalex.org/I152815399","display_name":"Singapore University of Technology and Design","ror":"https://ror.org/05j6fvn87","country_code":"SG","type":"education","lineage":["https://openalex.org/I152815399"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Wei Chit Tan","raw_affiliation_strings":["Singapore University of Technology and Design"],"affiliations":[{"raw_affiliation_string":"Singapore University of Technology and Design","institution_ids":["https://openalex.org/I152815399"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032263010","display_name":"Meihui Zhang","orcid":"https://orcid.org/0000-0002-0752-9877"},"institutions":[{"id":"https://openalex.org/I152815399","display_name":"Singapore University of Technology and Design","ror":"https://ror.org/05j6fvn87","country_code":"SG","type":"education","lineage":["https://openalex.org/I152815399"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Meihui Zhang","raw_affiliation_strings":["Singapore University of Technology and Design"],"affiliations":[{"raw_affiliation_string":"Singapore University of Technology and Design","institution_ids":["https://openalex.org/I152815399"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074464488","display_name":"Hazem Elmeleegy","orcid":null},"institutions":[{"id":"https://openalex.org/I4210162105","display_name":"Re-Turn (Norway)","ror":"https://ror.org/05f655c20","country_code":"NO","type":"company","lineage":["https://openalex.org/I4210162105"]}],"countries":["NO"],"is_corresponding":false,"raw_author_name":"Hazem Elmeleegy","raw_affiliation_strings":["Turn Inc"],"affiliations":[{"raw_affiliation_string":"Turn Inc","institution_ids":["https://openalex.org/I4210162105"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088315797","display_name":"Divesh Srivastava","orcid":"https://orcid.org/0000-0002-7609-9217"},"institutions":[{"id":"https://openalex.org/I1283103587","display_name":"AT&T (United States)","ror":"https://ror.org/02bbd5539","country_code":"US","type":"company","lineage":["https://openalex.org/I1283103587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Divesh Srivastava","raw_affiliation_strings":["AT&T Labs-Research"],"affiliations":[{"raw_affiliation_string":"AT&T Labs-Research","institution_ids":["https://openalex.org/I1283103587"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5026021699"],"corresponding_institution_ids":["https://openalex.org/I152815399"],"apc_list":null,"apc_paid":null,"fwci":2.6936,"has_fulltext":false,"cited_by_count":31,"citation_normalized_percentile":{"value":0.91595878,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"10","issue":"11","first_page":"1394","last_page":"1405"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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/T11106","display_name":"Data Management and Algorithms","score":0.9983999729156494,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9922999739646912,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.7805110812187195},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5711687207221985},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.565209686756134},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5592686533927917},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5513321757316589},{"id":"https://openalex.org/keywords/result-set","display_name":"Result set","score":0.5091373324394226},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.49489206075668335},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4889148771762848},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4844632148742676},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.46901363134384155},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4592963755130768},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4348413944244385},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4313867390155792},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4198416769504547},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.36555999517440796},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3532105088233948},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3123968839645386},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.24713969230651855},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1820192039012909},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.11452701687812805}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7805110812187195},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5711687207221985},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.565209686756134},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5592686533927917},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5513321757316589},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.5091373324394226},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.49489206075668335},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4889148771762848},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4844632148742676},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.46901363134384155},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4592963755130768},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4348413944244385},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4313867390155792},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4198416769504547},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.36555999517440796},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3532105088233948},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3123968839645386},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.24713969230651855},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1820192039012909},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.11452701687812805},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3137628.3137648","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3137628.3137648","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W760598031","https://openalex.org/W1911540707","https://openalex.org/W1971684273","https://openalex.org/W2013167115","https://openalex.org/W2023878327","https://openalex.org/W2024958874","https://openalex.org/W2057513751","https://openalex.org/W2077207253","https://openalex.org/W2094806969","https://openalex.org/W2096454106","https://openalex.org/W2098388305","https://openalex.org/W2099239777","https://openalex.org/W2213810917","https://openalex.org/W2275996142","https://openalex.org/W2398191069","https://openalex.org/W2430277509","https://openalex.org/W6688618120"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W2554271401","https://openalex.org/W2096359267","https://openalex.org/W1977383094","https://openalex.org/W906795786","https://openalex.org/W2394631576","https://openalex.org/W4381740310","https://openalex.org/W2186703450","https://openalex.org/W2469357693","https://openalex.org/W2395498354"],"abstract_inverted_index":{"Query":[0],"reverse":[1],"engineering":[2],"seeks":[3],"to":[4,88,126,143],"re-generate":[5],"the":[6,61,76,83,86,101,119,128,140,145],"SQL":[7],"query":[8,13,103,130],"that":[9,72,97,123],"produced":[10],"a":[11,17,36,49,55,67,109,113],"given":[12,18,102],"output":[14,104,131],"table":[15,121],"from":[16,75],"database.":[19],"In":[20],"this":[21,25,44],"paper,":[22],"we":[23,53,65,107],"solve":[24],"problem":[26],"for":[27,43,60],"OLAP":[28],"queries":[29],"with":[30,100],"group-by":[31,58,93],"and":[32,85,95,147],"aggregation.":[33],"We":[34,133],"develop":[35],"novel":[37],"three-phase":[38],"algorithm":[39],"named":[40],"REGAL":[41],"1":[42],"problem.":[45],"First,":[46],"based":[47],"on":[48],"lattice":[50],"graph":[51],"structure,":[52],"identify":[54],"set":[56,68],"of":[57,69,78,92,115,149],"candidates":[59],"desired":[62],"query.":[63],"Second,":[64],"apply":[66],"aggregation":[70],"constraints":[71],"are":[73,98],"derived":[74],"properties":[77],"aggregate":[79],"operators":[80],"at":[81],"both":[82],"table-level":[84],"group-level":[87],"discover":[89],"candidate":[90],"combinations":[91],"columns":[94],"aggregations":[96],"consistent":[99],"table.":[105,132],"Finally,":[106],"find":[108],"multi-dimensional":[110],"filter,":[111],"i.e.,":[112],"conjunction":[114],"selection":[116],"predicates":[117],"over":[118,139],"base":[120],"attributes,":[122],"is":[124],"needed":[125],"generate":[127],"exact":[129],"conduct":[134],"an":[135],"extensive":[136],"experimental":[137],"study":[138],"TPC-H":[141],"dataset":[142],"demonstrate":[144],"effectiveness":[146],"efficiency":[148],"our":[150],"proposal.":[151]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":9},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}