{"id":"https://openalex.org/W2897286457","doi":"https://doi.org/10.4018/ijaci.2019010102","title":"A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling","display_name":"A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling","publication_year":2018,"publication_date":"2018-10-08","ids":{"openalex":"https://openalex.org/W2897286457","doi":"https://doi.org/10.4018/ijaci.2019010102","mag":"2897286457"},"language":"en","primary_location":{"id":"doi:10.4018/ijaci.2019010102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijaci.2019010102","pdf_url":null,"source":{"id":"https://openalex.org/S51041755","display_name":"International Journal of Ambient Computing and Intelligence","issn_l":"1941-6237","issn":["1941-6237","1941-6245"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Ambient Computing and Intelligence","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/A5041849222","display_name":"Neepa Biswas","orcid":"https://orcid.org/0000-0003-2790-1768"},"institutions":[{"id":"https://openalex.org/I170979836","display_name":"Jadavpur University","ror":"https://ror.org/02af4h012","country_code":"IN","type":"education","lineage":["https://openalex.org/I170979836"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Neepa Biswas","raw_affiliation_strings":["Department of Information Technology, Jadavpur University, Kolkata, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information Technology, Jadavpur University, Kolkata, India","institution_ids":["https://openalex.org/I170979836"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030384977","display_name":"Samiran Chattapadhyay","orcid":null},"institutions":[{"id":"https://openalex.org/I170979836","display_name":"Jadavpur University","ror":"https://ror.org/02af4h012","country_code":"IN","type":"education","lineage":["https://openalex.org/I170979836"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Samiran Chattapadhyay","raw_affiliation_strings":["Department of Information Technology, Jadavpur University, Kolkata, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information Technology, Jadavpur University, Kolkata, India","institution_ids":["https://openalex.org/I170979836"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080671730","display_name":"Gautam Mahapatra","orcid":null},"institutions":[{"id":"https://openalex.org/I4210138561","display_name":"Research Centre Imarat","ror":"https://ror.org/03mw5zj47","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1340206300","https://openalex.org/I4210138561","https://openalex.org/I4210150591"]},{"id":"https://openalex.org/I4210150591","display_name":"Ministry of Defence","ror":"https://ror.org/03wejsv15","country_code":"IN","type":"government","lineage":["https://openalex.org/I4210150591"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Gautam Mahapatra","raw_affiliation_strings":["DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India","institution_ids":["https://openalex.org/I4210150591","https://openalex.org/I4210138561"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021634467","display_name":"Santanu Chatterjee","orcid":"https://orcid.org/0000-0002-5139-7605"},"institutions":[{"id":"https://openalex.org/I4210138561","display_name":"Research Centre Imarat","ror":"https://ror.org/03mw5zj47","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1340206300","https://openalex.org/I4210138561","https://openalex.org/I4210150591"]},{"id":"https://openalex.org/I4210150591","display_name":"Ministry of Defence","ror":"https://ror.org/03wejsv15","country_code":"IN","type":"government","lineage":["https://openalex.org/I4210150591"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Santanu Chatterjee","raw_affiliation_strings":["DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India","institution_ids":["https://openalex.org/I4210150591","https://openalex.org/I4210138561"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056512425","display_name":"Kartick Chandra Mondal","orcid":"https://orcid.org/0000-0003-3647-5799"},"institutions":[{"id":"https://openalex.org/I170979836","display_name":"Jadavpur University","ror":"https://ror.org/02af4h012","country_code":"IN","type":"education","lineage":["https://openalex.org/I170979836"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Kartick Chandra Mondal","raw_affiliation_strings":["Department of Information Technology, Jadavpur University, Kolkata, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information Technology, Jadavpur University, Kolkata, India","institution_ids":["https://openalex.org/I170979836"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.8792,"has_fulltext":false,"cited_by_count":20,"citation_normalized_percentile":{"value":0.93023422,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":"10","issue":"1","first_page":"30","last_page":"45"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9976999759674072,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9976999759674072,"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/T11719","display_name":"Data Quality and Management","score":0.9976000189781189,"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"}},{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9966999888420105,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"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.8603516817092896},{"id":"https://openalex.org/keywords/systems-modeling-language","display_name":"Systems Modeling Language","score":0.8582853674888611},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4835352897644043},{"id":"https://openalex.org/keywords/model-transformation","display_name":"Model transformation","score":0.4798440635204315},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4728938639163971},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.4666431248188019},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.45468732714653015},{"id":"https://openalex.org/keywords/conceptualization","display_name":"Conceptualization","score":0.44794726371765137},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.4477262794971466},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.4218139350414276},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.4213055968284607},{"id":"https://openalex.org/keywords/modeling-language","display_name":"Modeling language","score":0.4187500774860382},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3996221721172333},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.32940205931663513},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32258182764053345},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2264847457408905},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.20061928033828735}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8603516817092896},{"id":"https://openalex.org/C21285288","wikidata":"https://www.wikidata.org/wiki/Q2117885","display_name":"Systems Modeling Language","level":4,"score":0.8582853674888611},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4835352897644043},{"id":"https://openalex.org/C2779791154","wikidata":"https://www.wikidata.org/wiki/Q258040","display_name":"Model transformation","level":3,"score":0.4798440635204315},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4728938639163971},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.4666431248188019},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.45468732714653015},{"id":"https://openalex.org/C90734943","wikidata":"https://www.wikidata.org/wiki/Q17008777","display_name":"Conceptualization","level":2,"score":0.44794726371765137},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.4477262794971466},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.4218139350414276},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.4213055968284607},{"id":"https://openalex.org/C179603123","wikidata":"https://www.wikidata.org/wiki/Q1941921","display_name":"Modeling language","level":3,"score":0.4187500774860382},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3996221721172333},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.32940205931663513},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32258182764053345},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2264847457408905},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20061928033828735},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.0},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijaci.2019010102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijaci.2019010102","pdf_url":null,"source":{"id":"https://openalex.org/S51041755","display_name":"International Journal of Ambient Computing and Intelligence","issn_l":"1941-6237","issn":["1941-6237","1941-6245"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Ambient Computing and Intelligence","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jaci00:v:10:y:2019:i:1:p:30-45","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJACI.2019010102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W126115071","https://openalex.org/W183249055","https://openalex.org/W244402229","https://openalex.org/W1482268585","https://openalex.org/W1510328895","https://openalex.org/W1534626598","https://openalex.org/W1535775113","https://openalex.org/W1541535863","https://openalex.org/W1904112038","https://openalex.org/W1946272765","https://openalex.org/W1964050650","https://openalex.org/W1971518725","https://openalex.org/W1982212058","https://openalex.org/W1982600306","https://openalex.org/W1986562471","https://openalex.org/W1993582687","https://openalex.org/W2008856128","https://openalex.org/W2016432893","https://openalex.org/W2063753658","https://openalex.org/W2072310234","https://openalex.org/W2075518254","https://openalex.org/W2083755493","https://openalex.org/W2104433378","https://openalex.org/W2106345431","https://openalex.org/W2127912974","https://openalex.org/W2146588030","https://openalex.org/W2294510991","https://openalex.org/W2405882596","https://openalex.org/W2756785937","https://openalex.org/W3081818761","https://openalex.org/W4234385538","https://openalex.org/W4244696999","https://openalex.org/W6607508199"],"related_works":["https://openalex.org/W3204384228","https://openalex.org/W4378878120","https://openalex.org/W2041611180","https://openalex.org/W2081287895","https://openalex.org/W2958154519","https://openalex.org/W4327930750","https://openalex.org/W3005887481","https://openalex.org/W4224940935","https://openalex.org/W3143695185","https://openalex.org/W2165548140"],"abstract_inverted_index":{"Erroneous":[0],"or":[1],"incomplete":[2],"data":[3,16,23,33],"generated":[4],"from":[5,17],"various":[6],"sources":[7,18],"can":[8,49],"have":[9],"direct":[10],"impact":[11],"in":[12,110],"business":[13],"analysis.":[14],"Extracted":[15],"need":[19],"to":[20,28,103,131,147,156],"load":[21],"into":[22],"warehouse":[24],"after":[25],"required":[26],"transformation":[27],"reduce":[29],"error":[30],"and":[31,70,107,153,155],"minimize":[32],"loss.":[34],"This":[35],"process":[36,83,109],"is":[37,78,101,123,146,171],"also":[38],"known":[39],"as":[40],"Extraction-Transformation-Loading":[41],"(ETL).":[42],"High-level":[43],"view":[44],"of":[45,55,62,64,96,113,160,167],"the":[46,60,119,133,143,149,158,161,168],"system":[47,65,98,114],"activities":[48],"be":[50],"visualized":[51],"by":[52,84,125,137,173],"conceptual":[53],"modeling":[54,76,152],"ETL":[56,82],"process.":[57],"It":[58],"provides":[59],"advantage":[61],"pre-identification":[63],"error,":[66],"cost":[67],"minimization,":[68],"scope":[69],"risk":[71],"assessment":[72],"etc.":[73],"A":[74],"new":[75],"approach":[77,130,170],"proposed":[79,162],"for":[80],"conceptualization":[81],"using":[85,138,174],"a":[86,127,175],"standard":[87],"Systems":[88],"Modeling":[89],"Language":[90],"(SysML).":[91],"For":[92],"handling":[93],"increasing":[94],"complexity":[95],"any":[97],"model,":[99],"it":[100],"preferable":[102],"go":[104],"through":[105],"verification":[106],"validation":[108,136],"early":[111],"stage":[112],"development.":[115],"In":[116],"this":[117],"article,":[118],"authors'":[120,169],"previous":[121],"work":[122],"extended":[124],"presenting":[126],"MBSE":[128],"based":[129],"automate":[132],"SysML":[134,163],"model's":[135],"No":[139],"Magic":[140],"simulator.":[141],"Here,":[142],"main":[144],"objective":[145],"overcome":[148],"gap":[150],"between":[151],"simulation":[154],"examine":[157],"performance":[159],"model.":[164],"The":[165],"usefulness":[166],"exhibited":[172],"use":[176],"case":[177],"scenario.":[178]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":5}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}