In this paper we propose a system supporting the semi-automatic definition of inter-attribute mappings and transformation functions used as an ETL tool in a data warehouse project. The tool supports both schema level analysis, exploited for the mapping definitions amongst the data sources and the data warehouse, and instance level operations, exploited for defining transformation functions that integrate data coming from multiple sources in a common representation. Our proposal couples and extends the functionalities of two previously developed systems: the MOMIS integration system and the RELEVANT data analysis system. © 2009 Springer Berlin Heidelberg.
CITATION STYLE
Bergamaschi, S., Guerra, F., Orsini, M., Sartori, C., & Vincini, M. (2009). An ETL tool based on semantic analysis of schemata and instances. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 5712 LNAI, pp. 58–65). https://doi.org/10.1007/978-3-642-04592-9_8
Mendeley helps you to discover research relevant for your work.