Print-friendly Version

Sizing Study for Pentaho Open Source Business Intelligence Suite on Sun Platforms

Krishnan Shankar, June 2009

Introduction

This paper describes a sizing study of Pentaho Open Source Business Intelligence (OSBI) Suite on a Sun platform. It comprises tests conducted with application tools from Pentaho. This guide can be used as a reference point when choosing a suitable Sun platform for Business Intelligence (BI) applications.

For more details, see the list of contents below.

Download the document as PDF.

Contents

• 1. Introduction
  • 1.1 Overview
  • 1.2 How the Report Is Organized
  • 1.3 Terminology
  • 1.4 Key Performance Metrics
  • 1.5 Project Evaluation and Requirements
  • 1.6 Reference Links
• 2. Testing Activity
  • 2.1 High-Level Description of Tests
  • 2.2 Deployment Topology
  • 2.3 Hardware and Software Specifications
• 3. Performance Results
  • 3.1 Pentaho ETL
  • 3.2 Pentaho Report Designer
  • 3.3 Pentaho Mondrian OLAP Server
  • 3.4 Interpreting the Test Results
• 4. Summary of Results
  • 4.1 Summary of Performance Data
  • 4.2 Analysis and Conclusions
  • 4.3 Recommended Hardware
• Additional Information
  • 5.1 Standard Tuning Parameters
  • 5.2 Workload Details
• 6. Appendix
  • 6.1 Detailed Deployment of Application Software
• 7. Acknowledgements
• 8. Product Information

For More Information

Here are some additional resources:

• Pentaho Open Source Business Intelligence web site
• Pentaho Spoon and Kettle
• TPC-H data warehouse workload kit and DBGEN data generator tool
• Mondrian FoodMart demo database
• Tsung open source multiprotocol distributed load testing tool
• VNC software on the Solaris 10 OS
• Solaris OS web site
• Sun Fire X4540 web site
• Resources on BigAdmin, such as:
  • MySQL Resources for System Administrators
  • Database resource collection (includes community submissions)
  • Storage resource collection (includes community submissions)
  • Feature Article: Pentaho Business Intelligence and MySQL on Sun Storage 7000 Unified Storage System
• BigAdmin wiki:
  • Storage Tech Tips page
  • Databases page
  • Servers page
• Sun BluePrints papers (registration required) at the Sun BluePrints wiki, for example:
  • Running MySQL Database in Solaris Containers
  • Improving MySQL Database Scalability
• Sun download site
• Solaris and Sun Fire training courses at http://www.sun.com/training/, for example:
  • Intermediate System Administration for the Solaris 10 Operating System (WSB-200-S10)
  • Sun Fire X4540 Server Administration (WET-6179)
• MySQL information:
  • sun.com page
  • mysql.com
  • MySQL training courses on sun.com
  • MySQL training courses on mysql.com
• Discussions:
  • Sun forums
  • BigAdmin Discussions collection
• Sun product documentation:
  • Documentation at http://docs.sun.com, such as Sun Fire X4540 Server documents, Solaris 10 System Administrator Collection, and MySQL documents
  • MySQL documents at mysql.com/
  • Sun Documentation Center
• Support:
  • Sun resources:
    • Register your Sun gear
    • Services
    • SunSolve Online
  • Community system administration experts
• Events of interest to users of Sun products:
  • Worldwide Developer Events and Sun Tech Days
  • Current Events

Unless otherwise licensed, code in all technical manuals herein (including articles, FAQs, samples) is provided under this License.