A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling

Neepa Biswas, Samiran Chattapadhyay, Gautam Mahapatra, Santanu Chatterjee and Kartick Chandra Mondal
Additional contact information
Neepa Biswas: Department of Information Technology, Jadavpur University, Kolkata, India
Samiran Chattapadhyay: Department of Information Technology, Jadavpur University, Kolkata, India
Gautam Mahapatra: DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India
Santanu Chatterjee: DRDO, Ministry of Defence, Govt of India, Research Centre Imarat, Kurmalguda, India
Kartick Chandra Mondal: Department of Information Technology, Jadavpur University, Kolkata, India

International Journal of Ambient Computing and Intelligence (IJACI), 2019, vol. 10, issue 1, 30-45

Abstract: 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.

Date: 2019
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/IJACI.2019010102 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jaci00:v:10:y:2019:i:1:p:30-45

Access Statistics for this article

International Journal of Ambient Computing and Intelligence (IJACI) is currently edited by Nilanjan Dey

More articles in International Journal of Ambient Computing and Intelligence (IJACI) from IGI Global
Bibliographic data for series maintained by Journal Editor ().