{"id":"https://openalex.org/W2081991734","doi":"https://doi.org/10.1145/1807167.1807268","title":"Workload-aware storage layout for database systems","display_name":"Workload-aware storage layout for database systems","publication_year":2010,"publication_date":"2010-06-06","ids":{"openalex":"https://openalex.org/W2081991734","doi":"https://doi.org/10.1145/1807167.1807268","mag":"2081991734"},"language":"en","primary_location":{"id":"doi:10.1145/1807167.1807268","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807268","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 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/A5040947973","display_name":"Oguzhan Ozmen","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Oguzhan Ozmen","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035977189","display_name":"Kenneth Salem","orcid":"https://orcid.org/0000-0003-0409-9725"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Kenneth Salem","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111689390","display_name":"Ji\u0159\u00ed Schindler","orcid":null},"institutions":[{"id":"https://openalex.org/I1283576576","display_name":"NetApp (United States)","ror":"https://ror.org/05c4cm338","country_code":"US","type":"company","lineage":["https://openalex.org/I1283576576"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jiri Schindler","raw_affiliation_strings":["NetApp, Inc., Waltham, MA, USA","NetApp, Inc., Waltham, MA, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"NetApp, Inc., Waltham, MA, USA","institution_ids":["https://openalex.org/I1283576576"]},{"raw_affiliation_string":"NetApp, Inc., Waltham, MA, USA#TAB#","institution_ids":["https://openalex.org/I1283576576"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113759368","display_name":"Steve Daniel","orcid":null},"institutions":[{"id":"https://openalex.org/I1283576576","display_name":"NetApp (United States)","ror":"https://ror.org/05c4cm338","country_code":"US","type":"company","lineage":["https://openalex.org/I1283576576"]},{"id":"https://openalex.org/I1309191912","display_name":"Research Triangle Park Foundation","ror":"https://ror.org/03eqttr49","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I1309191912"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Steve Daniel","raw_affiliation_strings":["NetApp, Inc., Research Triangle Park, NC, USA","NetApp, Inc., Research Triangle Park, NC, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"NetApp, Inc., Research Triangle Park, NC, USA","institution_ids":["https://openalex.org/I1283576576"]},{"raw_affiliation_string":"NetApp, Inc., Research Triangle Park, NC, USA#TAB#","institution_ids":["https://openalex.org/I1309191912"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5040947973"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":4.45108277,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.94521855,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"939","last_page":"950"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9995999932289124,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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.818821132183075},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.7888191938400269},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6881383657455444},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5711997747421265},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5180899500846863},{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.5041218996047974},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.4662306308746338},{"id":"https://openalex.org/keywords/page-layout","display_name":"Page layout","score":0.4235895872116089},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1545294225215912},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13875523209571838},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10206711292266846}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.818821132183075},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.7888191938400269},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6881383657455444},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5711997747421265},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5180899500846863},{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.5041218996047974},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.4662306308746338},{"id":"https://openalex.org/C188985296","wikidata":"https://www.wikidata.org/wiki/Q868954","display_name":"Page layout","level":2,"score":0.4235895872116089},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1545294225215912},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13875523209571838},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10206711292266846},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C112698675","wikidata":"https://www.wikidata.org/wiki/Q37038","display_name":"Advertising","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1807167.1807268","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807268","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320316505","display_name":"NetApp","ror":"https://ror.org/05c4cm338"},{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W60569950","https://openalex.org/W189195062","https://openalex.org/W1512490553","https://openalex.org/W1541482680","https://openalex.org/W1757036004","https://openalex.org/W1964166152","https://openalex.org/W1981029608","https://openalex.org/W1992331625","https://openalex.org/W2036454167","https://openalex.org/W2062617656","https://openalex.org/W2072278885","https://openalex.org/W2082871877","https://openalex.org/W2089279161","https://openalex.org/W2101343419","https://openalex.org/W2106394537","https://openalex.org/W2129657903","https://openalex.org/W2146970559","https://openalex.org/W2154611747","https://openalex.org/W2166709280","https://openalex.org/W2167942260","https://openalex.org/W2786741601","https://openalex.org/W4255327858"],"related_works":["https://openalex.org/W3177062893","https://openalex.org/W3125143773","https://openalex.org/W2007032764","https://openalex.org/W803550684","https://openalex.org/W2483226803","https://openalex.org/W4352977312","https://openalex.org/W4312926500","https://openalex.org/W2067280619","https://openalex.org/W4251343851","https://openalex.org/W2041180560"],"abstract_inverted_index":{"The":[0],"performance":[1],"of":[2,11,67,81,100,105,109,122,125,180],"a":[3,106,123,137,161,166],"database":[4,12,36,110,127,162],"system":[5,37],"depends":[6],"strongly":[7],"on":[8,52],"the":[9,20,30,35,40,53,82,98,126,133,144,178],"layout":[10,26,59,104,113,134,154,163,167],"objects,":[13],"such":[14,69],"as":[15,70,136,147],"indexes":[16,72],"or":[17,75],"tables,":[18],"onto":[19],"underlying":[21],"storage":[22,84],"devices.":[23,85],"A":[24],"good":[25],"will":[27],"both":[28,169],"balance":[29],"I/O":[31,129,145],"workload":[32],"generated":[33],"by":[34,63,119],"and":[38,65,73,142,172,183],"avoid":[39],"performance-degrading":[41],"interference":[42],"that":[43,168,185],"can":[44,187],"occur":[45],"when":[46],"concurrently":[47],"accessed":[48],"objects":[49,78],"are":[50],"stored":[51],"same":[54],"volume.":[55],"In":[56,93],"current":[57],"practice,":[58],"is":[60,158],"typically":[61],"guided":[62],"heuristics":[64],"rules":[66],"thumb,":[68],"separating":[71],"tables":[74],"striping":[76],"all":[77,80],"across":[79],"available":[83],"However,":[86],"these":[87],"guidelines":[88,118],"may":[89],"give":[90],"poor":[91],"results.":[92],"this":[94],"paper,":[95],"we":[96],"address":[97],"problem":[99,135,141],"generating":[101],"an":[102,150],"optimized":[103,191],"given":[107],"set":[108],"objects.":[111],"Our":[112,153],"optimizer":[114],"goes":[115],"beyond":[116],"generic":[117],"making":[120],"use":[121,143],"description":[124,146],"system's":[128],"activity.":[130],"We":[131,175],"formulate":[132],"non-linear":[138],"programming":[139],"(NLP)":[140],"input":[148],"to":[149],"NLP":[151],"solver.":[152],"optimization":[155],"technique,":[156],"which":[157],"incorporated":[159],"into":[160],"advisor,":[164],"identifies":[165],"balances":[170],"load":[171],"avoids":[173],"interference.":[174],"evaluate":[176],"experimentally":[177],"efficacy":[179],"our":[181],"approach":[182],"demonstrate":[184],"it":[186],"quickly":[188],"identify":[189],"non-trivial":[190],"layouts.":[192]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}