Reference Hub

This research has been cited in:

Article
A domain-specific language for managing ETL processesPeerJ Computer Science10.7717/peerj-cs.1835
Chapter
A Domain-Specific Language for ETL Patterns Specification in Data Warehousing SystemsProgress in Artificial Intelligence10.1007/978-3-319-23485-4_60
Chapter
From Conceptual to Logical ETL Design Using BPMN and Relational AlgebraBig Data Analytics and Knowledge Discovery10.1007/978-3-030-27520-4_21
Article
Data generator for evaluating ETL process qualityInformation Systems10.1016/j.is.2016.04.005
Conference
Modeling and Supporting ETL Processes via a Pattern-Oriented, Task-Reusable Framework2014 IEEE 26th International Conference on Tools with Artificial Intelligence10.1109/ICTAI.2014.145
Chapter
An XML Interchange Format for ETL ModelsNew Trends in Databases and Information Systems10.1007/978-3-030-30278-8_42
Conference
Role of Machine Learning in ETL AutomationProceedings of the 21st International Conference on Distributed Computing and Networking10.1145/3369740.3372778
Chapter
Data Integration Process Automation Using Machine Learning: Issues and SolutionMachine Learning for Data Science Handbook10.1007/978-3-031-24628-9_3
Article
A Semantic Transformation Methodology for the Secondary Use of Observational Healthcare Data in Postmarketing Safety StudiesFrontiers in Pharmacology10.3389/fphar.2018.00435
Chapter
Automatic Generation of ETL Physical Systems from BPMN Conceptual ModelsModel and Data Engineering10.1007/978-3-319-23781-7_19
Article
Detecting Constraints in Supply Chain Reengineering Projects: Case Study of Data and Process Integration in a Hospital PharmacyIFAC-PapersOnLine10.1016/j.ifacol.2015.06.066
Article
Reference Modeling for Data Analysis: The BIRD ApproachInternational Journal of Cooperative Information Systems10.1142/S0218843016500064
Article
Frequent patterns in ETL workflows: An empirical approachData & Knowledge Engineering10.1016/j.datak.2017.08.004
Conference
BijouxProceedings of the 17th International Workshop on Data Warehousing and OLAP10.1145/2666158.2666183
Article
Data Warehousing Process Modeling from Classical Approaches to New Trends: Main Features and ComparisonsData10.3390/data7080113
Conference
A knowledge-based approach for quality-aware ETL process2015 6th International Conference on Information Systems and Economic Intelligence (SIIE)10.1109/ISEI.2015.7358731
Article
Design and implementation of ETL processes using BPMN and relational algebraData & Knowledge Engineering10.1016/j.datak.2020.101837
Chapter
A Systematic Literature Review on Big Data Extraction, Transformation and Loading (ETL)Intelligent Computing10.1007/978-3-030-80126-7_24
Article
Incremental Consolidation of Data-Intensive Multi-FlowsIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2016.2515609
Conference
A Framework for User-Centered Declarative ETLProceedings of the 17th International Workshop on Data Warehousing and OLAP10.1145/2666158.2666178
Chapter
Simple Star SchemasData Warehousing and Analytics10.1007/978-3-030-81979-8_2
Article
Automated credit assessment framework using ETL process and machine learningInnovations in Systems and Software Engineering10.1007/s11334-022-00522-x
Article
LOD for Data Warehouses: Managing the Ecosystem Co-EvolutionInformation10.3390/info9070174
Chapter
Extraction, Transformation, and LoadingEncyclopedia of Database Systems10.1007/978-1-4614-8265-9_158
Conference
Migrating to Big Data: Contextual Challenges for Data-driven Success2023 10th IEEE Uttar Pradesh Section International Conference on Electrical, Electronics and Computer Engineering (UPCON)10.1109/UPCON59197.2023.10434722
Chapter
Using a Domain-Specific Language to Enrich ETL SchemasNew Trends in Databases and Information Systems10.1007/978-3-319-23201-0_4
Conference
Modeling a secure cloud data warehouse with SoaML2015 11th International Conference on Information Assurance and Security (IAS)10.1109/ISIAS.2015.7492745
Article
On the specification of extract, transform, and load patterns behavior: A domain‐specific language approachExpert Systems10.1111/exsy.12168
Conference
A data warehouse model for quicker and less expensive implementationProceedings of the 2nd International Conference on Intelligent and Innovative Computing Applications10.1145/3415088.3415116
Chapter
IntroductionData Warehousing and Analytics10.1007/978-3-030-81979-8_1
Article
A New Approach for Conceptual Extraction-Transformation-Loading Process ModelingInternational Journal of Ambient Computing and Intelligence10.4018/IJACI.2019010102

A BPMN-Based Design and Maintenance Framework for ETL Processes

Zineb El Akkaoui, Esteban Zimányi, Jose-Norberto Mazón, Juan Trujillo

Source Title: International Journal of Data Warehousing and Mining (IJDWM)9(3)

ISSN: 1548-3924|EISSN: 1548-3932|EISBN13: 9781466634558|DOI: 10.4018/jdwm.2013070103

Cite Article Cite Article

MLA

El Akkaoui, Zineb, et al. "A BPMN-Based Design and Maintenance Framework for ETL Processes." IJDWM vol.9, no.3 2013: pp.46-72. http://doi.org/10.4018/jdwm.2013070103

APA

El Akkaoui, Z., Zimányi, E., Mazón, J., & Trujillo, J. (2013). A BPMN-Based Design and Maintenance Framework for ETL Processes. International Journal of Data Warehousing and Mining (IJDWM), 9(3), 46-72. http://doi.org/10.4018/jdwm.2013070103

Chicago

El Akkaoui, Zineb, et al. "A BPMN-Based Design and Maintenance Framework for ETL Processes," International Journal of Data Warehousing and Mining (IJDWM) 9, no.3: 46-72. http://doi.org/10.4018/jdwm.2013070103

Export Reference

Favorite Full-Issue Download

View Full Text HTML

View Full Text PDF

Abstract

Business Intelligence (BI) applications require the design, implementation, and maintenance of processes that extract, transform, and load suitable data for analysis. The development of these processes (known as ETL) is an inherently complex problem that is typically costly and time consuming. In a previous work, the authors have proposed a vendor-independent language for reducing the design complexity due to disparate ETL languages tailored to specific design tools with steep learning curves. Nevertheless, the designer still faces two major issues during the development of ETL processes: (i) how to implement the designed processes in an executable language, and (ii) how to maintain the implementation when the organization data infrastructure evolves. In this paper, the authors propose a model-driven framework that provides automatic code generation capability and ameliorate maintenance support of our ETL language. They present a set of model-to-text transformations able to produce code for different ETL commercial tools as well as model-to-model transformations that automatically update the ETL models with the aim of supporting the maintenance of the generated code according to data source evolution. A demonstration using an example is conducted as an initial validation to show that the framework covering modeling, code generation and maintenance could be used in practice.

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.

Username or email: *

Password: *

Forgot individual login password?

Create individual account

A BPMN-Based Design and Maintenance Framework for ETL Processes

MLA

APA

Chicago

Export Reference

Abstract

Request Access