Abstract
Business Intelligence projects include a big variety of challenges for all involved parties. Due to individual and changeable customer requirements or lacking standardization, there is much legwork which BI developers or consultants have to spend time on. BIAccelerator’s template-based ETL development approach tries to tackle this issue by providing developers with a flexibly extendable environment which helps to quickly set up prototypes and which allows simplified change management. The tool allows importing metadata from source or destination data storages, adding additional knowledge (e.g. source - destination mappings or definition of Slowly Changing Dimension attributes) and generating executable ETL packages based on custom templates and collected metadata. This way, any changes (e.g. modification of source/destination entities or changes in the ETL processes) can easily be deployed.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
He, T., Gudyka, M.: Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services. SQL Server Technical Article (2008)
Xu, L., Liao, J., Zhao, R., Wu, B.: A PaaS Based Metadata-Driven ETL Framework. In: IEEE CCIS 2011 (2011)
Vossen, G.: Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme. 5. Auflage. Oldenbourg Wissenschaftsverlag, München (2008)
Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons, New York (1998)
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 5th edn. Addison-Wesley, Boston (2007)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edn. John Wiley & Sons, New York (2002)
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
Stumptner, R., Freudenthaler, B., Krenn, M. (2012). BIAccelerator – A Template-Based Approach for Rapid ETL Development. In: Chen, L., Felfernig, A., Liu, J., Raś, Z.W. (eds) Foundations of Intelligent Systems. ISMIS 2012. Lecture Notes in Computer Science(), vol 7661. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-34624-8_49
Download citation
DOI: https://doi.org/10.1007/978-3-642-34624-8_49
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-34623-1
Online ISBN: 978-3-642-34624-8
eBook Packages: Computer ScienceComputer Science (R0)