Abstract:
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.
Note: This material is presented to ensure timely dissemination of scholarly and technical work. Copyright and all rights therein are retained by authors or by other copyright holders. All persons copying this information are expected to adhere to the terms and constraints invoked by each author's copyright. In most cases, these works may not be reposted without the explicit permission of the copyright holder.