Building the Data Warehouse,3rd Edition
Building the Data Warehouse,3rd Edition
Schema versioning in data warehouses: enabling cross-version querying via schema augmentation
Data & Knowledge Engineering - Special issue: WIDM 2004
Deciding the physical implementation of ETL workflows
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
A method for the mapping of conceptual designs to logical blueprints for ETL processes
Decision Support Systems
An MDA approach for the development of data warehouses
Decision Support Systems
Graceful database schema evolution: the PRISM workbench
Proceedings of the VLDB Endowment
Design Metrics for Data Warehouse Evolution
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Defining ETL worfklows using BPMN and BPEL
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Principles for an ETL Benchmark
Performance Evaluation and Benchmarking
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Design science methodology: principles and practice
Proceedings of the 32nd ACM/IEEE International Conference on Software Engineering - Volume 2
Information and Software Technology
Leveraging business process models for ETL design
ER'10 Proceedings of the 29th international conference on Conceptual modeling
GEM: requirement-driven generation of ETL and multidimensional conceptual designs
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Easy and effective parallel programmable ETL
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
A model-driven framework for ETL process development
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
Ontology-Driven conceptual design of ETL processes using graph transformations
Journal on Data Semantics XIII
Policy-Regulated management of ETL evolution
Journal on Data Semantics XIII
BPMN-based conceptual modeling of ETL processes
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
| Hi-index | 0.00 |
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.