{"id":"https://openalex.org/W4283071214","doi":"https://doi.org/10.1109/icse-seip55303.2022.9793914","title":"An Empirical Study on Quality Issues of eBay's Big Data SQL Analytics Platform","display_name":"An Empirical Study on Quality Issues of eBay's Big Data SQL Analytics Platform","publication_year":2022,"publication_date":"2022-05-01","ids":{"openalex":"https://openalex.org/W4283071214","doi":"https://doi.org/10.1109/icse-seip55303.2022.9793914"},"language":"en","primary_location":{"id":"doi:10.1109/icse-seip55303.2022.9793914","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icse-seip55303.2022.9793914","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE/ACM 44th International Conference on Software Engineering: Software Engineering in Practice (ICSE-SEIP)","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/A5100565154","display_name":"Feng Zhu","orcid":"https://orcid.org/0009-0008-4999-2780"},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Feng Zhu","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103731665","display_name":"Lijie Xu","orcid":null},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210128818","display_name":"Institute of Software","ror":"https://ror.org/033dfsn42","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210128818"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lijie Xu","raw_affiliation_strings":["State Key Laboratory of Computer Science, Institute of Software, Chinese Academy of Sciences"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Institute of Software, Chinese Academy of Sciences","institution_ids":["https://openalex.org/I4210128818","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039139493","display_name":"Gang Ma","orcid":null},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Gang Ma","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014759800","display_name":"Shuping Ji","orcid":"https://orcid.org/0000-0002-5070-8643"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Shuping Ji","raw_affiliation_strings":["University of Toronto"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100440079","display_name":"Jie Wang","orcid":"https://orcid.org/0000-0002-3772-426X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jie Wang","raw_affiliation_strings":["Ant Technology Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ant Technology Group","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100367433","display_name":"Gang Wang","orcid":"https://orcid.org/0000-0003-0387-2501"},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Gang Wang","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100659999","display_name":"Hongyi Zhang","orcid":"https://orcid.org/0000-0003-3408-2959"},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Hongyi Zhang","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040399161","display_name":"Kun Wan","orcid":null},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Kun Wan","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112482585","display_name":"Mingming Wang","orcid":"https://orcid.org/0000-0001-6053-7449"},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Mingming Wang","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016918782","display_name":"Xingchao Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Xingchao Zhang","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100389609","display_name":"Yuming Wang","orcid":"https://orcid.org/0000-0003-2310-1456"},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Yuming Wang","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100603460","display_name":"Jinping Li","orcid":"https://orcid.org/0000-0002-2628-0376"},"institutions":[{"id":"https://openalex.org/I1321826891","display_name":"eBay (Ireland)","ror":"https://ror.org/02b00s810","country_code":"IE","type":"company","lineage":["https://openalex.org/I1321826891","https://openalex.org/I4210150719"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Jingpin Li","raw_affiliation_strings":["eBay Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"eBay Inc","institution_ids":["https://openalex.org/I1321826891"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"33","last_page":"42"},"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.9994000196456909,"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.9994000196456909,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9940999746322632,"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/T11719","display_name":"Data Quality and Management","score":0.9934999942779541,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7190870046615601},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7120699286460876},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.6957009434700012},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6309896111488342},{"id":"https://openalex.org/keywords/popularity","display_name":"Popularity","score":0.5609378814697266},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.509743869304657},{"id":"https://openalex.org/keywords/empirical-research","display_name":"Empirical research","score":0.5094569325447083},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.5055162906646729},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5013248920440674},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.4719266891479492},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.45937690138816833},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.42841437458992004},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.09686741232872009}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7190870046615601},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7120699286460876},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.6957009434700012},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6309896111488342},{"id":"https://openalex.org/C2780586970","wikidata":"https://www.wikidata.org/wiki/Q1357284","display_name":"Popularity","level":2,"score":0.5609378814697266},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.509743869304657},{"id":"https://openalex.org/C120936955","wikidata":"https://www.wikidata.org/wiki/Q2155640","display_name":"Empirical research","level":2,"score":0.5094569325447083},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.5055162906646729},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5013248920440674},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4719266891479492},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.45937690138816833},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.42841437458992004},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.09686741232872009},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icse-seip55303.2022.9793914","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icse-seip55303.2022.9793914","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE/ACM 44th International Conference on Software Engineering: Software Engineering in Practice (ICSE-SEIP)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6299999952316284}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W1455804204","https://openalex.org/W1540623620","https://openalex.org/W2038412523","https://openalex.org/W2051505342","https://openalex.org/W2106625078","https://openalex.org/W2131975293","https://openalex.org/W2168206938","https://openalex.org/W2241684952","https://openalex.org/W2384569204","https://openalex.org/W2597276661","https://openalex.org/W2930448814","https://openalex.org/W2966880642","https://openalex.org/W2999082198","https://openalex.org/W3020616315","https://openalex.org/W3042605769","https://openalex.org/W3042755891","https://openalex.org/W3099032206","https://openalex.org/W3106731144","https://openalex.org/W3176550827","https://openalex.org/W3195440983","https://openalex.org/W3197025661","https://openalex.org/W4242010563","https://openalex.org/W4254901924","https://openalex.org/W6628700833","https://openalex.org/W6679815717","https://openalex.org/W6684988815","https://openalex.org/W6773234078","https://openalex.org/W6776390964"],"related_works":["https://openalex.org/W2766461310","https://openalex.org/W4247566972","https://openalex.org/W4388692845","https://openalex.org/W3202731209","https://openalex.org/W3211874991","https://openalex.org/W2558523485","https://openalex.org/W4379407450","https://openalex.org/W2905107896","https://openalex.org/W3191926225","https://openalex.org/W2895375519"],"abstract_inverted_index":{"Big":[0],"data":[1,13,76],"SQL":[2,44,77],"analytics":[3,45,78],"platform":[4,46,153],"has":[5,52],"evolved":[6],"as":[7,27,175,177],"the":[8,70,110,136,141],"key":[9],"infrastructure":[10],"for":[11,63,93],"business":[12],"analysis.":[14],"Compared":[15],"with":[16,23,144],"traditional":[17],"costly":[18],"commercial":[19],"RDBMS,":[20],"scalable":[21],"solutions":[22],"open-source":[24,73],"projects,":[25],"such":[26],"SQL-on-Hadoop,":[28],"are":[29,107],"more":[30,64],"popular":[31],"and":[32,103,139,152,160,184],"attractive":[33],"to":[34,109,179],"enter-prises.":[35],"In":[36],"eBay,":[37],"we":[38,120,163],"build":[39],"Carmel,":[40],"a":[41,96,122],"company-wide":[42],"interactive":[43],"based":[47,74],"on":[48,83,126],"Apache":[49],"Spark.":[50],"Carmel":[51],"been":[53],"serving":[54],"thousands":[55],"of":[56,60,72,99,112],"customers":[57],"from":[58,132,157,168],"hundreds":[59],"teams":[61],"globally":[62],"than":[65],"3":[66],"years.":[67],"Meanwhile,":[68],"despite":[69],"popularity":[71],"big":[75],"platforms,":[79],"few":[80],"empirical":[81,124],"studies":[82],"service":[84,100,129],"quality":[85,101,130],"issues":[86,102,131],"(e.g.,":[87],"job":[88],"failure)":[89],"were":[90],"carried":[91],"out":[92],"them.":[94],"However,":[95],"deep":[97],"understanding":[98],"taking":[104],"right":[105],"mitigation":[106],"significant":[108],"ease":[111],"manual":[113],"maintenance":[114],"efforts.":[115],"To":[116],"fill":[117],"this":[118],"gap,":[119],"conduct":[121],"comprehensive":[123],"study":[125],"1,884":[127],"real-word":[128],"Carmel.":[133],"We":[134],"summa-rize":[135],"common":[137],"symptoms":[138],"identify":[140],"root":[142],"causes":[143],"typical":[145],"cases.":[146],"Stakeholders":[147],"including":[148],"system":[149],"developers,":[150],"researchers,":[151],"maintainers":[154],"can":[155],"benefit":[156],"our":[158,172],"findings":[159],"implications.":[161],"Furthermore,":[162],"also":[164],"present":[165],"lessons":[166],"learned":[167],"critical":[169],"cases":[170],"in":[171],"daily":[173],"practice,":[174],"well":[176],"insights":[178],"motivate":[180],"automatic":[181],"tool":[182],"support":[183],"future":[185],"research":[186],"directions.":[187]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}