Regular visitors to the 451 CAOS Theory blog will be well aware
of The 451 Group’s CAOS (Commercial Adoption of Open Source)
research service and our CAOS long-form reports.

They are probably less aware of the open source coverage that The
451 Group provides on a day-to-day and week-to-week basis,
however, and I thought it would be worthwhile to provide some
examples of The 451 Group’s ongoing open source coverage by
highlighting a few recent reports.

Here’s the scenario. You’ve got a table in MySQL for reporting
that has a few million rows, and is denormalized for reporting.
You’ve got a Pentaho Report that is querying this MySQL table.
You have two problems with the current report.

Your users are complaining that the query is
slow, and they have to wait around for longer
than they’d like to see their report. (approx 40s)

Your DBAs are cranky because they see the
size of this table is getting bigger. (approx
1.8GB)

I’ve been setting up a Pentaho Data Integration system with the
goals of supporting collaboration with my team, allowing easy
deployment to test or production, and enabling remote monitoring
and troubleshooting of jobs and tranformations.

I’ve finally figured out a way to achieve these goals, so I’ll
try to pass this on now. I found the book "Pentaho Solutions:
Business Intelligence and Data Warehousing with Pentaho and
MySQL", by Roland Bouman and Jos van Dongen to be a big help
in figuring out how to export/import. It definitely helped me get
up and running quickly.

I get several emails each week that are from folks who have the
basics mechanics of being a DBA but are looking to learn how to
manage data. They can administer a database server but want to
know how to get more out of that data. I now have an excellent
book for them to refer.

My copy of Pentaho Solutions: Business
Intelligence and Data Warehousing with Pentaho and MySQL arrived
last week. I need to disclose that I was originally hired by
MySQL to replace one of this books authors, Roland Bouman. He
told me a year ago that he was …

Just a few hours ago, I arrived home after a very quiet and
peaceful two-week holiday with my family. It was great! I didn't
bring a computer on purpose. I brought a mobile phone, but didn't
answer that on purpose too :) Result: absolute relaxation, with
lots of time to hike, cycle, and read, and occasional visits to
musea and historic sites. Bliss :)

Anyway, now that the bags are unpacked, and the kids are asleep,
it's time to face the dragon better known as my inbox. What I
found brought a big smile to my face:

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.