{"id":"https://openalex.org/W3086541145","doi":"https://doi.org/10.14778/3415478.3415571","title":"Out-of-order execution of database queries","display_name":"Out-of-order execution of database queries","publication_year":2020,"publication_date":"2020-08-01","ids":{"openalex":"https://openalex.org/W3086541145","doi":"https://doi.org/10.14778/3415478.3415571","mag":"3086541145"},"language":"en","primary_location":{"id":"doi:10.14778/3415478.3415571","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415571","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5016349116","display_name":"Kazuo Goda","orcid":"https://orcid.org/0000-0003-0618-4157"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Kazuo Goda","raw_affiliation_strings":["The University of Tokyo, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Japan","institution_ids":["https://openalex.org/I74801974"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015947420","display_name":"Yuto Hayamizu","orcid":"https://orcid.org/0000-0002-5746-1743"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Yuto Hayamizu","raw_affiliation_strings":["The University of Tokyo, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Japan","institution_ids":["https://openalex.org/I74801974"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102829929","display_name":"Hiroyuki Yamada","orcid":"https://orcid.org/0000-0002-7137-0899"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Hiroyuki Yamada","raw_affiliation_strings":["The University of Tokyo, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Japan","institution_ids":["https://openalex.org/I74801974"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056438865","display_name":"Masaru Kitsuregawa","orcid":"https://orcid.org/0000-0003-4027-2994"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Masaru Kitsuregawa","raw_affiliation_strings":["The University of Tokyo, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Japan","institution_ids":["https://openalex.org/I74801974"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I74801974"],"apc_list":null,"apc_paid":null,"fwci":1.0819,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.79634324,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"13","issue":"12","first_page":"3489","last_page":"3501"},"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.9986000061035156,"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.9986000061035156,"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.9973000288009644,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.996999979019165,"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.9070031642913818},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5737863779067993},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5711916089057922},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.567783772945404},{"id":"https://openalex.org/keywords/data-parallelism","display_name":"Data parallelism","score":0.5321050882339478},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5170795917510986},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.49455568194389343},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.4893926680088043},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48532241582870483},{"id":"https://openalex.org/keywords/parallelism","display_name":"Parallelism (grammar)","score":0.4684818983078003},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4210035800933838},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.41092920303344727},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.25573426485061646},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.24602138996124268},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.17836982011795044},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1751585304737091},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11244884133338928}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9070031642913818},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5737863779067993},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5711916089057922},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.567783772945404},{"id":"https://openalex.org/C61483411","wikidata":"https://www.wikidata.org/wiki/Q3124522","display_name":"Data parallelism","level":3,"score":0.5321050882339478},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5170795917510986},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.49455568194389343},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4893926680088043},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48532241582870483},{"id":"https://openalex.org/C2781172179","wikidata":"https://www.wikidata.org/wiki/Q853109","display_name":"Parallelism (grammar)","level":2,"score":0.4684818983078003},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4210035800933838},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.41092920303344727},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.25573426485061646},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.24602138996124268},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.17836982011795044},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1751585304737091},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11244884133338928},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3415478.3415571","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415571","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.5400000214576721}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":56,"referenced_works":["https://openalex.org/W148285352","https://openalex.org/W206955312","https://openalex.org/W1494822125","https://openalex.org/W1533268127","https://openalex.org/W1552895988","https://openalex.org/W1573110363","https://openalex.org/W1574862731","https://openalex.org/W1605782097","https://openalex.org/W1758832012","https://openalex.org/W1794564547","https://openalex.org/W1976417857","https://openalex.org/W1979166923","https://openalex.org/W1982632559","https://openalex.org/W1984527041","https://openalex.org/W1990781295","https://openalex.org/W1994502095","https://openalex.org/W2003515726","https://openalex.org/W2005294557","https://openalex.org/W2008070110","https://openalex.org/W2020601345","https://openalex.org/W2023620877","https://openalex.org/W2023633366","https://openalex.org/W2035720033","https://openalex.org/W2050952165","https://openalex.org/W2074935284","https://openalex.org/W2082701182","https://openalex.org/W2083541728","https://openalex.org/W2099035968","https://openalex.org/W2100830825","https://openalex.org/W2103060820","https://openalex.org/W2106771621","https://openalex.org/W2107887442","https://openalex.org/W2108127784","https://openalex.org/W2112668678","https://openalex.org/W2124851765","https://openalex.org/W2125529470","https://openalex.org/W2131975293","https://openalex.org/W2133300302","https://openalex.org/W2151826520","https://openalex.org/W2159726625","https://openalex.org/W2167276970","https://openalex.org/W2167679350","https://openalex.org/W2169012378","https://openalex.org/W2171438172","https://openalex.org/W2173213060","https://openalex.org/W2245726859","https://openalex.org/W2342922783","https://openalex.org/W2423220585","https://openalex.org/W2761251889","https://openalex.org/W2908321983","https://openalex.org/W3005402251","https://openalex.org/W3152703111","https://openalex.org/W4235245586","https://openalex.org/W4239429564","https://openalex.org/W4239671915","https://openalex.org/W4252265332"],"related_works":["https://openalex.org/W2366027386","https://openalex.org/W2604963418","https://openalex.org/W2074226157","https://openalex.org/W2003701127","https://openalex.org/W2545191987","https://openalex.org/W3103741606","https://openalex.org/W4249523967","https://openalex.org/W3087322491","https://openalex.org/W1585350690","https://openalex.org/W29343545"],"abstract_inverted_index":{"Intra-query":[0],"parallelism":[1,24,119,143],"is":[2,29,52,135,202,216],"a":[3,30,35,47,88,151],"key":[4],"for":[5,12,25,97,120,150,179],"database":[6,26,85,98,133,196],"software":[7,57,134,197],"to":[8,20,64,67,77,93,124,137,204,219,234],"offer":[9,94],"acceptable":[10],"responsiveness":[11],"data-intensive":[13],"queries.":[14,27],"Many":[15],"researchers":[16],"have":[17],"studied":[18],"how":[19,66],"achieve":[21,78],"greater":[22],"execution":[23,79,86,91,118,142],"Partitioning":[28],"representative":[31],"approach,":[32],"which":[33],"divides":[34],"query":[36,70,90,104,128,146,182],"into":[37],"multiple":[38],"sub-tasks":[39],"and":[40,198],"executes":[41],"them":[42],"in":[43],"parallel.":[44],"However,":[45],"given":[46],"new":[48],"query,":[49],"optimal":[50],"division":[51],"not":[53],"necessarily":[54],"obvious.":[55],"Database":[56],"utilizes":[58],"heuristic":[59],"rules":[60],"or":[61,170],"statistical":[62],"information":[63],"decide":[65],"divide":[68],"the":[69,108,112,116,132,141,145,161,177,181,188,194,211,224],"before":[71,183],"execution.":[72,129,184],"As":[73],"yet":[74],"another":[75],"approach":[76],"parallelism,":[80],"this":[81],"paper":[82,186],"presents":[83,187],"out-of-order":[84],"(OoODE),":[87],"massively-parallel":[89],"method":[92],"significant":[95],"speedup":[96],"queries":[99],"consistently.":[100],"OoODE":[101,156,201,231],"dynamically":[102],"decomposes":[103],"work":[105],"by":[106],"making":[107],"best":[109,225],"use":[110],"of":[111,115,154,207,228,237],"exact":[113],"knowledge":[114],"potential":[117],"each":[121],"operation":[122],"ready":[123],"be":[125],"performed":[126],"during":[127],"With":[130],"OoODE,":[131],"allowed":[136],"automatically":[138],"squeeze":[139],"out":[140],"that":[144,190,200],"inherently":[147],"holds.":[148],"Hence,":[149],"wide":[152],"spectrum":[153],"queries,":[155],"performs":[157,167,232],"significantly":[158],"faster":[159,209,222,239],"than":[160,169,210,223,240],"serial":[162,212],"(non-parallelized)":[163],"execution,":[164,213],"while":[165],"it":[166,215],"better":[168],"comparably":[171],"with":[172],"alternative":[173],"parallelizing":[174],"methods":[175],"without":[176],"need":[178],"dividing":[180],"This":[185],"experiments":[189],"we":[191],"conducted":[192],"using":[193],"prototyped":[195],"demonstrates":[199],"two":[203,233],"three":[205],"orders":[206,236],"magnitude":[208,238],"whereas":[214],"substantially":[217],"(up":[218],"2.07":[220],"times)":[221],"achievable":[226],"case":[227],"partitioning.":[229],"Besides,":[230],"four":[235],"major":[241],"DBMSs.":[242]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":3}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}