Skip to main content
Springer Nature Link
Log in

A Survey of Open Source Tools for Business Intelligence

  • Conference paper
Data Warehousing and Knowledge Discovery (DaWaK 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3589))

Included in the following conference series:

Abstract

The industrial use of open source Business Intelligence (BI) tools is not yet common. It is therefore of interest to explore which possibilities are available for open source BI and compare the tools.

In this survey paper, we consider the capabilities of a number of open source tools for BI. In the paper, we consider three Extract-Transform-Load (ETL) tools, three On-Line Analytical Processing (OLAP) servers, two OLAP clients, and four database management systems (DBMSs). Further, we describe the licenses that the products are released under.

It is argued that the ETL tools are still not very mature for use in industry while the DBMSs are mature and applicable to real-world projects. The OLAP servers and clients are not as powerful as commercial solutions but may be useful in less demanding projects.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Apache, S.W.: License v1.1, http://www.apache.org/licenses/LICENSE-1.1 (as of 05/30/05)

  2. Apache, S.W.: License, v2.0, http://www.apache.org/licenses/LICENSE-2.0 (as of 05/30/05)

  3. Bee, sourceforge.net/projects/bee/ (as of 05/30/05)

    Google Scholar 

  4. Bee Project, bee.insightstrategy.cz/en/ (as of 05/30/05)

    Google Scholar 

  5. BSD license, opensource.org/licenses/bsd-license.php (as of 05/30/05)

    Google Scholar 

  6. CloverETL, cloveretl.berlios.de (as of 05/30/05)

    Google Scholar 

  7. CPL v1.0, opensource.org/licenses/cpl1.0.php (as of 05/30/05)

    Google Scholar 

  8. cplusql ETL tool, sourceforge.net/projects/cplusql/ (as of 05/30/05)

    Google Scholar 

  9. Enhydra Octopus, octopus.objectweb.org/ (as of 05/30/05)

    Google Scholar 

  10. Gardner, J.: Materialized Views in PostgreSQL, jonathangardner.net/PostgreSQL/ materialized_views/matviews.html (as of 05/30/05)

    Google Scholar 

  11. GNU GPL License, http://www.gnu.org/copyleft/gpl.html (as of 05/30/05)

  12. GNU LGPL License, http://www.gnu.org/copyleft/lgpl.html (as of 05/30/05)

  13. gnuOLAP, gnuolap.sourceforge.net/ (as of 05/30/05)

    Google Scholar 

  14. Java OLAP Interface (JOLAP), http://www.jcp.org/en/jsr/detail?id=69 (as of 05/30/05)

  15. JFreeChart, http://www.jfree.org/jfreechart (as of 05/30/05)

  16. Jpivot, jpivot.sourceforge.net/ (as of 05/30/05)

    Google Scholar 

  17. Lemur OLAP library, http://www.nongnu.org/lemur/ (as of 05/30/05)

  18. MaxDB, http://www.mysql.com/products/maxdb/ (as of 05/30/05)

  19. Mondrian components, perforce.eigenbase.org:8080/open/mondrian/doc/index. html (as of 05/30/05)

    Google Scholar 

  20. Mondrian FAQs, perforce.eigenbase.org:8080/open/mondrian/doc/faq.html (as of 05/30/05)

    Google Scholar 

  21. MonetDB, monetdb.cwi.nl/ (as of 05/30/05)

    Google Scholar 

  22. Mozilla Public License v1.1, http://www.mozilla.org/MPL/MPL-1.1.html (as of 05/30/05)

  23. MySQL Case Studies, http://www.mysql.com/it-resources/case-studies/ (as of 05/30/05)

  24. MySQL Database Server, http://www.mysql.com/products/mysql/ (as of 05/30/05)

  25. The OLAP Report Market share analysis, http://www.olapreport.com/market.htm (as of 05/30/05)

  26. Open ETL, openetl.tigris.org (as of 05/30/05)

    Google Scholar 

  27. Open Source ETL (OpnSrcETL), opnsrcetl.sourceforge.net/ (as of 05/30/05)

    Google Scholar 

  28. OpenROLAP, openrolap.sourceforge.net (as of 05/30/05)

    Google Scholar 

  29. Pedersen, T.B.: How Is BI Used in Industry?: Report from a Knowledge Exchange Network. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 179–188. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  30. Pedersen, T.B., Jensen, C.S.: Multidimensional Database Technology. IEEE Computer 34(12), 40–46 (2001)

    Google Scholar 

  31. pocOLAP - the “little” OLAP-project, pocolap.sourceforge.net/ (as of 05/30/05)

    Google Scholar 

  32. PostgreSQL, http://www.postgresql.org (as of 05/30/05)

  33. The R Project for Statistical Computing, http://www.r-project.org (as of 05/30/05)

  34. Self-Organizing Databases, research.csc.ncsu.edu/selftune/ (as of 05/30/05)

    Google Scholar 

  35. Spofford, G., Thomsen, E.: MDX Solutions: With Microsoft SQL Server Analysis Services. Wiley, Chichester (2001)

    Google Scholar 

  36. Stonebraker, M., Rowe, L.: The Postgres papers, TR, UC Berkeley (1987)

    Google Scholar 

  37. Vacca, J.: VRML: Bringing Virtual Reality to the Internet. Academic Press, London (1997)

    Google Scholar 

  38. Web Server Survey Achives, news.netcraft.com/archives/web_server_survey.html (as of 05/30/05)

  39. XML for analysis, xmla.org/download.asp?id=2 (as of 05/30/05)

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, Aalborg University,  

    Christian Thomsen & Torben Bach Pedersen

Authors
  1. Christian Thomsen
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Torben Bach Pedersen
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Software Technology and Interactive Systems, Vienna University of Technology, Favoritenstr. 9-11/188, A-1040, Wien, Austria

    A Min Tjoa

  2. Department of Software and Computing Systems, University of Alicante, Spain

    Juan Trujillo

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Thomsen, C., Pedersen, T.B. (2005). A Survey of Open Source Tools for Business Intelligence. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2005. Lecture Notes in Computer Science, vol 3589. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11546849_8

Download citation

  • DOI: https://doi.org/10.1007/11546849_8

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-28558-8

  • Online ISBN: 978-3-540-31732-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics