Efficiency evaluation of open source ETL tools

Proceedings of the ACM Symposium on Applied Computing

Volumn , Issue , 2011, Pages 287-294

  Majchrzak, Tim A ^a   Jansen, Tobias ^b   Kuchen, Herbert ^a  

^a UNIVERSITY OF MÜNSTER   (Germany)

^b SHS VIVEON AG   (Germany)

Author keywords

BI; business intelligence; ETL; extract; load; transform

Indexed keywords

DATA INTEGRATION; EFFICIENCY EVALUATION; ETL; ETL PROCESS; EXTRACT; HIGH IMPACT; LOAD; OPEN SOURCES; RESEARCH ACTIVITIES; TEST SETUPS; TRANSFORM;

EID: 79959308907     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1982185.1982251     Document Type: Conference Paper

References (40)

1. S. Asghar, S. Fong, and T. Hussain. Business intelligence modeling: A case study of disaster management organization in pakistan. In Proc. ICCIT '09, pages 673-678, Washington, DC, USA, 2009. IEEE Computer Society.
2. A. Bauer and H. Günzel. Data Warehouse Systeme: Architektur, Entwicklung, Anwendung. dpunkt, 3rd edition, 2009.
3. S. Becker. Performance-related metrics in the ISO 9126 standard. In I. Eusgeld, F. C. Freiling, and R. Reussner, editors, Dependability Metrics: Advanced Lectures, volume 4909 of Lecture Notes in Computer Science, pages 204-206. Springer, 2008.
4. P. A. Bernstein and L. M. Haas. Information integration in the enterprise. Commun. ACM, 51(9):72-79, 2008.
5. J. Darmont, O. Boussaid, and F. Bentayeb. Dweb: A data warehouse engineering benchmark. In A. M. Tjoa and J. Trujillo, editors, Proc. DaWaK 2005, volume 3589 of LNCS, pages 85-94. Springer, 2005.
6. C. Dell'Aquila, F. Di Tria, E. Lefons, and F. Tangorra. Business intelligence systems: a comparative analysis. WSEAS Trans. Info. Sci. and App., 5(5):612-621, 2008.
7. C. Dell'Aquila, F. Di Tria, E. Lefons, and F. Tangorra. Evaluating business intelligence platforms: a case study. In Proc. AIKED'08, pages 558-564, Stevens Point, Wisconsin, USA, 2008. WSEAS.
8. C. Dittmar and P. Gluchowski. Synergiepotenziale und Herausforderungen von Knowledge Management und Business Intelligence, pages 27-42. Springer, 2002.
9. V. Dwivedi and N. Kulkarni. Information as a service in a data analytics scenario - a case study. In Proc. ICWS '08, pages 615-620, Washington, DC, USA, 2008. IEEE Computer Society.
10. Gartner, Inc. Press release: ETL magic quadrant update: A market in evolution, May 2002. Online: http://www.gartner.com/reprints/informatica/106602. html.
11. Gartner Inc. Magic quadrant for data integration tools, September 2008. Online: http://www.sap.com/solutions/pdf/Magic-Quadrant-Data-Integration-Tools. pdf.
12. Gartner, Inc. Who's who in open-source business intelligence, April 2008. Online: http://www.stratebi.es/todobi/may08/whos-who-in-opensource-busin- 156326.pdf.
13. Gartner, Inc. Press release: Gartner reveals five business intelligence predictions for 2009 and beyond, January 2009. Online: http://www.gartner.com/ it/page.jsp?id=856714.
14. M. Golfarelli. Open source BI platforms: A functional and architectural comparison. In Proc. DaWaK '09, pages 287-297, Berlin, Heidelberg, 2009. Springer.
15. P. Hawking, S. Foster, and A. Stein. The adoption and use of business intelligence solutions in australia. Int. J. Intell. Syst. Technol. Appl., 4(3/4):327-340, 2008.
16. W. H. Inmon. Building the Data Warehouse. Wiley, New York, NY, USA, 3rd edition, 2002.
17. R. Kimball and J. Caserta. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley, 2004.
18. R. Kimball, L. Reeves, W. Thornthwaite, M. Ross, and W. Thornwaite. The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. Wiley, New York, NY, USA, 1998.
19. H. Koziolek. Introduction to performance metrics. In I. Eusgeld, F. C. Freiling, and R. Reussner, editors, Dependability Metrics: Advanced Lectures, volume 4909 of LNCS, pages 199-203. Springer, 2008.
20. D. J. Lilja. Measuring computer performance: a practitioner's guide. Cambridge UP, New York, NY, USA, 2005.
21. H. P. Luhn. A business intelligence system. IBM J. Res. Dev., 2(4):314-319, 1958.
22. M. Mejía-Lavalle, R. Sosa R., N. González M., and L. Argotte R. Survey of business intelligence for energy markets. In Proc. HAIS '09, pages 235-243, Berlin, Heidelberg, 2009. Springer.
23. L. T. Moss and S. Atre. Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications. Addison-Wesley Longman, Boston, MA, USA, 2003.
24. n. A. The evolution of ETL. Technical report, Vivan Technologies, 2007. Online: http://vivantech.net/Documents/ETL-Evaluation.pdf.
25. S. Negash and P. Gray. Business intelligence. In F. Burstein and C. W. Holsapple, editors, Handbook on Decision Support Systems 2: Variations. Springer, 2008.
26. Z. Panian. Business intelligence in support of business strategy. In Proc. MCBE'06, pages 19-23, Stevens Point, 2006. WSEAS.
27. Z. Panian. Expected progress in the field of business intelligence. In Proc. AIKED'09, pages 170-175, Stevens Point, 2009. WSEAS.
28. A. Sabett and H. Koziolek. Measuring performance metrics: Techniques and tools. In I. Eusgeld, F. C. Freiling, and R. Reussner, editors, Dependability Metrics: Advanced Lectures, volume 4909 of LNCS, pages 226-232. Springer, 2008.
29. F. Silvers. Building and Maintaining a Data Warehouse. Auerbach Publications, 2008.
30. A. Simitsis, P. Vassiliadis, U. Dayal, A. Karagiannis, and V. Tziovara. Benchmarking ETL workflows. First TPC Technology Conf., TPCTC 2009, pages 199-220, 2009.
31. A. Simitsis, P. Vassiliadis, and T. Sellis. Optimizing ETL processes in data warehouses. In Proc. ICDE '05, pages 564-575, Washington, DC, USA, 2005. IEEE Computer Society.
32. C. Thomsen and T. B. Pedersen. A survey of open source tools for business intelligence. In A. M. Tjoa and J. Trujillo, editors, Proc. DaWaK 2005, volume 3589 of LNCS, pages 74-84. Springer, 2005.
33. E. Turban, R. Sharda, and D. Delen. Decision Support and Business Intelligence Systems. Prentice-Hall, Upper Saddle River, NJ, USA, 9th edition, 2010.
34. P. Vassiliadis, A. Karagiannis, V. Tziovara, and A. Simitsis. Towards a benchmark for ETL workflows. In V. Ganti and F. Naumann, editors, Proc. QDB 2007, pages 49-60, 2007.
35. P. Vassiliadis, A. Simitsis, and E. Baikousi. A taxonomy of ETL activities. In Proc. DOLAP '09, pages 25-32, New York, NY, USA, 2009. ACM.
36. C. Vercellis. Business Intelligence: Data Mining and Optimization for Decision Making. Wiley, 2009.
37. H. J. Watson and B. H. Wixom. The current state of business intelligence. Computer, 40(9):96-99, 2007.
38. S. Williams and N. Williams. The Profit Impact of Business Intelligence. Morgan Kaufmann, San Francisco, CA, 2006.
39. L. Wyatt, B. Caufield, and D. Pol. Principles for an ETL benchmark. First TPC Technology Conf., TPCTC 2009, pages 183-198, 2009.
40. Z. Xu, M. Zhang, and X. Jiang. Business intelligence - a case study in life insurance industry. In Proc. ICEBE '05, Washington, DC, USA, 2005. IEEE CS.