{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T15:46:42Z","timestamp":1781106402646,"version":"3.54.1"},"reference-count":50,"publisher":"IGI Global Scientific Publishing","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019,1,1]]},"abstract":"<p>Erroneous or incomplete data generated from various sources can have direct impact in business analysis. Extracted data from sources need to load into data warehouse after required transformation to reduce error and minimize data loss. This process is also known as Extraction-Transformation-Loading (ETL). High-level view of the system activities can be visualized by conceptual modeling of ETL process. It provides the advantage of pre-identification of system error, cost minimization, scope and risk assessment etc. A new modeling approach is proposed for conceptualization ETL process by using a standard Systems Modeling Language (SysML). For handling increasing complexity of any system model, it is preferable to go through verification and validation process in early stage of system development. In this article, the authors' previous work is extended by presenting a MBSE based approach to automate the SysML model's validation by using No Magic simulator. Here, the main objective is to overcome the gap between modeling and simulation and to examine the performance of the proposed SysML model. The usefulness of the authors' approach is exhibited by using a use case scenario.<\/p>","DOI":"10.4018\/ijaci.2019010102","type":"journal-article","created":{"date-parts":[[2018,10,8]],"date-time":"2018-10-08T13:18:26Z","timestamp":1539004706000},"page":"30-45","source":"Crossref","is-referenced-by-count":18,"title":["A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling"],"prefix":"10.4018","volume":"10","author":[{"given":"Neepa","family":"Biswas","sequence":"first","affiliation":[{"name":"Department of Information Technology, Jadavpur University, Kolkata, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Samiran","family":"Chattapadhyay","sequence":"additional","affiliation":[{"name":"Department of Information Technology, Jadavpur University, Kolkata, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Gautam","family":"Mahapatra","sequence":"additional","affiliation":[{"name":"DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Santanu","family":"Chatterjee","sequence":"additional","affiliation":[{"name":"DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Kartick Chandra","family":"Mondal","sequence":"additional","affiliation":[{"name":"Department of Information Technology, Jadavpur University, Kolkata, India"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"IJACI.2019010102-0","doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z. & Zim\u00e1nyi, E. (2009), Defining ETL worfklows using BPMN and BPEL, In Proceedings of the ACM twelfth International Workshop on data warehousing and OLAP (pp. 41-48). NY: ACM.","DOI":"10.1145\/1651291.1651299"},{"key":"IJACI.2019010102-1","doi-asserted-by":"crossref","unstructured":"Akkaoui, Z. E., Mazon, J. N., Vaisman, A., & Zimanyi, E. (2012). BPMN-based conceptual modeling of ETL processes. In Data Warehousing and Knowledge Discovery. Springer.","DOI":"10.1007\/978-3-642-32584-7_1"},{"key":"IJACI.2019010102-2","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2013070103"},{"key":"IJACI.2019010102-3","doi-asserted-by":"publisher","DOI":"10.1145\/2064676.2064685"},{"key":"IJACI.2019010102-4","unstructured":"Architect, E. (n.d.). Retrieved November 21, 2017, from http:\/\/www.sparxsystems.com\/products\/ea"},{"key":"IJACI.2019010102-5","unstructured":"ATL. (n.d.). ATL - Documentation. Retrieved November 21, 2017, from http:\/\/www.eclipse.org\/atl\/documentation\/"},{"key":"IJACI.2019010102-6","doi-asserted-by":"crossref","unstructured":"Ayhan, S., Pesce, J., Comitz, P., Sweet, D., Bliesner, S., & Gerberick, G. (2013, April). Predictive analytics with aviation big data. In Integrated Communications,Navigation and Surveillance Conference (ICNS). IEEE.","DOI":"10.1109\/ICNSurv.2013.6548556"},{"key":"IJACI.2019010102-7","unstructured":"Barateiro, J., & Galhardas, H. (2005). A survey of data quality tools. Datenbank-Spektrum, 14(15-21), 48."},{"key":"IJACI.2019010102-8","doi-asserted-by":"publisher","DOI":"10.1109\/WSC.2012.6465139"},{"key":"IJACI.2019010102-9","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-23781-7_19"},{"key":"IJACI.2019010102-10","first-page":"242","author":"N.Biswas","year":"2017","journal-title":"SysML Based Conceptual ETL Process Modeling. In International Conference on Computational Intelligence, Communications, and Business Analytics"},{"key":"IJACI.2019010102-11","first-page":"275","article-title":"Abstract conceptual database model approach.","author":"N. E.Cagiltay","year":"2013","journal-title":"Science and Information Conference (SAI)"},{"key":"IJACI.2019010102-12","doi-asserted-by":"publisher","DOI":"10.1016\/j.csi.2011.06.002"},{"key":"IJACI.2019010102-13","unstructured":"Customer Journey Mapping. (n.d.). Retrieved November 21, 2017, from https:\/\/www.visual-paradigm.com\/"},{"key":"IJACI.2019010102-14","doi-asserted-by":"crossref","unstructured":"Ding, L., Kolari, P., Ding, Z., & Avancha, S. (n.d.). Using Ontologies in the Semantic Web: A Survey. In Integrated Series in Information Systems Ontologies (pp. 79-113).","DOI":"10.1007\/978-0-387-37022-4_4"},{"key":"IJACI.2019010102-15","unstructured":"Eckerson, W., & White, C. (2003). Evaluating ETL and data integration platforms. Report of The Data Warehousing Institute."},{"key":"IJACI.2019010102-16","unstructured":"Estefan, J. A. (2007). Survey of model-based systems engineering (MBSE) methodologies. Incose MBSE Focus Group."},{"key":"IJACI.2019010102-17","doi-asserted-by":"publisher","DOI":"10.1109\/SSDM.2004.1311247"},{"key":"IJACI.2019010102-18","author":"S.Friedenthal","year":"2014","journal-title":"A practical guide to SysML: the systems modeling language"},{"key":"IJACI.2019010102-19","unstructured":"FUML. (n.d.). Retrieved November 21, 2017, from http:\/\/www.omg.org\/spec\/FUML\/"},{"key":"IJACI.2019010102-20","article-title":"Introduction to model-based system engineering (MBSE) and SysML","author":"L. E.Hart","year":"2015","journal-title":"Delaware Valley INCOSE Chapter Meeting"},{"key":"IJACI.2019010102-21","article-title":"The SysML modelling language.","volume":"Vol. 9","author":"M.Hause","year":"2006","journal-title":"Fifteenth European Systems Engineering Conference"},{"key":"IJACI.2019010102-22","doi-asserted-by":"publisher","DOI":"10.1109\/ICEBE.2008.71"},{"key":"IJACI.2019010102-23","unstructured":"Inc, N. M. (n.d.). MagicDraw. Retrieved November 21, 2017, from https:\/\/www.nomagic.com\/products\/magicdraw"},{"key":"IJACI.2019010102-24","doi-asserted-by":"publisher","DOI":"10.1177\/0037549714533842"},{"issue":"4","key":"IJACI.2019010102-25","doi-asserted-by":"crossref","first-page":"2557","DOI":"10.37622\/IJAER\/11.4.2016.2557-2559","article-title":"A Technical Comprehensive Survey of ETL Tools.","volume":"11","author":"V. A.Kherdekar","year":"2016","journal-title":"International Journal of Applied Engineering Research"},{"key":"IJACI.2019010102-26","doi-asserted-by":"crossref","unstructured":"Mu\u00f1oz, L., Maz\u00f3n, J. N., Pardillo, J., & Trujillo, J. (2008, November). Modelling ETL processes of data warehouses with UML activity diagrams. In OTM Confederated International Conferences\u201d On the Move to Meaningful Internet Systems\u201d (pp. 44-53). Springer Berlin Heidelberg.","DOI":"10.1007\/978-3-540-88875-8_21"},{"key":"IJACI.2019010102-27","doi-asserted-by":"publisher","DOI":"10.1145\/1651291.1651298"},{"key":"IJACI.2019010102-28","unstructured":"No magic, Inc. (n.d.a). Cameo Simulation Toolkit. Retrieved November 21, 2017, from https:\/\/www.nomagic.com\/product-addons\/magicdraw-addons\/cameo-simulation-toolkit"},{"key":"IJACI.2019010102-29","unstructured":"No magic, Inc. (n.d.b). Other no cost add ons. Retrieved November 21, 2017, from https:\/\/www.nomagic.com\/product-addons\/no-cost-add-ons\/other-no-cost-add-ons"},{"key":"IJACI.2019010102-30","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-34624-8_50"},{"key":"IJACI.2019010102-31","article-title":"ETL standard processes modelling: a novel BPMN approach.","author":"B.Oliveira","year":"2013","journal-title":"5th International Conference on Enterprise Information Systems (ICEIS\u20192013)"},{"key":"IJACI.2019010102-32","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-41366-7_20"},{"key":"IJACI.2019010102-33","unstructured":"OMG. (n.d.a). Retrieved November 21, 2017, from http:\/\/www.omg.org\/spec\/QVT\/1.1"},{"key":"IJACI.2019010102-34","unstructured":"OMG. (n.d.b). Retrieved November 21, 2017, from http:\/\/www.omg.org\/spec\/SyM\/1.0\/"},{"key":"IJACI.2019010102-35","unstructured":"OMG. (n.d.c). OMG SysML Home | OMG Systems Modeling Language. Retrieved November 21, 2017, from http:\/\/www.omgsysml.org\/"},{"key":"IJACI.2019010102-36","unstructured":"Papyrus Modeling environment. (n.d.). Retrieved November 21, 2017, from https:\/\/eclipse.org\/papyrus\/"},{"key":"IJACI.2019010102-37","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2009.08.009"},{"key":"IJACI.2019010102-38","doi-asserted-by":"crossref","unstructured":"Simitsis, A., & Vassiliadis, P. (2003, June). A Methodology for the Conceptual Modeling of ETL Processes. In CAiSE workshops (Vol. 75).","DOI":"10.1145\/583890.583893"},{"key":"IJACI.2019010102-39","doi-asserted-by":"publisher","DOI":"10.1145\/1183512.1183526"},{"key":"IJACI.2019010102-40","doi-asserted-by":"publisher","DOI":"10.4018\/jswis.2007100101"},{"key":"IJACI.2019010102-41","doi-asserted-by":"crossref","first-page":"120","DOI":"10.1007\/978-3-642-03098-7_5","article-title":"Ontology-driven conceptual design of ETL processes using graph transformations.","volume":"XIII","author":"D.Skoutas","year":"2009","journal-title":"Journal on Data Semantics"},{"key":"IJACI.2019010102-42","unstructured":"Snezana, S., & Violeta, M. (2010, June). Business Intelligence tools for statistical data analysis. In 2010 32nd International Conference on Information Technology Interfaces (ITI) (pp. 199-204). IEEE."},{"key":"IJACI.2019010102-43","unstructured":"SysML. (n.d.). Retrieved November 21, 2017, from http:\/\/www.omg.org\/spec\/SysML\/1.4"},{"key":"IJACI.2019010102-44","first-page":"58","article-title":"A Semantic approach towards CWM-based ETL processes.","volume":"8","author":"A. D. H.Thi","year":"2008","journal-title":"Proceedings of I-SEMANTICS"},{"key":"IJACI.2019010102-45","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-39648-2_25"},{"key":"IJACI.2019010102-46","unstructured":"UML. (n.d.). Retrieved November 21, 2017, from http:\/\/www.omg.org\/spec\/UML\/2.5\/"},{"key":"IJACI.2019010102-47","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2009070101"},{"key":"IJACI.2019010102-48","doi-asserted-by":"publisher","DOI":"10.1145\/583890.583893"},{"key":"IJACI.2019010102-49","unstructured":"Weck, O.D. (n.d.). Fundamentals of systems engineering (Lecture Notes). Retrieved November 23, 2017 from https:\/\/ocw.mit.edu\/courses\/aeronautics-and-astronautics\/16-842-fundamentals-of-systems-engineering-fall-2015\/lecture-notes\/"}],"container-title":["International Journal of Ambient Computing and Intelligence"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=216468","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,6]],"date-time":"2022-05-06T19:55:29Z","timestamp":1651866929000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJACI.2019010102"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2019,1,1]]},"references-count":50,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2019,1]]}},"URL":"https:\/\/doi.org\/10.4018\/ijaci.2019010102","relation":{},"ISSN":["1941-6237","1941-6245"],"issn-type":[{"value":"1941-6237","type":"print"},{"value":"1941-6245","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,1,1]]}}}