{"id":"https://openalex.org/W2740463104","doi":"https://doi.org/10.1145/3105831.3105842","title":"Evaluating SQL-on-Hadoop for Big Data Warehousing on Not-So-Good Hardware","display_name":"Evaluating SQL-on-Hadoop for Big Data Warehousing on Not-So-Good Hardware","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2740463104","doi":"https://doi.org/10.1145/3105831.3105842","mag":"2740463104"},"language":"en","primary_location":{"id":"doi:10.1145/3105831.3105842","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3105831.3105842","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st International Database Engineering & Applications Symposium on - IDEAS 2017","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/1822/46856","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042295020","display_name":"Maribel Yasmina Santos","orcid":"https://orcid.org/0000-0002-3249-6229"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Maribel Yasmina Santos","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100670597","display_name":"Carlos Costa","orcid":"https://orcid.org/0000-0003-0011-6030"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Carlos Costa","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006858340","display_name":"Jo\u00e3o Galv\u00e3o","orcid":"https://orcid.org/0000-0003-4263-8726"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jo\u00e3o Galv\u00e3o","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063401891","display_name":"Carina Andrade","orcid":"https://orcid.org/0000-0001-8783-9412"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Carina Andrade","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014840486","display_name":"Bruno Martinho","orcid":null},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Bruno Augusto Martinho","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078113674","display_name":"Francisca Vale Lima","orcid":null},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Francisca Vale Lima","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101770933","display_name":"Eduarda Costa","orcid":"https://orcid.org/0000-0003-3459-0195"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Eduarda Costa","raw_affiliation_strings":["University of Minho, ALGORITMI Research Centre, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minho, ALGORITMI Research Centre, Portugal","institution_ids":["https://openalex.org/I99682543"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I99682543"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"242","last_page":"252"},"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.9987000226974487,"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.9987000226974487,"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/T11719","display_name":"Data Quality and Management","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.846452534198761},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.7874172925949097},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.772626519203186},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.7456240057945251},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.658476710319519},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5960800647735596},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.545311689376831},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.543448269367218},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.5067837834358215},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4623388648033142},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.33017081022262573},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.24659553170204163},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.22385641932487488},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.11791610717773438},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10017931461334229},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.0928049385547638}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.846452534198761},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.7874172925949097},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.772626519203186},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.7456240057945251},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.658476710319519},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5960800647735596},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.545311689376831},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.543448269367218},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.5067837834358215},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4623388648033142},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.33017081022262573},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.24659553170204163},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.22385641932487488},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.11791610717773438},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10017931461334229},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0928049385547638},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3105831.3105842","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3105831.3105842","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st International Database Engineering & Applications Symposium on - IDEAS 2017","raw_type":"proceedings-article"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/46856","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/46856","pdf_url":null,"source":{"id":"https://openalex.org/S4306401240","display_name":"Reposit\u00f3riUM (Universidade do Minho)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I99682543","host_organization_name":"University of Minho","host_organization_lineage":["https://openalex.org/I99682543"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"},{"id":"pmh:oai:repositorium.uminho.pt:1822/46856","is_oa":false,"landing_page_url":"https://hdl.handle.net/1822/46856","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference paper"}],"best_oa_location":{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/46856","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/46856","pdf_url":null,"source":{"id":"https://openalex.org/S4306401240","display_name":"Reposit\u00f3riUM (Universidade do Minho)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I99682543","host_organization_name":"University of Minho","host_organization_lineage":["https://openalex.org/I99682543"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.6600000262260437,"id":"https://metadata.un.org/sdg/9"}],"awards":[{"id":"https://openalex.org/G7406260186","display_name":null,"funder_award_id":"UID/CEC/00319/2013","funder_id":"https://openalex.org/F4320334779","funder_display_name":"Funda\u00e7\u00e3o para a Ci\u00eancia e a Tecnologia"}],"funders":[{"id":"https://openalex.org/F4320334779","display_name":"Funda\u00e7\u00e3o para a Ci\u00eancia e a Tecnologia","ror":"https://ror.org/00snfqn58"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W33602388","https://openalex.org/W37241258","https://openalex.org/W170528110","https://openalex.org/W1494137514","https://openalex.org/W1507516418","https://openalex.org/W1635892993","https://openalex.org/W1969489002","https://openalex.org/W1993892970","https://openalex.org/W2038412523","https://openalex.org/W2048672894","https://openalex.org/W2055637560","https://openalex.org/W2058288679","https://openalex.org/W2063364984","https://openalex.org/W2075069743","https://openalex.org/W2080092502","https://openalex.org/W2087177601","https://openalex.org/W2094231001","https://openalex.org/W2105947650","https://openalex.org/W2106625078","https://openalex.org/W2109574129","https://openalex.org/W2119528150","https://openalex.org/W2119738171","https://openalex.org/W2136425171","https://openalex.org/W2146068062","https://openalex.org/W2149140091","https://openalex.org/W2159128662","https://openalex.org/W2171094780","https://openalex.org/W2394680079","https://openalex.org/W2460071091","https://openalex.org/W2500920028","https://openalex.org/W2589424763","https://openalex.org/W4236121275","https://openalex.org/W6643464274","https://openalex.org/W6982145247"],"related_works":["https://openalex.org/W2558523485","https://openalex.org/W4379407450","https://openalex.org/W2895375519","https://openalex.org/W1602107463","https://openalex.org/W2267922067","https://openalex.org/W2184771611","https://openalex.org/W2183669956","https://openalex.org/W2800290888","https://openalex.org/W3087159364","https://openalex.org/W4381745637"],"abstract_inverted_index":{"Big":[0,20,30,141],"Data":[1,21,31,142],"is":[2,23,61],"currently":[3],"conceptualized":[4],"as":[5,25],"data":[6],"whose":[7],"volume,":[8],"variety":[9],"or":[10],"velocity":[11],"impose":[12],"significant":[13],"difficulties":[14],"in":[15,114,138],"traditional":[16],"techniques":[17],"and":[18,46,73,136,146],"technologies.":[19],"Warehousing":[22],"emerging":[24],"a":[26,55,86],"new":[27],"concept":[28],"for":[29,140],"analytics.":[32],"In":[33],"this":[34,79,126],"context,":[35],"SQL-on-Hadoop":[36,95,139],"systems":[37,96,113],"increased":[38],"notoriety,":[39],"providing":[40],"Structured":[41],"Query":[42],"Language":[43],"(SQL)":[44],"interfaces":[45],"interactive":[47],"queries":[48],"on":[49,54,69],"Hadoop.":[50],"A":[51],"benchmark":[52,124],"based":[53],"denormalized":[56],"version":[57],"of":[58,67,78,85,89,103,111],"the":[59,65,82,109],"TPC-H":[60],"used":[62],"to":[63,99,107],"compare":[64],"performance":[66],"Hive":[68,100],"Tez,":[70],"Spark,":[71],"Presto":[72],"Drill.":[74],"Some":[75],"key":[76],"contributions":[77],"work":[80],"include:":[81],"direct":[83],"comparison":[84],"vast":[87],"set":[88],"technologies;":[90],"unlike":[91],"previous":[92],"scientific":[93],"works,":[94],"were":[97],"connected":[98],"tables":[101],"instead":[102],"raw":[104],"files;":[105],"allow":[106],"understand":[108],"behaviour":[110],"these":[112,123],"scenarios":[115],"with":[116],"ever-increasing":[117],"requirements,":[118],"but":[119],"not-so-good":[120],"hardware.":[121],"Besides":[122],"results,":[125],"paper":[127],"also":[128],"makes":[129],"available":[130],"interesting":[131],"findings":[132],"regarding":[133],"an":[134],"architecture":[135],"infrastructure":[137],"Warehousing,":[143],"helping":[144],"practitioners":[145],"fostering":[147],"future":[148],"research.":[149]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}