Abstract
Within business intelligence systems (BI systems), ETL (extract, transform and load) processes move numerous data from heterogeneous sources to a data warehouse and become more complex with growing enterprise size. To keep costs and expenditure of time for maintenance and evolution of those systems slight, ETL processes should be documented. A well-documented sys-tem also leads to higher transparency regarding the origin and processing of data, which increases the system’s acceptance by business users. However, the preparation of high quality software documentation is sophisticated and there-fore it usually only takes place in the design or development phase of BI systems. To ensure that the documentation is always updated, automated generation is advantageous. The paper at hand presents the research prototype CAWE DW Documenter for automated configurable ETL documentation generation.
This research has been partly funded by the European Social Fund and the Federal State of Saxony, Germany.
A proof-of-concept video – which demonstrates a former research state using the example of the open source ETL modeling tool Pentaho Data Integration – is available at http://www.cawe.eu/demo/20120127-POC-CAWE-DW-Documenter.wmv
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Vercellis, C.: Business Intelligence: data mining and optimization for decision making. Wiley, Hoboken (2009)
Forward, A., Lethbridge, T.C.: The relevance of software documentation, tools and technologies: a survey. In: Proceedings of the 2002 ACM Symposium on Document Engineering (DocEng 2002), pp. 26–33. ACM Press, New York (2002)
Gluchowski, P., Hofmann, M., Frieder, J., Krawatzeck, R., Müller, A.: Business-Intelligence-Umfrage 2011: Softwaregestütztes Lebenszyklusmanagement und aktuelles Dokumentationsgeschehen für Business-Intelligence-Systeme (2011), http://www.qucosa.de/ recherche/frontdoor/?tx_slubopus4frontend[id]=urn:nbn:de:bsz:ch1-qucosa-75452
Hofmann, M., Müller, A., Jacobi, F., Krawatzeck, R.: Umfrage 2011: ’Dokumentation von Business-Intelligence-Systemen’ - Ergebnisse und Auswertung. In: Tagungsband der Multikonferenz Wirtschaftsinformatik 2012 (MKWI 2012), Braunschweig, pp. 1091–1104 (2012)
Inmon, B.: The data warehouse budget. DM Review Magazine (1997)
Kurze, C.: Computer-Aided Warehouse Engineering: Anwendung modellgetriebener Entwicklungsparadigmen auf Data-Warehouse-Systeme. Verlag Dr. Kovač (2011)
Krawatzeck, R., Jacobi, F., Müller, A., Hofmann, M.: Konzeption eines Frameworks zur automatisierten Erstellung nutzerspezifischer IT-Systemdokumentationen. In: Workshop Business Intelligence 2011 (WSBI 2011) der GI-Fachgruppe BI, pp. 15–26 (2011)
Jacobi, F., Krawatzeck, R., Hofmann, M.: Meeting the Need for ETL Documentation: A Model-driven Framework for Customizable Documentation Generation. In: Proc. of the 18th Americas Conference on Information Systems (AMCIS 2012), Seattle, USA (in print, 2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Krawatzeck, R., Jacobi, F., Hofmann, M. (2012). CAWE DW Documenter: A Model-Driven Tool for Customizable ETL Documentation Generation. In: Castano, S., Vassiliadis, P., Lakshmanan, L.V., Lee, M.L. (eds) Advances in Conceptual Modeling. ER 2012. Lecture Notes in Computer Science, vol 7518. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-33999-8_49
Download citation
DOI: https://doi.org/10.1007/978-3-642-33999-8_49
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-33998-1
Online ISBN: 978-3-642-33999-8
eBook Packages: Computer ScienceComputer Science (R0)