{"id":"https://openalex.org/W4403864921","doi":"https://doi.org/10.1109/qrs-c63300.2024.00013","title":"Comprehensive Functional ETL Testing Methodologies for Real-World Data","display_name":"Comprehensive Functional ETL Testing Methodologies for Real-World Data","publication_year":2024,"publication_date":"2024-07-01","ids":{"openalex":"https://openalex.org/W4403864921","doi":"https://doi.org/10.1109/qrs-c63300.2024.00013"},"language":"en","primary_location":{"id":"doi:10.1109/qrs-c63300.2024.00013","is_oa":false,"landing_page_url":"https://doi.org/10.1109/qrs-c63300.2024.00013","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 24th International Conference on Software Quality, Reliability, and Security Companion (QRS-C)","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/A5001028658","display_name":"Hajar Homayouni","orcid":"https://orcid.org/0000-0001-8898-9498"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Hajar Homayouni","raw_affiliation_strings":["Department of Computer Sciencc"],"affiliations":[{"raw_affiliation_string":"Department of Computer Sciencc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039500631","display_name":"Maryam Pourebadi","orcid":null},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California, San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Maryam Mary Pourebadi","raw_affiliation_strings":["University of California,Department of Computer Science,San Diego"],"affiliations":[{"raw_affiliation_string":"University of California,Department of Computer Science,San Diego","institution_ids":["https://openalex.org/I36258959"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114444282","display_name":"Steven T. Nguyen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Steven T. Nguyen","raw_affiliation_strings":["Department of Computer Sciencc"],"affiliations":[{"raw_affiliation_string":"Department of Computer Sciencc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035739274","display_name":"Mohammad Hashemi","orcid":"https://orcid.org/0000-0002-9585-6607"},"institutions":[{"id":"https://openalex.org/I4210107186","display_name":"Hamedan University of Technology","ror":"https://ror.org/01hgb6e08","country_code":"IR","type":"education","lineage":["https://openalex.org/I4210107186"]}],"countries":["IR"],"is_corresponding":false,"raw_author_name":"Mohammad Hashemi","raw_affiliation_strings":["Hamedan University of Technology,Department of Computer Engineering"],"affiliations":[{"raw_affiliation_string":"Hamedan University of Technology,Department of Computer Engineering","institution_ids":["https://openalex.org/I4210107186"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047638523","display_name":"Hossein Shirazi","orcid":"https://orcid.org/0000-0002-2721-0628"},"institutions":[{"id":"https://openalex.org/I26538001","display_name":"San Diego State University","ror":"https://ror.org/0264fdx42","country_code":"US","type":"education","lineage":["https://openalex.org/I26538001"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hossein Shirazi","raw_affiliation_strings":["Management Information Systems, San Diego State University"],"affiliations":[{"raw_affiliation_string":"Management Information Systems, San Diego State University","institution_ids":["https://openalex.org/I26538001"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5001028658"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7305,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.73655829,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"11","last_page":"20"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.3492000102996826,"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"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.3492000102996826,"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.7335847616195679},{"id":"https://openalex.org/keywords/real-world-data","display_name":"Real world data","score":0.4517589509487152},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38589727878570557},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.24900951981544495}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7335847616195679},{"id":"https://openalex.org/C3020493868","wikidata":"https://www.wikidata.org/wiki/Q55631277","display_name":"Real world data","level":2,"score":0.4517589509487152},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38589727878570557},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.24900951981544495}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/qrs-c63300.2024.00013","is_oa":false,"landing_page_url":"https://doi.org/10.1109/qrs-c63300.2024.00013","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 24th International Conference on Software Quality, Reliability, and Security Companion (QRS-C)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":58,"referenced_works":["https://openalex.org/W1539477445","https://openalex.org/W1541535863","https://openalex.org/W1759994076","https://openalex.org/W1982806687","https://openalex.org/W1984566373","https://openalex.org/W2026701697","https://openalex.org/W2028861106","https://openalex.org/W2040753378","https://openalex.org/W2065199439","https://openalex.org/W2065697793","https://openalex.org/W2072764742","https://openalex.org/W2095345875","https://openalex.org/W2100537916","https://openalex.org/W2100974707","https://openalex.org/W2101109743","https://openalex.org/W2104227001","https://openalex.org/W2111890927","https://openalex.org/W2129598390","https://openalex.org/W2131576956","https://openalex.org/W2135841285","https://openalex.org/W2137130182","https://openalex.org/W2163922914","https://openalex.org/W2171311095","https://openalex.org/W2407969335","https://openalex.org/W2419017369","https://openalex.org/W2501244995","https://openalex.org/W2518786827","https://openalex.org/W2592377938","https://openalex.org/W2613480438","https://openalex.org/W2742495185","https://openalex.org/W2760451156","https://openalex.org/W2769094978","https://openalex.org/W2790247697","https://openalex.org/W2833324965","https://openalex.org/W2838566359","https://openalex.org/W2911200746","https://openalex.org/W2951120644","https://openalex.org/W2963536745","https://openalex.org/W2980728347","https://openalex.org/W2983029853","https://openalex.org/W3008391147","https://openalex.org/W3035598637","https://openalex.org/W3136173905","https://openalex.org/W3146147323","https://openalex.org/W3146259567","https://openalex.org/W3162922567","https://openalex.org/W3188582079","https://openalex.org/W3207556990","https://openalex.org/W4234913640","https://openalex.org/W4239954780","https://openalex.org/W4241492760","https://openalex.org/W4254182148","https://openalex.org/W4294791790","https://openalex.org/W4306955484","https://openalex.org/W4319443025","https://openalex.org/W4324070700","https://openalex.org/W4367591276","https://openalex.org/W6607508199"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"In":[0],"today's":[1],"data-driven":[2],"enterprises,":[3],"data":[4,27,73,96,131],"warehouses":[5],"are":[6,53],"crucial":[7],"for":[8,12],"aggregating":[9],"diverse":[10],"datasets":[11],"analysis":[13],"and":[14,31,59,75,86,100,109,115,133],"research.":[15],"The":[16,102],"ETL":[17,38,50,67,121],"(Extract,":[18],"Transform,":[19],"Load)":[20],"process":[21],"is":[22],"central":[23],"to":[24,55],"this,":[25],"involving":[26],"extraction,":[28],"integration,":[29],"cleansing,":[30],"loading":[32],"into":[33,72],"the":[34,43,89,124],"warehouse.":[35],"Challenges":[36],"in":[37,88,107,127],"can":[39],"cause":[40],"inaccuracies,":[41],"diminishing":[42],"value":[44],"of":[45,120],"high-quality":[46],"source":[47,99],"data.":[48],"Robust":[49],"testing":[51,68,122],"methodologies":[52],"essential":[54],"ensure":[56],"correct":[57],"implementation":[58],"efficient":[60],"execution.":[61],"This":[62],"paper":[63],"surveys":[64],"existing":[65],"functional":[66],"approaches,":[69],"categorizing":[70],"them":[71],"quality":[74,79],"balancing":[76,93],"tests.":[77],"Data":[78,128],"tests":[80,94],"identify":[81],"issues":[82],"like":[83],"missing":[84],"values":[85],"outliers":[87],"target":[90],"data,":[91],"while":[92],"verify":[95],"consistency":[97],"between":[98],"target.":[101],"research":[103,113],"highlights":[104],"unresolved":[105],"challenges":[106],"completeness":[108],"scalability,":[110],"proposes":[111],"future":[112],"directions,":[114],"includes":[116],"an":[117],"empirical":[118],"study":[119],"on":[123],"Our":[125],"World":[126],"warehouse,":[129],"identifying":[130],"disparities":[132],"abnormalities.":[134]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1}],"updated_date":"2025-12-27T23:08:20.325037","created_date":"2025-10-10T00:00:00"}