Authors:
Bruno Oliveira
1
and
Orlando Belo
2
Affiliations:
1
School of Management and Technology and Porto Polytechnic, Portugal
;
2
University of Minho, Portugal
Keyword(s):
Data Warehousing Systems, ETL Conceptual Modeling, ETL Patterns, Domain Specific Language, Ontologies, PL4ETL, ETL Skeletons.
Related
Ontology
Subjects/Areas/Topics:
Artificial Intelligence
;
Business Analytics
;
Cardiovascular Technologies
;
Computing and Telecommunications in Cardiology
;
Data Engineering
;
Data Warehouse Management
;
Decision Support Systems
;
Decision Support Systems, Remote Data Analysis
;
Enterprise Information Systems
;
Health Engineering and Technology Applications
;
Information Systems Analysis and Specification
;
Knowledge Engineering and Ontology Development
;
Knowledge-Based Systems
;
Ontologies and the Semantic Web
;
Ontology Engineering
;
Symbolic Systems
Abstract:
The use of software patterns is a common practice in software design, providing reusable solutions for recurring problems. Patterns represent a general skeleton used to solve common problems, providing a way to share regular practices and reduce the resources needed for implementing software systems. Data warehousing populating processes are a very particular type of software used to migrate data from one or more data sources to a specific data schema used to support decision support activities. The quality of such processes should be guarantee. Otherwise, the final system will deal with data inconsistencies and errors, compromising its suitability to support strategic business decisions. To minimize such problems, we propose a pattern-oriented approach to support ETL lifecycle, from conceptual representation to its execution primitives using a specific commercial tool. An ontology-based meta model it was designed and used for describing patterns internal specification and providing
the means to support and enable its configuration and instantiation using a domain specific language.
(More)