{"id":"https://openalex.org/W2099239777","doi":"https://doi.org/10.1145/2463676.2465320","title":"Reverse engineering complex join queries","display_name":"Reverse engineering complex join queries","publication_year":2013,"publication_date":"2013-06-22","ids":{"openalex":"https://openalex.org/W2099239777","doi":"https://doi.org/10.1145/2463676.2465320","mag":"2099239777"},"language":"en","primary_location":{"id":"doi:10.1145/2463676.2465320","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2465320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-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/A5086550982","display_name":"Meihui Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Meihui Zhang","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074464488","display_name":"Hazem Elmeleegy","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100604","display_name":"Revolution Medicines (United States)","ror":"https://ror.org/00mny1y94","country_code":"US","type":"company","lineage":["https://openalex.org/I4210100604"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hazem Elmeleegy","raw_affiliation_strings":["Turn, Inc., Redwood City, CA, USA"],"affiliations":[{"raw_affiliation_string":"Turn, Inc., Redwood City, CA, USA","institution_ids":["https://openalex.org/I4210100604"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071763795","display_name":"Cecilia M. Procopiuc","orcid":null},"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":"Cecilia M. Procopiuc","raw_affiliation_strings":["AT&T Labs - Research, Florham Park, NJ, USA","AT&T Labs---Research, Florham Park, NJ, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"AT&T Labs - Research, Florham Park, NJ, USA","institution_ids":["https://openalex.org/I1283103587"]},{"raw_affiliation_string":"AT&T Labs---Research, Florham Park, NJ, USA#TAB#","institution_ids":["https://openalex.org/I1283103587"]}]},{"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, Florham Park, NJ, USA","AT&T Labs---Research, Florham Park, NJ, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"AT&T Labs - Research, Florham Park, NJ, USA","institution_ids":["https://openalex.org/I1283103587"]},{"raw_affiliation_string":"AT&T Labs---Research, Florham Park, NJ, USA#TAB#","institution_ids":["https://openalex.org/I1283103587"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5086550982"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":8.2939,"has_fulltext":false,"cited_by_count":67,"citation_normalized_percentile":{"value":0.97804027,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"809","last_page":"820"},"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.9998000264167786,"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.9998000264167786,"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.9987000226974487,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9912999868392944,"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.8118515014648438},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7843058109283447},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6743873357772827},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5658362507820129},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4995748996734619},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.45045098662376404},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.43710747361183167},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.41664087772369385},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3659185767173767},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2949208915233612},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.18702757358551025},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13054248690605164}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8118515014648438},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7843058109283447},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6743873357772827},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5658362507820129},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4995748996734619},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.45045098662376404},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.43710747361183167},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.41664087772369385},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3659185767173767},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2949208915233612},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18702757358551025},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13054248690605164},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2463676.2465320","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2465320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/78326","is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/78326","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scopus","raw_type":"Conference Paper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.367.5423","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.367.5423","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.research.att.com/export/sites/att_labs/techdocs/TD_100985.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320321026","display_name":"Ministry of Earth Sciences","ror":"https://ror.org/013cf5k59"},{"id":"https://openalex.org/F4320322724","display_name":"Ministry of Education, India","ror":"https://ror.org/048xjjh50"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1981585544","https://openalex.org/W2013167115","https://openalex.org/W2023878327","https://openalex.org/W2032299694","https://openalex.org/W2096454106","https://openalex.org/W2121350579","https://openalex.org/W2121832290","https://openalex.org/W2159454657","https://openalex.org/W2169624745","https://openalex.org/W2950584515","https://openalex.org/W6763861925"],"related_works":["https://openalex.org/W2381211091","https://openalex.org/W4205996836","https://openalex.org/W4283362132","https://openalex.org/W2091359263","https://openalex.org/W1866159721","https://openalex.org/W4234452035","https://openalex.org/W2469706965","https://openalex.org/W1989231289","https://openalex.org/W3033055359","https://openalex.org/W2334867751"],"abstract_inverted_index":{"We":[0,75],"study":[1],"the":[2,60,70],"following":[3],"problem:":[4],"Given":[5],"a":[6,18,34,48],"database":[7],"D":[8],"with":[9,69],"schema":[10],"G":[11],"and":[12,46,87],"an":[13],"output":[14],"table":[15],"Out,":[16],"compute":[17],"join":[19],"query":[20],"Q":[21,31,63],"that":[22,81],"generates":[23],"OUT":[24],"from":[25],"D.":[26],"A":[27],"simpler":[28],"variant":[29],"allows":[30],"to":[32],"return":[33],"superset":[35],"of":[36,62],"Out.":[37],"This":[38],"problem":[39],"has":[40],"numerous":[41],"applications,":[42],"both":[43],"by":[44,91],"itself,":[45],"as":[47],"building":[49],"block":[50],"for":[51],"other":[52],"problems.":[53],"Related":[54],"prior":[55,92],"work":[56],"imposes":[57],"conditions":[58,86],"on":[59],"structure":[61],"which":[64],"are":[65],"not":[66,83],"always":[67],"consistent":[68],"application,":[71],"but":[72],"simplify":[73],"computation.":[74],"discuss":[76],"several":[77],"natural":[78],"SQL":[79],"queries":[80],"do":[82],"satisfy":[84],"these":[85],"cannot":[88],"be":[89],"discovered":[90],"work.":[93]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":8},{"year":2018,"cited_by_count":12},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":12},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}