Home

Arktos: A Tool For Data Cleaning and Transformation in Data Warehouse Environments

Mon, 10/16/2006 - 14:34 — massmann
Authors: 
Vassiliadis, Panos; Vagena, Zografoula; Skiadopoulos, Spiros; Karayannidis, Nikos; Sellis, Timos
Author: 
Vassiliadis, P
Vagena, Z
Skiadopoulos, S
Karayannidis, N
Sellis, T
Year: 
2000
Venue: 
IEEE Data Engineering Bulletin, 23(4):42--47
URL: 
www.acm.org/sigs/sigmod/disc/disc01/out/websites/deb_december/sellis.pdf
Citations: 
28
Citations range: 
10 - 49
AttachmentSize
Vassiliadis2000ArktosAToolForData.pdf33.95 KB

Extraction-Transformation-Loading (ETL) and Data Cleaning tools are pieces of software responsible for the extraction of data from several sources, their cleaning, customization and insertion into a data warehouse. To deal with the complexity and efficiency of the transformation and cleaning tasks we have developed a tool, namely ARKTOS, capable of modeling and executing practical scenarios, by providing explicit primitives for the capturing of common tasks. ARKTOS provides three ways to describe such a scenario, including a graphical point-and-click front end and two declarative languages: XADL (an XML variant), which is more verbose and easy to read and SADL (an SQL-like language) which has a quite compact syntax and is, thus, easier for authoring.