{"id":"https://openalex.org/W3006994813","doi":"https://doi.org/10.1109/bigdata47090.2019.9006412","title":"General-Purpose vs. Specialized Data Analytics Systems: A Game of ML & SQL Thrones","display_name":"General-Purpose vs. Specialized Data Analytics Systems: A Game of ML & SQL Thrones","publication_year":2019,"publication_date":"2019-12-01","ids":{"openalex":"https://openalex.org/W3006994813","doi":"https://doi.org/10.1109/bigdata47090.2019.9006412","mag":"3006994813"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata47090.2019.9006412","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata47090.2019.9006412","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5032810499","display_name":"Evdokia Kassela","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Evdokia Kassela","raw_affiliation_strings":["CSLab, National Technical University of Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CSLab, National Technical University of Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038342882","display_name":"Nikodimos Provatas","orcid":"https://orcid.org/0009-0000-0931-1479"},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Nikodimos Provatas","raw_affiliation_strings":["CSLab, National Technical University of Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CSLab, National Technical University of Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004421134","display_name":"Ioannis Konstantinou","orcid":"https://orcid.org/0000-0002-7142-8106"},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Ioannis Konstantinou","raw_affiliation_strings":["CSLab, National Technical University of Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CSLab, National Technical University of Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020678151","display_name":"Avrilia Floratou","orcid":"https://orcid.org/0009-0007-5760-8657"},"institutions":[{"id":"https://openalex.org/I4210087053","display_name":"Microsoft (Germany)","ror":"https://ror.org/001dd4s60","country_code":"DE","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210087053"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Avrilia Floratou","raw_affiliation_strings":["Cloud and Information Services Lab, Microsoft, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cloud and Information Services Lab, Microsoft, US","institution_ids":["https://openalex.org/I4210087053"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023526161","display_name":"Nectarios Koziris","orcid":"https://orcid.org/0000-0002-4890-8427"},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Nectarios Koziris","raw_affiliation_strings":["CSLab, National Technical University of Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CSLab, National Technical University of Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"317","last_page":"326"},"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.9994999766349792,"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.9994999766349792,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9969000220298767,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.9945999979972839,"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/analytics","display_name":"Analytics","score":0.7362237572669983},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7357810735702515},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7193370461463928},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41173624992370605},{"id":"https://openalex.org/keywords/data-analysis","display_name":"Data analysis","score":0.4110291600227356},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.32955944538116455},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.1390276849269867}],"concepts":[{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.7362237572669983},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7357810735702515},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7193370461463928},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41173624992370605},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.4110291600227356},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.32955944538116455},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.1390276849269867}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata47090.2019.9006412","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata47090.2019.9006412","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W1806891645","https://openalex.org/W1985624015","https://openalex.org/W1993892970","https://openalex.org/W2010279913","https://openalex.org/W2041517243","https://openalex.org/W2060393849","https://openalex.org/W2083842231","https://openalex.org/W2097484305","https://openalex.org/W2106625078","https://openalex.org/W2114303224","https://openalex.org/W2123866731","https://openalex.org/W2166706236","https://openalex.org/W2189465200","https://openalex.org/W2190012392","https://openalex.org/W2271840356","https://openalex.org/W2433128352","https://openalex.org/W2567162135","https://openalex.org/W2620485168","https://openalex.org/W2784053383","https://openalex.org/W2949762319","https://openalex.org/W6638520917","https://openalex.org/W6665801690","https://openalex.org/W6684249991","https://openalex.org/W6687322159","https://openalex.org/W6694517276"],"related_works":["https://openalex.org/W4226266853","https://openalex.org/W4210252074","https://openalex.org/W4390482427","https://openalex.org/W3092201768","https://openalex.org/W2796632413","https://openalex.org/W2740083192","https://openalex.org/W2794907032","https://openalex.org/W2508885301","https://openalex.org/W4255802207","https://openalex.org/W4385267788"],"abstract_inverted_index":{"Over":[0],"the":[1,28,110,129,143],"past":[2],"decade,":[3],"a":[4,54,61,94],"plethora":[5],"of":[6,27,81,97,114,145],"systems":[7,38,80],"have":[8],"emerged":[9],"to":[10,43,52,68,141],"support":[11,69],"data":[12,29,56],"analytics":[13,57],"in":[14,71],"various":[15],"domains":[16],"such":[17],"as":[18],"SQL":[19,101],"and":[20,65,87,89,100,112,117],"machine":[21,98],"learning,":[22],"among":[23],"others.":[24],"In":[25,74],"each":[26,82,115],"analysis":[30,108],"domains,":[31],"there":[32],"are":[33],"now":[34],"many":[35],"different":[36,72],"specialized":[37],"that":[39,59,128],"leverage":[40],"domain-specific":[41],"optimizations":[42],"efficiently":[44],"execute":[45],"their":[46,91],"workloads.":[47,102],"An":[48],"alternative":[49],"approach":[50],"is":[51],"build":[53],"general-purpose":[55],"system":[58,116],"uses":[60],"common":[62],"execution":[63],"engine":[64],"programming":[66],"model":[67],"workloads":[70],"domains.":[73],"this":[75,134],"work,":[76],"we":[77],"choose":[78],"representative":[79],"class":[83],"(Spark,":[84],"TensorFlow,":[85],"Presto":[86],"Hive)":[88],"benchmark":[90],"performance":[92,144],"on":[93,109],"wide":[95],"variety":[96],"learning":[99],"We":[103,126],"perform":[104],"an":[105],"extensive":[106],"comparative":[107],"strengths":[111],"limitations":[113],"highlight":[118],"major":[119,130],"areas":[120],"for":[121,123,139],"improvement":[122],"all":[124],"systems.":[125,147],"believe":[127],"insights":[131],"gained":[132],"from":[133],"study":[135],"will":[136],"be":[137],"useful":[138],"developers":[140],"improve":[142],"these":[146]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2019,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}