{"id":"https://openalex.org/W4407086173","doi":"https://doi.org/10.3390/software4010003","title":"The Scalable Detection and Resolution of Data Clumps Using a Modular Pipeline with ChatGPT","display_name":"The Scalable Detection and Resolution of Data Clumps Using a Modular Pipeline with ChatGPT","publication_year":2025,"publication_date":"2025-02-02","ids":{"openalex":"https://openalex.org/W4407086173","doi":"https://doi.org/10.3390/software4010003"},"language":"en","primary_location":{"id":"doi:10.3390/software4010003","is_oa":true,"landing_page_url":"https://doi.org/10.3390/software4010003","pdf_url":"https://www.mdpi.com/2674-113X/4/1/3/pdf?version=1739262030","source":{"id":"https://openalex.org/S4210183365","display_name":"Software","issn_l":"2674-113X","issn":["2674-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://www.mdpi.com/2674-113X/4/1/3/pdf?version=1739262030","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005221446","display_name":"Nils Baumgartner","orcid":"https://orcid.org/0000-0002-0474-8214"},"institutions":[{"id":"https://openalex.org/I170658231","display_name":"Osnabr\u00fcck University","ror":"https://ror.org/04qmmjx98","country_code":"DE","type":"education","lineage":["https://openalex.org/I170658231"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Nils Baumgartner","raw_affiliation_strings":["Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany"],"affiliations":[{"raw_affiliation_string":"Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany","institution_ids":["https://openalex.org/I170658231"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088481468","display_name":"Padma Iyenghar","orcid":"https://orcid.org/0000-0002-1765-3695"},"institutions":[{"id":"https://openalex.org/I170658231","display_name":"Osnabr\u00fcck University","ror":"https://ror.org/04qmmjx98","country_code":"DE","type":"education","lineage":["https://openalex.org/I170658231"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Padma Iyenghar","raw_affiliation_strings":["Innotec GmbH, Hornbergstrasse 45, 70794 Filderstadt, Germany","Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany"],"affiliations":[{"raw_affiliation_string":"Innotec GmbH, Hornbergstrasse 45, 70794 Filderstadt, Germany","institution_ids":[]},{"raw_affiliation_string":"Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany","institution_ids":["https://openalex.org/I170658231"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5097138107","display_name":"Timo Schoemaker","orcid":"https://orcid.org/0009-0006-0379-6616"},"institutions":[{"id":"https://openalex.org/I170658231","display_name":"Osnabr\u00fcck University","ror":"https://ror.org/04qmmjx98","country_code":"DE","type":"education","lineage":["https://openalex.org/I170658231"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Timo Schoemaker","raw_affiliation_strings":["Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany"],"affiliations":[{"raw_affiliation_string":"Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany","institution_ids":["https://openalex.org/I170658231"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041691200","display_name":"Elke Pulverm\u00fcller","orcid":"https://orcid.org/0009-0000-8225-7261"},"institutions":[{"id":"https://openalex.org/I170658231","display_name":"Osnabr\u00fcck University","ror":"https://ror.org/04qmmjx98","country_code":"DE","type":"education","lineage":["https://openalex.org/I170658231"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Elke Pulverm\u00fcller","raw_affiliation_strings":["Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany"],"affiliations":[{"raw_affiliation_string":"Research Group Software Engineering, Institute of Computer Science, Department of Mathematics and Computer Science, University of Osnabr\u00fcck, 49074 Osnabr\u00fcck, Germany","institution_ids":["https://openalex.org/I170658231"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5088481468"],"corresponding_institution_ids":["https://openalex.org/I170658231"],"apc_list":null,"apc_paid":null,"fwci":1.6405,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.8103616,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"4","issue":"1","first_page":"3","last_page":"3"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10273","display_name":"IoT and Edge/Fog Computing","score":0.6604999899864197,"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/T10273","display_name":"IoT and Edge/Fog Computing","score":0.6604999899864197,"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/T11775","display_name":"COVID-19 diagnosis using AI","score":0.6439999938011169,"subfield":{"id":"https://openalex.org/subfields/2741","display_name":"Radiology, Nuclear Medicine and Imaging"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T13650","display_name":"Computational Physics and Python Applications","score":0.5878999829292297,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/modular-design","display_name":"Modular design","score":0.7633128762245178},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.7304950952529907},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6681970357894897},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5829696655273438},{"id":"https://openalex.org/keywords/resolution","display_name":"Resolution (logic)","score":0.5132460594177246},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.44059526920318604},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3213820159435272},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.28045064210891724},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.20669865608215332},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.18813106417655945},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12992310523986816}],"concepts":[{"id":"https://openalex.org/C101468663","wikidata":"https://www.wikidata.org/wiki/Q1620158","display_name":"Modular design","level":2,"score":0.7633128762245178},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.7304950952529907},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6681970357894897},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5829696655273438},{"id":"https://openalex.org/C138268822","wikidata":"https://www.wikidata.org/wiki/Q1051925","display_name":"Resolution (logic)","level":2,"score":0.5132460594177246},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.44059526920318604},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3213820159435272},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.28045064210891724},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20669865608215332},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.18813106417655945},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12992310523986816}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3390/software4010003","is_oa":true,"landing_page_url":"https://doi.org/10.3390/software4010003","pdf_url":"https://www.mdpi.com/2674-113X/4/1/3/pdf?version=1739262030","source":{"id":"https://openalex.org/S4210183365","display_name":"Software","issn_l":"2674-113X","issn":["2674-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:4e6177f36bc046dd9fb427fd9a952da7","is_oa":true,"landing_page_url":"https://doaj.org/article/4e6177f36bc046dd9fb427fd9a952da7","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Software, Vol 4, Iss 1, p 3 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/software4010003","is_oa":true,"landing_page_url":"https://doi.org/10.3390/software4010003","pdf_url":"https://www.mdpi.com/2674-113X/4/1/3/pdf?version=1739262030","source":{"id":"https://openalex.org/S4210183365","display_name":"Software","issn_l":"2674-113X","issn":["2674-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4407086173.pdf","grobid_xml":"https://content.openalex.org/works/W4407086173.grobid-xml"},"referenced_works_count":21,"referenced_works":["https://openalex.org/W2060561050","https://openalex.org/W2082307353","https://openalex.org/W2099535882","https://openalex.org/W2114934058","https://openalex.org/W2142418597","https://openalex.org/W2476305501","https://openalex.org/W2993406914","https://openalex.org/W3020617474","https://openalex.org/W4312245811","https://openalex.org/W4360982447","https://openalex.org/W4386601473","https://openalex.org/W4391872514","https://openalex.org/W4392141948","https://openalex.org/W4394616582","https://openalex.org/W4395452980","https://openalex.org/W4396554430","https://openalex.org/W4396554463","https://openalex.org/W4399203816","https://openalex.org/W4400463001","https://openalex.org/W4401395592","https://openalex.org/W6872098232"],"related_works":["https://openalex.org/W4390608645","https://openalex.org/W4405901645","https://openalex.org/W4394895745","https://openalex.org/W4247566972","https://openalex.org/W2960264696","https://openalex.org/W3090563135","https://openalex.org/W2497432351","https://openalex.org/W4206777497","https://openalex.org/W2910064364","https://openalex.org/W2019887508"],"abstract_inverted_index":{"This":[0],"paper":[1],"explores":[2],"a":[3,10,176],"modular":[4],"pipeline":[5,54,91],"architecture":[6],"that":[7,29,40,89,101],"integrates":[8],"ChatGPT,":[9],"Large":[11],"Language":[12],"Model":[13],"(LLM),":[14],"to":[15,36,49,58,162,171,190],"automate":[16],"the":[17,82,90,113,117,121,146,156,168,191],"detection":[18],"and":[19,44,61,138,178,188],"refactoring":[20,72,118],"of":[21,26,38,123,148,159,194],"data":[22,95],"clumps\u2014a":[23],"prevalent":[24],"type":[25],"code":[27,39,51,183],"smell":[28],"complicates":[30],"software":[31,71,151,173,196],"maintainability.":[32],"Data":[33],"clumps":[34,106,125],"refer":[35],"clusters":[37],"are":[41,107],"often":[42],"repeated":[43],"should":[45],"ideally":[46],"be":[47],"refactored":[48],"improve":[50],"quality.":[52],"The":[53],"leverages":[55],"ChatGPT\u2019s":[56],"capabilities":[57],"understand":[59],"context":[60],"generate":[62],"structured":[63],"outputs,":[64],"making":[65],"it":[66,129],"suitable":[67],"for":[68,181],"addressing":[69,182],"complex":[70],"tasks.":[73],"Through":[74],"systematic":[75],"experimentation,":[76],"our":[77],"study":[78],"not":[79],"only":[80],"addresses":[81],"research":[83],"questions":[84],"outlined":[85],"but":[86,153],"also":[87,130,154],"demonstrates":[88],"can":[92],"accurately":[93],"identify":[94],"clumps,":[96],"particularly":[97],"excelling":[98],"in":[99,150,185,198],"cases":[100],"require":[102],"semantic":[103],"understanding\u2014where":[104],"localized":[105],"embedded":[108],"within":[109],"larger":[110],"codebases.":[111],"While":[112],"solution":[114,180],"significantly":[115],"enhances":[116],"workflow,":[119],"facilitating":[120],"management":[122],"distributed":[124],"across":[126],"multiple":[127],"files,":[128],"presents":[131],"challenges":[132],"such":[133],"as":[134],"occasional":[135],"compiler":[136],"errors":[137],"high":[139],"computational":[140],"costs.":[141],"Feedback":[142],"from":[143],"developers":[144],"underscores":[145],"usefulness":[147],"LLMs":[149],"development":[152],"highlights":[155],"essential":[157],"role":[158],"human":[160],"oversight":[161],"correct":[163],"inaccuracies.":[164],"These":[165],"findings":[166],"demonstrate":[167],"pipeline\u2019s":[169],"potential":[170],"enhance":[172],"maintainability,":[174],"offering":[175],"scalable":[177],"efficient":[179],"smells":[184],"real-world":[186],"projects,":[187],"contributing":[189],"broader":[192],"goal":[193],"enhancing":[195],"maintainability":[197],"large-scale":[199],"projects.":[200]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2025-10-10T00:00:00"}