A logical language for data and knowledge bases
A logical language for data and knowledge bases
Improving OLTP data quality using data warehouse mechanisms
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Efficient resumption of interrupted warehouse loads
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
AJAX: an extensible data cleaning tool
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Software Engineering: A Practitioner's Approach
Software Engineering: A Practitioner's Approach
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Professional SQL Server 2000 Data Warehousing with Analysis Services
Professional SQL Server 2000 Data Warehousing with Analysis Services
Conceptual modeling for ETL processes
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
The Challenge of Process Data Warehousing
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Potter's Wheel: An Interactive Data Cleaning System
Proceedings of the 27th International Conference on Very Large Data Bases
A Meta Model for Structured Workflows Supporting Workflow Transformations
ADBIS '02 Proceedings of the 6th East European Conference on Advances in Databases and Information Systems
A Transactional Approach to Parallel Data Warehouse Maintenance
DaWaK 2000 Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery
Data Integration under Integrity Constraints
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
A Transactional Model for Data Warehouse Maintenance
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
Conceptual Modelling of WorkFlows
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
An Interactive Framework for Data Cleaning
An Interactive Framework for Data Cleaning
Communications of the ACM - Service-oriented computing
IBIS: semantic data integration at work
CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering
A framework for the design of ETL scenarios
CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering
On business process model transformations
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Mapping conceptual to logical models for ETL processes
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Journal of Systems and Software
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
Optimizing data warehouse loading procedures for enabling useful-time data warehousing
IDEAS '09 Proceedings of the 2009 International Database Engineering & Applications Symposium
Modeling of secure data extraction in ETL processes using UML 2.0
AsiaMS '07 Proceedings of the IASTED Asian Conference on Modelling and Simulation
Automatic generation of ETL processes from conceptual models
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Representation of conceptual ETL designs in natural language using Semantic Web technology
Data & Knowledge Engineering
Leveraging business process models for ETL design
ER'10 Proceedings of the 29th international conference on Conceptual modeling
Hi-index | 0.09 |
Extraction-transformation-loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we delve into the logical design of ETL scenarios and provide a generic and customizable framework in order to support the DW designer in his task. First, we present a metamodel particularly customized for the definition of ETL activities. We follow a workflow-like approach, where the output of a certain activity can either be stored persistently or passed to a subsequent activity. Also, we employ a declarative database programming language, LDL, to define the semantics of each activity. The metamodel is generic enough to capture any possible ETL activity. Nevertheless, in the pursuit of higher reusability and flexibility, we specialize the set of our generic metamodel constructs with a palette of frequently used ETL activities, which we call templates. Moreover, in order to achieve a uniform extensibility mechanism for this library of built-ins, we have to deal with specific language issues. Therefore, we also discuss the mechanics of template instantiation to concrete activities. The design concepts that we introduce have been implemented in a tool, ARKTOS II, which is also presented.