A generic and customizable framework for the design of ETL scenarios
| dc.contributor.author | Vassiliadis, P. | en |
| dc.contributor.author | Simitsis, A. | en |
| dc.contributor.author | Georgantas, P. | en |
| dc.contributor.author | Terrovitis, M. | en |
| dc.contributor.author | Skiadopoulos, S. | en |
| dc.date.accessioned | 2015-11-24T17:01:12Z | |
| dc.date.available | 2015-11-24T17:01:12Z | |
| dc.identifier.issn | 0306-4379 | - |
| dc.identifier.uri | https://olympias.lib.uoi.gr/jspui/handle/123456789/10887 | |
| dc.rights | Default Licence | - |
| dc.subject | data warehousing | en |
| dc.subject | etl | en |
| dc.title | A generic and customizable framework for the design of ETL scenarios | en |
| heal.abstract | 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. (c) 2004 Elsevier B.V. All rights reserved. | en |
| heal.access | campus | - |
| heal.fullTextAvailability | TRUE | - |
| heal.identifier.primary | Doi 10.1016/J.Is.2004.11.002 | - |
| heal.journalName | Information Systems | en |
| heal.journalType | peer reviewed | - |
| heal.language | en | - |
| heal.publicationDate | 2005 | - |
| heal.recordProvider | Πανεπιστήμιο Ιωαννίνων. Σχολή Θετικών Επιστημών. Τμήμα Μηχανικών Ηλεκτρονικών Υπολογιστών και Πληροφορικής | el |
| heal.type | journalArticle | - |
| heal.type.el | Άρθρο Περιοδικού | el |
| heal.type.en | Journal article | en |
Αρχεία
Φάκελος/Πακέτο αδειών
1 - 1 of 1
Φόρτωση...
- Ονομα:
- license.txt
- Μέγεθος:
- 1.74 KB
- Μορφότυπο:
- Item-specific license agreed upon to submission
- Περιγραφή: