{"id":"https://openalex.org/W2075771049","doi":"https://doi.org/10.1145/2588555.2595635","title":"Parallel I/O aware query optimization","display_name":"Parallel I/O aware query optimization","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W2075771049","doi":"https://doi.org/10.1145/2588555.2595635","mag":"2075771049"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2595635","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2595635","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 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/A5055921775","display_name":"Pedram Ghodsnia","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":"Pedram Ghodsnia","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/A5045682192","display_name":"Ivan T. Bowman","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ivan T. Bowman","raw_affiliation_strings":["SAP AG, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"SAP AG, Waterloo, ON, Canada","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109865053","display_name":"Anisoara Nica","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anisoara Nica","raw_affiliation_strings":["SAP AG, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"SAP AG, Waterloo, ON, Canada","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5055921775"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":1.0344,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.8048849,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"349","last_page":"360"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"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":1.0,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9918000102043152,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9807999730110168,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.8552756309509277},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7294594049453735},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6124024987220764},{"id":"https://openalex.org/keywords/queue","display_name":"Queue","score":0.5383710861206055},{"id":"https://openalex.org/keywords/parallelism","display_name":"Parallelism (grammar)","score":0.5207262635231018},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5177525877952576},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5172365307807922},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.5065203905105591},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4883565604686737},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4611964225769043},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.448481947183609},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.4356963634490967},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.22391587495803833},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18742939829826355},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.18150562047958374},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.11751323938369751}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8552756309509277},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7294594049453735},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6124024987220764},{"id":"https://openalex.org/C160403385","wikidata":"https://www.wikidata.org/wiki/Q220543","display_name":"Queue","level":2,"score":0.5383710861206055},{"id":"https://openalex.org/C2781172179","wikidata":"https://www.wikidata.org/wiki/Q853109","display_name":"Parallelism (grammar)","level":2,"score":0.5207262635231018},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5177525877952576},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5172365307807922},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.5065203905105591},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4883565604686737},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4611964225769043},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.448481947183609},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4356963634490967},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.22391587495803833},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18742939829826355},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.18150562047958374},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.11751323938369751}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2588555.2595635","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2595635","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6299999952316284,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W106164280","https://openalex.org/W1573110363","https://openalex.org/W1578937649","https://openalex.org/W1605782097","https://openalex.org/W1981029608","https://openalex.org/W1984282814","https://openalex.org/W1985765509","https://openalex.org/W1995311648","https://openalex.org/W2010327148","https://openalex.org/W2022239314","https://openalex.org/W2027578476","https://openalex.org/W2044752022","https://openalex.org/W2058178853","https://openalex.org/W2062487414","https://openalex.org/W2082317049","https://openalex.org/W2103709927","https://openalex.org/W2133671413","https://openalex.org/W2141048674","https://openalex.org/W2152102944","https://openalex.org/W2153329411","https://openalex.org/W2154809801","https://openalex.org/W2295596515","https://openalex.org/W2400022562","https://openalex.org/W2408182548","https://openalex.org/W2753710282","https://openalex.org/W2913593077","https://openalex.org/W6604260118","https://openalex.org/W6634379739","https://openalex.org/W6713485728","https://openalex.org/W7018146823"],"related_works":["https://openalex.org/W2955368753","https://openalex.org/W2554271401","https://openalex.org/W2588167896","https://openalex.org/W2188347403","https://openalex.org/W2410487789","https://openalex.org/W2889903446","https://openalex.org/W2150741898","https://openalex.org/W2362460270","https://openalex.org/W2375340541","https://openalex.org/W2385089576"],"abstract_inverted_index":{"New":[0],"trends":[1],"in":[2,7,47,53,62,94,106,110,131,159,194],"storage":[3,18,196],"industry":[4],"suggest":[5],"that":[6,122,137],"the":[8,14,35,42,54,57,80,88,91,100,124,141,146,172,175,184,187,195],"near":[9],"future":[10],"a":[11,116,168],"majority":[12],"of":[13,39,44,60,87,90,102,126,174,189],"hard":[15],"disk":[16],"drive-based":[17],"subsystems":[19],"will":[20],"be":[21,85,149],"replaced":[22],"by":[23,145,167],"solid":[24,95],"state":[25,96],"drives":[26],"(SSDs).":[27],"Database":[28],"management":[29],"systems":[30],"can":[31],"substantially":[32],"benefit":[33,89,101],"from":[34],"superior":[36],"I/O":[37,58,92,104,119,128,132,176],"performance":[38],"SSDs.":[40],"Although":[41],"impact":[43,125],"using":[45,138],"SSD":[46],"query":[48,63,81],"processing":[49,64],"has":[50,67],"been":[51],"studied":[52],"past,":[55],"exploiting":[56,103],"parallelism":[59,93,105],"SSDs":[61],"and":[65,114,186],"optimization":[66],"not":[68],"received":[69],"enough":[70],"attention.":[71],"In":[72],"this":[73,139],"paper,":[74],"at":[75],"first,":[76],"we":[77],"show":[78,136],"why":[79],"optimizer":[82,147],"needs":[83],"to":[84,152],"aware":[86],"drives.":[97],"We":[98,135],"characterize":[99],"database":[107],"scan":[108],"operators":[109],"SAP":[111,160],"SQL":[112,161],"Anywhere":[113],"propose":[115],"novel":[117],"general":[118],"cost":[120,133],"model":[121,156],"considers":[123],"device":[127],"queue":[129],"depth":[130],"estimation.":[134],"model,":[140,164],"best":[142],"plans":[143],"found":[144],"would":[148],"much":[150],"closer":[151],"optimal.":[153],"The":[154],"proposed":[155],"is":[157],"implemented":[158],"Anywhere.":[162],"This":[163],"dynamically":[165],"defined":[166],"calibration":[169],"process,":[170],"summarizes":[171],"behavior":[173],"subsystem,":[177],"without":[178],"having":[179],"any":[180],"prior":[181],"knowledge":[182],"about":[183],"type":[185],"number":[188],"devices":[190],"which":[191],"are":[192],"used":[193],"subsystem.":[197]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}