Abstract
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.
This work was partially supported by MIUR co-funded project NeP4B (http://www. dbgroup.unimo.it/nep4b) and LISEA Laboratory (Italy, Emilia-Romagna Region -PRRIITT, measure 3.4).
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
IBM data warehouse manager. Technical Report. IBM, http://www-3.ibm.com/software/data/db2/datawarehouse/
Oracle database data warehousing guide 11g release 1 (11.1). Technical Report Oracle, http://www.oracle.com/pls/db111/portal.portal_db?selected=6
SQL Server 2005 Integration Services (SSIS). Technical Report. Microsoft, http://technet.microsoft.com/en-us/sqlserver/bb331782.aspx
Beneventano, D., Bergamaschi, S., Guerra, F., Vincini, M.: Synthesizing an integrated ontology. IEEE Internet Computing, 42–51 (September-October 2003)
Bergamaschi, S., Po, L., Sorrentino, S.: Automatic annotation in data integration systems. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2007, Part I. LNCS, vol. 4805, pp. 27–28. Springer, Heidelberg (2007)
Bergamaschi, S., Sartori, C., Guerra, F., Orsini, M.: Extracting relevant attribute values for improved search. IEEE Internet Computing 11(5), 26–35 (2007)
Eckerson, W., White, C.: Evaluating ETL and data integration platforms. Technical Report. The Data Warehousing Institute (2003)
Luján-Mora, S., Vassiliadis, P., Trujillo, J.: Data mapping diagrams for data warehouse design with UML. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 191–204. Springer, Heidelberg (2004)
Skoutas, D., Simitsis, A.: Ontology-based conceptual design of ETL processes for both structured and semi-structured data. Int. J. Semantic Web Inf. Syst. 3(4), 1–24 (2007)
Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., Skiadopoulos, S.: A generic and customizable framework for the design of ETL scenarios. Inf. Syst. 30(7), 492–525 (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bergamaschi, S., Guerra, F., Orsini, M., Sartori, C., Vincini, M. (2009). An ETL Tool Based on Semantic Analysis of Schemata and Instances. In: Velásquez, J.D., Ríos, S.A., Howlett, R.J., Jain, L.C. (eds) Knowledge-Based and Intelligent Information and Engineering Systems. KES 2009. Lecture Notes in Computer Science(), vol 5712. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-04592-9_8
Download citation
DOI: https://doi.org/10.1007/978-3-642-04592-9_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-04591-2
Online ISBN: 978-3-642-04592-9
eBook Packages: Computer ScienceComputer Science (R0)