Welcome to the InfoSci Platform
Reference Hub16
A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling

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

Neepa Biswas, Samiran Chattapadhyay, Gautam Mahapatra, Santanu Chatterjee, Kartick Chandra Mondal
Copyright: © 2019 |Volume: 10 |Issue: 1 |Pages: 16
ISSN: 1941-6237|EISSN: 1941-6245|EISBN13: 9781522565062|DOI: 10.4018/IJACI.2019010102
Cite Article Cite Article

MLA

Biswas, Neepa, et al. "A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling." IJACI vol.10, no.1 2019: pp.30-45. http://doi.org/10.4018/IJACI.2019010102

APA

Biswas, N., Chattapadhyay, S., Mahapatra, G., Chatterjee, S., & Mondal, K. C. (2019). A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling. International Journal of Ambient Computing and Intelligence (IJACI), 10(1), 30-45. http://doi.org/10.4018/IJACI.2019010102

Chicago

Biswas, Neepa, et al. "A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling," International Journal of Ambient Computing and Intelligence (IJACI) 10, no.1: 30-45. http://doi.org/10.4018/IJACI.2019010102

Export Reference

Mendeley
Favorite Full-Issue Download

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.