{"id":"https://openalex.org/W2039652440","doi":"https://doi.org/10.1145/2723372.2746484","title":"An Incremental Anytime Algorithm for Multi-Objective Query Optimization","display_name":"An Incremental Anytime Algorithm for Multi-Objective Query Optimization","publication_year":2015,"publication_date":"2015-05-27","ids":{"openalex":"https://openalex.org/W2039652440","doi":"https://doi.org/10.1145/2723372.2746484","mag":"2039652440"},"language":"en","primary_location":{"id":"doi:10.1145/2723372.2746484","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2723372.2746484","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://infoscience.epfl.ch/record/206964","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5087259526","display_name":"Immanuel Trummer","orcid":"https://orcid.org/0000-0002-7203-2349"},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Immanuel Trummer","raw_affiliation_strings":["EPFL, Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"EPFL, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101903922","display_name":"Christoph Koch","orcid":"https://orcid.org/0000-0002-9130-7205"},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Christoph Koch","raw_affiliation_strings":["EPFL, Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"EPFL, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5087259526"],"corresponding_institution_ids":["https://openalex.org/I5124864"],"apc_list":null,"apc_paid":null,"fwci":4.6319,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.95498909,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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.9998000264167786,"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.9997000098228455,"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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9973000288009644,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8801587224006653},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7288227677345276},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.5534456372261047},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.48290228843688965},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.4278516471385956},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.4212172329425812},{"id":"https://openalex.org/keywords/execution-time","display_name":"Execution time","score":0.41127413511276245},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.39101481437683105},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3550495505332947},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.30043643712997437},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.30019333958625793},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2360232174396515},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.18769344687461853},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.18198004364967346},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1010068953037262}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8801587224006653},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7288227677345276},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.5534456372261047},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.48290228843688965},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.4278516471385956},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4212172329425812},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.41127413511276245},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.39101481437683105},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3550495505332947},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.30043643712997437},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.30019333958625793},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2360232174396515},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.18769344687461853},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.18198004364967346},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1010068953037262}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2723372.2746484","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2723372.2746484","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.696.1070","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.696.1070","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://infoscience.epfl.ch/record/206964/files/infoscienceIncAnyMOQO.pdf","raw_type":"text"},{"id":"pmh:oai:infoscience.epfl.ch:206964","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/206964","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"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":"","raw_type":"Text"}],"best_oa_location":{"id":"pmh:oai:infoscience.epfl.ch:206964","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/206964","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"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":"","raw_type":"Text"},"sustainable_development_goals":[{"score":0.9100000262260437,"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W173784579","https://openalex.org/W1596411313","https://openalex.org/W1789812421","https://openalex.org/W1790946027","https://openalex.org/W1984385885","https://openalex.org/W1987175217","https://openalex.org/W1989111470","https://openalex.org/W2020290119","https://openalex.org/W2043097023","https://openalex.org/W2053688343","https://openalex.org/W2092276439","https://openalex.org/W2097363087","https://openalex.org/W2112668678","https://openalex.org/W2149516580","https://openalex.org/W2152686036","https://openalex.org/W2153329411","https://openalex.org/W2154888102","https://openalex.org/W2157637666","https://openalex.org/W2163316275","https://openalex.org/W2279128014","https://openalex.org/W2296677182"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W4361194359","https://openalex.org/W2006459955","https://openalex.org/W2992414350","https://openalex.org/W203907944","https://openalex.org/W2955368753","https://openalex.org/W1971797742","https://openalex.org/W2249768123","https://openalex.org/W185198413","https://openalex.org/W2611817341"],"abstract_inverted_index":{"Query":[0],"plans":[1,102],"offer":[2],"diverse":[3],"tradeoffs":[4],"between":[5,88,137],"conflicting":[6],"cost":[7,31,54],"metrics":[8],"such":[9,67],"as":[10],"execution":[11,16],"time,":[12],"energy":[13],"consumption,":[14],"or":[15],"fees":[17],"in":[18,33,169],"a":[19,48],"multi-objective":[20],"scenario.":[21],"It":[22],"is":[23,179],"convenient":[24],"for":[25,108,124],"users":[26],"to":[27,65,156],"choose":[28],"the":[29,43,109,167,182],"desired":[30],"tradeoff":[32,136],"an":[34,68,120,134,160],"interactive":[35,69,161],"process,":[36],"dynamically":[37],"adding":[38],"constraints":[39],"and":[40,129,145],"finally":[41],"selecting":[42],"best":[44],"plan":[45,80],"based":[46,180],"on":[47,174,181],"continuously":[49],"refined":[50],"visualization":[51],"of":[52,82],"optimal":[53],"tradeoffs.":[55],"Multi-objective":[56],"query":[57,101,111,162],"optimization":[58,163],"(MOQO)":[59],"algorithms":[60],"must":[61,73,93],"possess":[62],"specific":[63],"properties":[64,152],"support":[66],"process:":[70],"First,":[71],"they":[72,92,98],"be":[74,94,157],"anytime":[75,122],"algorithms,":[76],"generating":[77],"multiple":[78,149],"result":[79,138],"sets":[81],"increasing":[83],"quality":[84],"with":[85,113,171],"low":[86],"latency":[87],"consecutive":[89],"results.":[90],"Second,":[91],"incremental,":[95],"meaning":[96],"that":[97,131],"avoid":[99],"regenerating":[100],"when":[103],"being":[104],"invoked":[105],"several":[106],"times":[107],"same":[110],"but":[112],"slightly":[114],"different":[115],"user":[116],"constraints.":[117],"We":[118,165],"present":[119],"incremental":[121],"algorithm":[123,168],"MOQO,":[125],"analyze":[126],"its":[127],"complexity":[128],"show":[130],"it":[132,154],"offers":[133],"attractive":[135],"update":[139],"frequency,":[140],"single":[141],"invocation":[142],"time":[143,147],"complexity,":[144],"amortized":[146],"over":[148],"invocations.":[150],"Those":[151],"make":[153],"suitable":[155],"used":[158],"within":[159],"process.":[164],"evaluate":[166],"comparison":[170],"prior":[172],"work":[173],"TPC-H":[175],"queries;":[176],"our":[177],"implementation":[178],"Postgres":[183],"database":[184],"management":[185],"system.":[186]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":8},{"year":2015,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}