{"id":"https://openalex.org/W2011300314","doi":"https://doi.org/10.1145/2463676.2463678","title":"Workload optimization using SharedDB","display_name":"Workload optimization using SharedDB","publication_year":2013,"publication_date":"2013-06-22","ids":{"openalex":"https://openalex.org/W2011300314","doi":"https://doi.org/10.1145/2463676.2463678","mag":"2011300314"},"language":"en","primary_location":{"id":"doi:10.1145/2463676.2463678","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2463678","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/A5037802216","display_name":"Georgios Giannikis","orcid":null},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Georgios Giannikis","raw_affiliation_strings":["ETH Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015669459","display_name":"Darko Makreshanski","orcid":"https://orcid.org/0000-0002-3135-0172"},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Darko Makreshanski","raw_affiliation_strings":["ETH Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103144919","display_name":"Gustavo Alonso","orcid":"https://orcid.org/0000-0002-4396-6695"},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Gustavo Alonso","raw_affiliation_strings":["ETH Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111504785","display_name":"Donald Kossmann","orcid":null},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Donald Kossmann","raw_affiliation_strings":["ETH Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I35440088"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5037802216"],"corresponding_institution_ids":["https://openalex.org/I35440088"],"apc_list":null,"apc_paid":null,"fwci":1.5243,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.84411058,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1045","last_page":"1048"},"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.9995999932289124,"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.9995999932289124,"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.9988999962806702,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9951000213623047,"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.8748213648796082},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7311166524887085},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7072935104370117},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6754356026649475},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5648269057273865},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5309210419654846},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5305374264717102},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5266163945198059},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.5162496566772461},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5040273070335388},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.43831413984298706},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3449134826660156},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.22124174237251282},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1911046802997589},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1770646572113037},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1288238763809204},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12795835733413696}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8748213648796082},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7311166524887085},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7072935104370117},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6754356026649475},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5648269057273865},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5309210419654846},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5305374264717102},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5266163945198059},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5162496566772461},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5040273070335388},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.43831413984298706},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3449134826660156},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.22124174237251282},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1911046802997589},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1770646572113037},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1288238763809204},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12795835733413696}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2463676.2463678","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2463678","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"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W1599548736","https://openalex.org/W2040057776","https://openalex.org/W2150606131","https://openalex.org/W2951529282"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2978539281","https://openalex.org/W2406556739","https://openalex.org/W2217632272","https://openalex.org/W2128834514","https://openalex.org/W3031390801","https://openalex.org/W2008116177","https://openalex.org/W4379390531","https://openalex.org/W2887264929","https://openalex.org/W3008396432"],"abstract_inverted_index":{"This":[0],"demonstration":[1,92],"presents":[2],"SharedDB,":[3],"an":[4],"implementation":[5],"of":[6,12,57,67,79,90,98],"a":[7,64],"relational":[8],"database":[9],"system":[10],"capable":[11],"executing":[13],"all":[14,23,85],"SQL":[15],"operators":[16],"by":[17],"sharing":[18,70],"computation":[19,80],"and":[20,32,106,109,124,129],"resources":[21],"across":[22,84],"running":[24,86],"queries.":[25,87],"SharedDB":[26,43,75],"sidesteps":[27],"the":[28,58,96,112],"traditional":[29,122],"query-at-a-time":[30],"approach":[31],"executes":[33],"queries":[34,44,117],"in":[35,42,52,121],"batches.":[36],"Unlike":[37],"proposed":[38],"multi-query":[39],"optimization":[40],"ideas,":[41],"do":[45],"not":[46],"have":[47],"to":[48,54,94,102,126],"contain":[49],"common":[50,83],"subexpressions":[51],"order":[53],"be":[55],"part":[56],"same":[59],"batch,":[60],"which":[61],"allows":[62],"for":[63],"higher":[65],"degree":[66],"sharing.":[68],"By":[69],"as":[71,73],"much":[72],"possible,":[74],"avoids":[76],"repeating":[77],"parts":[78],"that":[81,118],"is":[82,93,119],"The":[88],"goal":[89],"this":[91],"show":[95],"ability":[97],"shared":[99],"query":[100],"execution":[101],"a)":[103],"answer":[104],"complex":[105],"diverse":[107],"workloads,":[108],"b)":[110],"reduce":[111],"interaction":[113],"among":[114],"concurrently":[115],"executed":[116],"observed":[120],"systems":[123],"leads":[125],"performance":[127],"deterioration":[128],"instabilities.":[130]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-04-02T15:55:50.835912","created_date":"2025-10-10T00:00:00"}