{"id":"https://openalex.org/W2586902511","doi":"https://doi.org/10.1145/3034786.3034792","title":"Efficient and Provable Multi-Query Optimization","display_name":"Efficient and Provable Multi-Query Optimization","publication_year":2017,"publication_date":"2017-05-09","ids":{"openalex":"https://openalex.org/W2586902511","doi":"https://doi.org/10.1145/3034786.3034792","mag":"2586902511"},"language":"en","primary_location":{"id":"doi:10.1145/3034786.3034792","doi":"https://doi.org/10.1145/3034786.3034792","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3034786.3034792","pdf_url":null,"source":{"id":"https://openalex.org/S4393916800","display_name":"ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS)","issn_l":"1055-6338","issn":["1055-6338"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 36th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1512.02568","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5015882189","display_name":"Tarun Kathuria","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210124949","display_name":"Microsoft Research (India)","ror":"https://ror.org/02w7f3w92","country_code":"IN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210124949"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Tarun Kathuria","raw_affiliation_strings":["Microsoft Research, Bangalore, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research, Bangalore, India","institution_ids":["https://openalex.org/I4210124949"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081847962","display_name":"S. Sudarshan","orcid":"https://orcid.org/0000-0002-6230-2288","observed_orcids":["https://orcid.org/0000-0002-6230-2288"]},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"S. Sudarshan","raw_affiliation_strings":["Indian Institute of Technology Bombay, Mumbai, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Bombay, Mumbai, India","institution_ids":["https://openalex.org/I162827531"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2553,"has_fulltext":true,"cited_by_count":19,"citation_normalized_percentile":{"value":0.81135289,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"53","last_page":"67"},"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.9887999892234802,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9887999892234802,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.00139999995008111,"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"}},{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.0010999999940395355,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/multi-query-optimization","display_name":"multi-query optimization","score":1.0},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.7160000205039978},{"id":"https://openalex.org/keywords/query-plan-generation","display_name":"query plan generation","score":0.5849999785423279},{"id":"https://openalex.org/keywords/batch-query-processing","display_name":"batch query processing","score":0.6420000195503235},{"id":"https://openalex.org/keywords/massive-data-analysis","display_name":"massive data analysis","score":0.6830000281333923},{"id":"https://openalex.org/keywords/combinatorial-optimization","display_name":"combinatorial optimization","score":0.6150000095367432},{"id":"https://openalex.org/keywords/theoretical-guarantees","display_name":"theoretical guarantees","score":0.42399999499320984},{"id":"https://openalex.org/keywords/heuristic-algorithms","display_name":"heuristic algorithms","score":0.6019999980926514}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8439255952835083},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8098410367965698},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.7080361843109131},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5967287421226501},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.5145506262779236},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.5100115537643433},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4708406925201416},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.45214399695396423},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.4494648575782776},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4302242696285248},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4153619408607483},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4040784239768982},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34183478355407715},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2767959237098694},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.17748361825942993},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.15604308247566223},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3034786.3034792","doi":"https://doi.org/10.1145/3034786.3034792","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3034786.3034792","pdf_url":null,"source":{"id":"https://openalex.org/S4393916800","display_name":"ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS)","issn_l":"1055-6338","issn":["1055-6338"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 36th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1512.02568","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/1512.02568","pdf_url":"https://arxiv.org/pdf/1512.02568","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"mag:2289229688","doi":null,"is_oa":true,"landing_page_url":"https://arxiv.org/pdf/1512.02568v1","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"arXiv (Cornell University)","raw_type":null},{"id":"doi:10.48550/arxiv.1512.02568","doi":"https://doi.org/10.48550/arxiv.1512.02568","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1512.02568","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1512.02568","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/1512.02568","pdf_url":"https://arxiv.org/pdf/1512.02568","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2586902511.pdf","grobid_xml":"https://content.openalex.org/works/W2586902511.grobid-xml"},"referenced_works_count":37,"referenced_works":["https://openalex.org/W46989511","https://openalex.org/W135863099","https://openalex.org/W235236266","https://openalex.org/W1486683419","https://openalex.org/W1548134621","https://openalex.org/W1586797185","https://openalex.org/W1680189815","https://openalex.org/W1898824936","https://openalex.org/W1987605824","https://openalex.org/W2007598971","https://openalex.org/W2033885045","https://openalex.org/W2044471216","https://openalex.org/W2047809518","https://openalex.org/W2053381548","https://openalex.org/W2058978608","https://openalex.org/W2059453880","https://openalex.org/W2061820396","https://openalex.org/W2061958803","https://openalex.org/W2069811933","https://openalex.org/W2090773975","https://openalex.org/W2098416578","https://openalex.org/W2106105896","https://openalex.org/W2124186830","https://openalex.org/W2128680590","https://openalex.org/W2132651631","https://openalex.org/W2133374323","https://openalex.org/W2136195851","https://openalex.org/W2143996311","https://openalex.org/W2150974577","https://openalex.org/W2158557760","https://openalex.org/W2169551590","https://openalex.org/W2514846057","https://openalex.org/W2597507805","https://openalex.org/W2621717961","https://openalex.org/W2645036108","https://openalex.org/W2951321531","https://openalex.org/W3118655244"],"related_works":["https://openalex.org/W2289229688","https://openalex.org/W2951321531","https://openalex.org/W1584233676","https://openalex.org/W7097803337","https://openalex.org/W7095572272","https://openalex.org/W7096236766","https://openalex.org/W3098822424","https://openalex.org/W2106105896","https://openalex.org/W2150974577","https://openalex.org/W2187337256"],"abstract_inverted_index":{"Complex":[0],"queries":[1,13,25],"for":[2,66],"massive":[3],"data":[4],"analysis":[5],"jobs":[6],"have":[7],"become":[8],"increasingly":[9],"commonplace.":[10],"Many":[11],"such":[12],"contain":[14],"common":[15,58],"subexpressions,":[16],"either":[17],"within":[18],"a":[19,28],"single":[20],"query":[21,31],"or":[22],"among":[23],"multiple":[24],"submitted":[26],"as":[27],"batch.":[29],"Conventional":[30],"optimizers":[32],"do":[33],"not":[34],"exploit":[35],"these":[36],"subexpressions":[37,59],"and":[38,61],"produce":[39],"sub-optimal":[40],"plans.":[41],"The":[42],"problem":[43,75],"of":[44,92],"multi-query":[45],"optimization":[46],"(MQO)":[47],"is":[48],"to":[49],"generate":[50],"an":[51,69],"optimal":[52],"combined":[53],"evaluation":[54],"plan":[55],"by":[56],"computing":[57],"once":[60],"reusing":[62],"them.":[63],"Exhaustive":[64],"algorithms":[65],"MQO":[67],"explore":[68],"O(nn)":[70],"search":[71],"space.":[72],"Thus,":[73],"this":[74],"has":[76],"primarily":[77],"been":[78],"tackled":[79],"using":[80],"various":[81],"heuristic":[82],"algorithms,":[83],"without":[84],"providing":[85],"any":[86],"theoretical":[87],"guarantees":[88],"on":[89],"the":[90],"quality":[91],"their":[93],"solution.":[94]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2017-02-17T00:00:00"}