{"id":"https://openalex.org/W2611763149","doi":"https://doi.org/10.1109/tcc.2017.2700842","title":"Efficiently Translating Complex SQL Query to MapReduce Jobflow on Cloud","display_name":"Efficiently Translating Complex SQL Query to MapReduce Jobflow on Cloud","publication_year":2017,"publication_date":"2017-05-03","ids":{"openalex":"https://openalex.org/W2611763149","doi":"https://doi.org/10.1109/tcc.2017.2700842","mag":"2611763149"},"language":"en","primary_location":{"id":"doi:10.1109/tcc.2017.2700842","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcc.2017.2700842","pdf_url":null,"source":{"id":"https://openalex.org/S2492498579","display_name":"IEEE Transactions on Cloud Computing","issn_l":"2168-7161","issn":["2168-7161","2372-0018"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Cloud Computing","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/A5063565261","display_name":"Zhiang Wu","orcid":"https://orcid.org/0000-0002-0591-1861"},"institutions":[{"id":"https://openalex.org/I137056471","display_name":"Nanjing University of Finance and Economics","ror":"https://ror.org/031y8am81","country_code":"CN","type":"education","lineage":["https://openalex.org/I137056471"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhiang Wu","raw_affiliation_strings":["Jiangsu Provincial Key Laboratory of E-Business, School of Information Engineering, Nanjing University of Finance and Economics, Nanjing, China"],"raw_orcid":"https://orcid.org/0000-0002-0591-1861","affiliations":[{"raw_affiliation_string":"Jiangsu Provincial Key Laboratory of E-Business, School of Information Engineering, Nanjing University of Finance and Economics, Nanjing, China","institution_ids":["https://openalex.org/I137056471"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084604918","display_name":"Aibo Song","orcid":"https://orcid.org/0000-0003-4447-7305"},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Aibo Song","raw_affiliation_strings":["School of Computer Science and Engineering, Southeast University, Nanjing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Southeast University, Nanjing, China","institution_ids":["https://openalex.org/I76569877"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060815634","display_name":"Jie Cao","orcid":"https://orcid.org/0000-0002-9942-3243"},"institutions":[{"id":"https://openalex.org/I137056471","display_name":"Nanjing University of Finance and Economics","ror":"https://ror.org/031y8am81","country_code":"CN","type":"education","lineage":["https://openalex.org/I137056471"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jie Cao","raw_affiliation_strings":["Jiangsu Provincial Key Laboratory of E-Business, School of Information Engineering, Nanjing University of Finance and Economics, Nanjing, China"],"raw_orcid":"https://orcid.org/0000-0002-9942-3243","affiliations":[{"raw_affiliation_string":"Jiangsu Provincial Key Laboratory of E-Business, School of Information Engineering, Nanjing University of Finance and Economics, Nanjing, China","institution_ids":["https://openalex.org/I137056471"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045275291","display_name":"Junzhou Luo","orcid":"https://orcid.org/0000-0001-7518-4367"},"institutions":[{"id":"https://openalex.org/I76569877","display_name":"Southeast University","ror":"https://ror.org/04ct4d772","country_code":"CN","type":"education","lineage":["https://openalex.org/I76569877"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Junzhou Luo","raw_affiliation_strings":["School of Computer Science and Engineering, Southeast University, Nanjing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Southeast University, Nanjing, China","institution_ids":["https://openalex.org/I76569877"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100388597","display_name":"Lu Zhang","orcid":"https://orcid.org/0000-0002-0385-2327"},"institutions":[{"id":"https://openalex.org/I137056471","display_name":"Nanjing University of Finance and Economics","ror":"https://ror.org/031y8am81","country_code":"CN","type":"education","lineage":["https://openalex.org/I137056471"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lu Zhang","raw_affiliation_strings":["Jiangsu Provincial Key Laboratory of E-Business, School of Information Engineering, Nanjing University of Finance and Economics, Nanjing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Jiangsu Provincial Key Laboratory of E-Business, School of Information Engineering, Nanjing University of Finance and Economics, Nanjing, China","institution_ids":["https://openalex.org/I137056471"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.5192,"has_fulltext":false,"cited_by_count":44,"citation_normalized_percentile":{"value":0.86833046,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":"8","issue":"2","first_page":"508","last_page":"517"},"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.9998000264167786,"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.9998000264167786,"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/T10715","display_name":"Distributed and Parallel Computing Systems","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/T11986","display_name":"Scientific Computing and Data Management","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"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.9111369848251343},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7922345399856567},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6732819080352783},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6686009764671326},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5383025407791138},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4929778575897217},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4490507245063782},{"id":"https://openalex.org/keywords/programming-paradigm","display_name":"Programming paradigm","score":0.4484184980392456},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.4479694068431854},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3798556625843048},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.32613039016723633},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.21284911036491394}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9111369848251343},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7922345399856567},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6732819080352783},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6686009764671326},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5383025407791138},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4929778575897217},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4490507245063782},{"id":"https://openalex.org/C34165917","wikidata":"https://www.wikidata.org/wiki/Q188267","display_name":"Programming paradigm","level":2,"score":0.4484184980392456},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.4479694068431854},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3798556625843048},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.32613039016723633},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21284911036491394},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tcc.2017.2700842","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcc.2017.2700842","pdf_url":null,"source":{"id":"https://openalex.org/S2492498579","display_name":"IEEE Transactions on Cloud Computing","issn_l":"2168-7161","issn":["2168-7161","2372-0018"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Cloud Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8","score":0.5899999737739563}],"awards":[{"id":"https://openalex.org/G2330287594","display_name":"\u878d\u5408\u60c5\u5883\u4fe1\u606f\u7684\u591a\u76ee\u6807\u793e\u4f1a\u5316\u5546\u52a1\u63a8\u8350\u7cfb\u7edf\u7814\u7a76","funder_award_id":"71372188","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2672715682","display_name":null,"funder_award_id":"91646204","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3810807517","display_name":"\u5de5\u4e1a\u4e92\u8054\u7f51\u4f53\u7cfb\u7ed3\u6784\u53ca\u5173\u952e\u6280\u672f\u7814\u7a76","funder_award_id":"61632008","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4129350947","display_name":"\u8d85\u5927\u89c4\u6a21\u590d\u6742\u7f51\u7edc\u793e\u533a\u62bd\u53d6\u3001\u6f14\u5316\u53ca\u5e94\u7528\u7814\u7a76","funder_award_id":"71571093","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4239191906","display_name":"\u4e91\u73af\u5883\u4e0b\u9762\u5411\u5927\u6570\u636e\u5e76\u884c\u8ba1\u7b97\u7684\u5de5\u4f5c\u6d41\u6267\u884c\u4f18\u5316\u7814\u7a76","funder_award_id":"61370207","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7447526626","display_name":null,"funder_award_id":"2016YFB1000901","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"},{"id":"https://openalex.org/G8152319438","display_name":null,"funder_award_id":"61320106007","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8751288866","display_name":null,"funder_award_id":"2013B01035","funder_id":"https://openalex.org/F4320323157","funder_display_name":"National Center for International Joint Research on E-Business Information Processing"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320323157","display_name":"National Center for International Joint Research on E-Business Information Processing","ror":"https://ror.org/031y8am81"},{"id":"https://openalex.org/F4320335777","display_name":"National Key Research and Development Program of China","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W1575324001","https://openalex.org/W1991271936","https://openalex.org/W1993892970","https://openalex.org/W1997159848","https://openalex.org/W2013344760","https://openalex.org/W2023116290","https://openalex.org/W2035543557","https://openalex.org/W2043099794","https://openalex.org/W2070600700","https://openalex.org/W2075620950","https://openalex.org/W2083854694","https://openalex.org/W2098935637","https://openalex.org/W2099601885","https://openalex.org/W2100830825","https://openalex.org/W2103337291","https://openalex.org/W2119400430","https://openalex.org/W2125775320","https://openalex.org/W2126547925","https://openalex.org/W2130305366","https://openalex.org/W2131975293","https://openalex.org/W2154138844","https://openalex.org/W2172220707","https://openalex.org/W2173213060","https://openalex.org/W2294316975","https://openalex.org/W2296349066","https://openalex.org/W2400669547","https://openalex.org/W2912802084","https://openalex.org/W4239429564","https://openalex.org/W6671592849","https://openalex.org/W6679815717","https://openalex.org/W6712807959","https://openalex.org/W6758383543"],"related_works":["https://openalex.org/W2429057255","https://openalex.org/W2187546663","https://openalex.org/W148745890","https://openalex.org/W4389670110","https://openalex.org/W2611942503","https://openalex.org/W2378211422","https://openalex.org/W4315621326","https://openalex.org/W2899790217","https://openalex.org/W2598865957","https://openalex.org/W2517841089"],"abstract_inverted_index":{"MapReduce":[0,43,79,152,162],"is":[1,48],"a":[2,22,42,70,120,147,159],"widely-used":[3],"programming":[4],"model":[5,150],"in":[6],"cloud":[7,58],"environment":[8],"for":[9,151],"parallel":[10],"processing":[11],"large-scale":[12],"data":[13],"sets.":[14],"The":[15],"combination":[16],"of":[17,66,72,122,158,182],"the":[18,52,64,67,77,156,178],"high-level":[19],"language":[20],"with":[21],"SQL-to-MapReduce":[23,94],"translator":[24],"allows":[25],"programmers":[26],"to":[27,50,154],"code":[28],"using":[29],"SQL-like":[30],"declarative":[31],"language,":[32],"so":[33],"that":[34],"each":[35],"program":[36],"can":[37],"afterwards":[38],"be":[39],"complied":[40],"into":[41,141],"jobflow":[44],"automatically.":[45],"This":[46],"way":[47],"helpful":[49],"narrow":[51],"gap":[53],"between":[54],"non-professional":[55],"users":[56],"and":[57,60,113,132,139,167,180],"platforms,":[59],"thus":[61],"significantly":[62],"improve":[63],"usability":[65],"cloud.":[68],"Although":[69],"number":[71],"translators":[73],"have":[74],"been":[75],"developed,":[76],"auto-generated":[78,164],"programs":[80],"still":[81],"suffered":[82],"from":[83],"extremely":[84],"inefficiency.":[85],"In":[86],"this":[87],"paper,":[88],"we":[89],"present":[90],"an":[91],"efficient":[92,161],"Cost-Aware":[93],"Translator":[95],"(CAT).":[96],"CAT":[97,142],"has":[98],"two":[99,105],"notable":[100],"features.":[101],"First,":[102],"it":[103,145],"defines":[104],"intra-SQL":[106],"correlations:":[107],"Generalized":[108],"Job":[109],"Flow":[110],"Correlation":[111,115],"(GJFC)":[112],"Input":[114],"(IC),":[116],"based":[117],"on":[118,174],"which":[119],"set":[121],"looser":[123],"merging":[124,135,169],"rules":[125],"are":[126,137],"introduced.":[127],"Thus,":[128],"both":[129],"Top-Down":[130],"(TD)":[131],"Bottom-Up":[133],"(BU)":[134],"strategies":[136],"proposed":[138],"integrated":[140],"simultaneously.":[143],"Second,":[144],"adopts":[146],"cost":[148],"estimation":[149],"jobflows":[153,163],"guide":[155],"selection":[157],"more":[160],"by":[165],"TD":[166],"BU":[168],"strategies.":[170],"Finally,":[171],"comparative":[172],"experiments":[173],"TPC-H":[175],"benchmark":[176],"demonstrate":[177],"effectiveness":[179],"scalability":[181],"CAT.":[183]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":25},{"year":2021,"cited_by_count":14},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}