{"id":"https://openalex.org/W2087177601","doi":"https://doi.org/10.1145/2588555.2595636","title":"HAWQ","display_name":"HAWQ","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W2087177601","doi":"https://doi.org/10.1145/2588555.2595636","mag":"2087177601"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2595636","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2595636","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/A5083374325","display_name":"Lei Chang","orcid":"https://orcid.org/0000-0002-9824-4016"},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Lei Chang","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101409606","display_name":"Zhanwei Wang","orcid":"https://orcid.org/0009-0000-6403-1429"},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhanwei Wang","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100654768","display_name":"Tao Ma","orcid":"https://orcid.org/0000-0002-7094-6868"},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tao Ma","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063487893","display_name":"Lirong Jian","orcid":null},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lirong Jian","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101746514","display_name":"Lili Ma","orcid":"https://orcid.org/0000-0001-7109-4540"},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lili Ma","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057131056","display_name":"Alon Goldshuv","orcid":null},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alon Goldshuv","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015968350","display_name":"Luke Lonergan","orcid":null},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Luke Lonergan","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058413191","display_name":"Jeffrey P. Cohen","orcid":"https://orcid.org/0000-0001-5467-7584"},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jeffrey Cohen","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061740717","display_name":"Caleb Welton","orcid":null},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Caleb Welton","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066785380","display_name":"Gavin Sherry","orcid":null},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gavin Sherry","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103833568","display_name":"Milind Bhandarkar","orcid":null},"institutions":[{"id":"https://openalex.org/I4210155978","display_name":"Pivotal Labs","ror":"https://ror.org/04hjf5k52","country_code":"US","type":"company","lineage":["https://openalex.org/I4210155978"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Milind Bhandarkar","raw_affiliation_strings":["Pivotal, Palo Alto, USA"],"affiliations":[{"raw_affiliation_string":"Pivotal, Palo Alto, USA","institution_ids":["https://openalex.org/I4210155978"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":11,"corresponding_author_ids":["https://openalex.org/A5083374325"],"corresponding_institution_ids":["https://openalex.org/I4210155978"],"apc_list":null,"apc_paid":null,"fwci":19.7225,"has_fulltext":false,"cited_by_count":48,"citation_normalized_percentile":{"value":0.99143727,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1223","last_page":"1234"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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.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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9972000122070312,"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.8897889256477356},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7021991014480591},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.69748455286026},{"id":"https://openalex.org/keywords/fault-tolerance","display_name":"Fault tolerance","score":0.6798192262649536},{"id":"https://openalex.org/keywords/replication","display_name":"Replication (statistics)","score":0.5146259069442749},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.47196802496910095},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.44829583168029785},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.43562740087509155},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4329671561717987},{"id":"https://openalex.org/keywords/protocol","display_name":"Protocol (science)","score":0.41631802916526794},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3493545353412628}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8897889256477356},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7021991014480591},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.69748455286026},{"id":"https://openalex.org/C63540848","wikidata":"https://www.wikidata.org/wiki/Q3140932","display_name":"Fault tolerance","level":2,"score":0.6798192262649536},{"id":"https://openalex.org/C12590798","wikidata":"https://www.wikidata.org/wiki/Q3933199","display_name":"Replication (statistics)","level":2,"score":0.5146259069442749},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47196802496910095},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.44829583168029785},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.43562740087509155},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4329671561717987},{"id":"https://openalex.org/C2780385302","wikidata":"https://www.wikidata.org/wiki/Q367158","display_name":"Protocol (science)","level":3,"score":0.41631802916526794},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3493545353412628},{"id":"https://openalex.org/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"score":0.0},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2588555.2595636","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2595636","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":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320321108","display_name":"Academy of Finland","ror":"https://ror.org/05k73zm37"},{"id":"https://openalex.org/F4320338111","display_name":"Precursory Research for Embryonic Science and Technology","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W1493893823","https://openalex.org/W1972115340","https://openalex.org/W1978924650","https://openalex.org/W1993892970","https://openalex.org/W2010279913","https://openalex.org/W2013409485","https://openalex.org/W2016829627","https://openalex.org/W2021724486","https://openalex.org/W2044849727","https://openalex.org/W2074935284","https://openalex.org/W2080427212","https://openalex.org/W2085601491","https://openalex.org/W2098935637","https://openalex.org/W2100830825","https://openalex.org/W2108510805","https://openalex.org/W2110086534","https://openalex.org/W2114303224","https://openalex.org/W2117917070","https://openalex.org/W2125775320","https://openalex.org/W2126583885","https://openalex.org/W2130642985","https://openalex.org/W2131975293","https://openalex.org/W2139072600","https://openalex.org/W2139285682","https://openalex.org/W2139445852","https://openalex.org/W2146635036","https://openalex.org/W2173213060","https://openalex.org/W2296349066"],"related_works":["https://openalex.org/W4205713785","https://openalex.org/W2389214306","https://openalex.org/W3016766501","https://openalex.org/W2901033488","https://openalex.org/W4235240664","https://openalex.org/W2965083567","https://openalex.org/W2757182831","https://openalex.org/W1838576100","https://openalex.org/W2064720525","https://openalex.org/W2111125783"],"abstract_inverted_index":{"HAWQ,":[0,74],"developed":[1],"at":[2],"Pivotal,":[3],"is":[4,52,64,124,131],"a":[5,17,33],"massively":[6],"parallel":[7],"processing":[8],"SQL":[9,54,59],"engine":[10],"sitting":[11],"on":[12,38,61,83],"top":[13],"of":[14,19,73],"HDFS.":[15],"As":[16],"hybrid":[18],"MPP":[20],"database":[21],"and":[22,36,46,56,104,106],"Hadoop,":[23,62],"it":[24,51,63],"inherits":[25],"the":[26,39,70,78,93,114,136],"merits":[27],"from":[28],"both":[29],"parties.":[30],"It":[31],"adopts":[32],"layered":[34],"architecture":[35],"relies":[37],"distributed":[40],"file":[41],"system":[42],"for":[43,96],"data":[44,102],"replication":[45],"fault":[47,88],"tolerance.":[48],"In":[49],"addition,":[50],"standard":[53],"compliant,":[55],"unlike":[57],"other":[58],"engines":[60],"fully":[65],"transactional.":[66],"This":[67],"paper":[68],"presents":[69],"novel":[71],"design":[72],"including":[75],"query":[76,115],"processing,":[77],"scalable":[79],"software":[80],"interconnect":[81],"based":[82,101],"UDP":[84],"protocol,":[85],"transaction":[86],"management,":[87],"tolerance,":[89],"read":[90],"optimized":[91],"storage,":[92],"extensible":[94],"framework":[95],"supporting":[97],"various":[98,107],"popular":[99],"Hadoop":[100],"stores":[103],"formats,":[105],"optimization":[108],"choices":[109],"we":[110],"considered":[111],"to":[112],"enhance":[113],"performance.":[116],"The":[117],"extensive":[118],"performance":[119],"study":[120],"shows":[121],"that":[122],"HAWQ":[123],"about":[125],"40x":[126],"faster":[127,134],"than":[128,135],"Stinger,":[129],"which":[130],"reported":[132],"35x-45x":[133],"original":[137],"Hive.":[138]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":9},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":10},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}