{"id":"https://openalex.org/W2103008995","doi":"https://doi.org/10.1109/iceei.2011.6021806","title":"Study of localized data cleansing process for ETL performance improvement in independent datamart","display_name":"Study of localized data cleansing process for ETL performance improvement in independent datamart","publication_year":2011,"publication_date":"2011-07-01","ids":{"openalex":"https://openalex.org/W2103008995","doi":"https://doi.org/10.1109/iceei.2011.6021806","mag":"2103008995"},"language":"en","primary_location":{"id":"doi:10.1109/iceei.2011.6021806","is_oa":false,"landing_page_url":"https://doi.org/10.1109/iceei.2011.6021806","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 International Conference on Electrical Engineering and Informatics","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/A5097314710","display_name":"Fivien Nur Savitri","orcid":null},"institutions":[{"id":"https://openalex.org/I134635517","display_name":"Bandung Institute of Technology","ror":"https://ror.org/00apj8t60","country_code":"ID","type":"education","lineage":["https://openalex.org/I134635517"]}],"countries":["ID"],"is_corresponding":true,"raw_author_name":"Fivien Nur Savitri","raw_affiliation_strings":["Data and Software Engineering Research Group, Institut Teknologi Bandung (ITB), Bandung, Indonesia","Data and Software Engineering Research Group, Sekolah Teknik Elektro dan Informatika (STEI), Institut Teknologi Bandung (ITB), Jln. Ganesha no. 10, Indonesia"],"affiliations":[{"raw_affiliation_string":"Data and Software Engineering Research Group, Institut Teknologi Bandung (ITB), Bandung, Indonesia","institution_ids":["https://openalex.org/I134635517"]},{"raw_affiliation_string":"Data and Software Engineering Research Group, Sekolah Teknik Elektro dan Informatika (STEI), Institut Teknologi Bandung (ITB), Jln. Ganesha no. 10, Indonesia","institution_ids":["https://openalex.org/I134635517"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062519973","display_name":"Hira Laksmiwati","orcid":null},"institutions":[{"id":"https://openalex.org/I134635517","display_name":"Bandung Institute of Technology","ror":"https://ror.org/00apj8t60","country_code":"ID","type":"education","lineage":["https://openalex.org/I134635517"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Hira Laksmiwati","raw_affiliation_strings":["Data and Software Engineering Research Group, Institut Teknologi Bandung (ITB), Bandung, Indonesia","Data and Software Engineering Research Group, Sekolah Teknik Elektro dan Informatika (STEI), Institut Teknologi Bandung (ITB), Jln. Ganesha no. 10, Indonesia"],"affiliations":[{"raw_affiliation_string":"Data and Software Engineering Research Group, Institut Teknologi Bandung (ITB), Bandung, Indonesia","institution_ids":["https://openalex.org/I134635517"]},{"raw_affiliation_string":"Data and Software Engineering Research Group, Sekolah Teknik Elektro dan Informatika (STEI), Institut Teknologi Bandung (ITB), Jln. Ganesha no. 10, Indonesia","institution_ids":["https://openalex.org/I134635517"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5097314710"],"corresponding_institution_ids":["https://openalex.org/I134635517"],"apc_list":null,"apc_paid":null,"fwci":0.7002,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.73098881,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9993000030517578,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9993000030517578,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9976999759674072,"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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9836999773979187,"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/data-cleansing","display_name":"Data cleansing","score":0.9468978047370911},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7967451810836792},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7671300172805786},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.592997133731842},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5692471265792847},{"id":"https://openalex.org/keywords/raw-data","display_name":"Raw data","score":0.5646342039108276},{"id":"https://openalex.org/keywords/data-processing","display_name":"Data processing","score":0.48814186453819275},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.44854894280433655},{"id":"https://openalex.org/keywords/data-source","display_name":"Data source","score":0.44582194089889526},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3925658166408539},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.26223069429397583},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1681327521800995},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.09932714700698853}],"concepts":[{"id":"https://openalex.org/C42199009","wikidata":"https://www.wikidata.org/wiki/Q1172378","display_name":"Data cleansing","level":4,"score":0.9468978047370911},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7967451810836792},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7671300172805786},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.592997133731842},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5692471265792847},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.5646342039108276},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.48814186453819275},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.44854894280433655},{"id":"https://openalex.org/C2983685735","wikidata":"https://www.wikidata.org/wiki/Q5227355","display_name":"Data source","level":2,"score":0.44582194089889526},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3925658166408539},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.26223069429397583},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1681327521800995},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.09932714700698853},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"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/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/iceei.2011.6021806","is_oa":false,"landing_page_url":"https://doi.org/10.1109/iceei.2011.6021806","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 International Conference on Electrical Engineering and Informatics","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":12,"referenced_works":["https://openalex.org/W57116089","https://openalex.org/W166457893","https://openalex.org/W1486051045","https://openalex.org/W1520290879","https://openalex.org/W1592607370","https://openalex.org/W1604131870","https://openalex.org/W1997841190","https://openalex.org/W1999557921","https://openalex.org/W2098614373","https://openalex.org/W2261180036","https://openalex.org/W2350573227","https://openalex.org/W6962297110"],"related_works":["https://openalex.org/W2135633991","https://openalex.org/W2598589960","https://openalex.org/W2373231791","https://openalex.org/W2084395052","https://openalex.org/W2792375448","https://openalex.org/W2101710041","https://openalex.org/W3024941504","https://openalex.org/W2053247611","https://openalex.org/W3031304557","https://openalex.org/W2382384372"],"abstract_inverted_index":{"Datawarehouse":[0],"practitioners":[1],"are":[2],"thinking":[3],"that":[4,30,85,170,200],"the":[5,38,92,96,107,150,163,172,187],"biggest":[6],"efforts":[7],"to":[8,36,106],"build":[9],"datawarehouse":[10,44,164,192],"nowadays":[11],"lies":[12],"on":[13,23,121,184],"ETL":[14,20,41,93,100,188],"processing.":[15],"The":[16,61],"complexity":[17],"of":[18,40,53,63,99,109,203,216,221],"workload":[19,39,97,190],"processing":[21,42,94,101,139,189],"depend":[22],"various":[24],"and":[25,69,90,111,129,177,219],"hetegeroneous":[26],"data":[27,55,71,75,115,127,142,152,205,213,223],"source":[28,56,72,143,153],"profile":[29,144],"will":[31,88,102,146,159,195],"be":[32,79,103,147,160,182],"collected.":[33],"A":[34,50],"study":[35],"decrease":[37],"in":[43,73,149,191],"development":[45,165,193],"stages":[46,194],"has":[47,58,117,132],"been":[48,59,118,133],"developed.":[49],"new":[51],"concept":[52],"localized":[54,74,110,113],"cleansing":[57,116,128,138,208],"proposed.":[60],"consideration":[62,87],"inconsistent,":[64],"non":[65,112],"formal,":[66],"expected":[67,84],"existing":[68],"duplicated":[70],"source's":[76],"profiles":[77],"should":[78],"locally":[80,207],"identified.":[81],"It":[82,135,155,167,197],"is":[83,136,168,198],"this":[86,122,157],"lighten":[89],"shorten":[91],"so":[95],"performance":[98],"better.An":[104],"investigation":[105,123],"impact":[108],"heterogenious":[114],"done.":[119],"Based":[120],"an":[124],"automatic":[125],"localised":[126],"integration":[130],"system":[131],"defined.":[134],"a":[137],"for":[140,212],"each":[141],"which":[145],"executed":[148],"transactional":[151],"site.":[154],"means":[156],"process":[158,176,180,209],"done":[161],"before":[162],"stages.":[166],"found":[169],"if":[171],"Automatic":[173],"Data":[174,178],"Cleansing":[175],"Integrator":[179],"could":[181],"carry":[183],"sequentially":[185],"then":[186],"decrease.":[196],"proven":[199],"decreasing":[201],"number":[202],"raw":[204],"through":[206],"became":[210],"significant":[211],"with":[214],"lack":[215,220],"integrity":[217],"constraint":[218],"format":[222],"checking":[224],"procedures.":[225]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}