Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 70 Next 10 Older Entries

Displaying posts with tag: Pentaho (reset)

Instant Relief from Slow MySQL Reporting Queries using DynamoDB
+2 Vote Up -2Vote Down

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)
  • MySQL is fundamentally designed to be an OLTP database and while it does a fantastic job at that, its data warehouse features were built as “bolt on” additions. Can it be used for BI? Absolutely, I’ve used it a many customer sites. Does DynamoDB provide a better

      [Read more...]
    451 CAOS Links 2009.10.13
    +0 Vote Up -0Vote Down

    Larry Ellison promises funds for MySQL, commits to community. The “open source vendor” debate in a nutshell. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    # Larry Ellison promised MySQL will receive more money for development and research, while Oracle maintained that it is committed to Java and open source developer communities.

    # GroundWork raised $5m series D funding from Canaan Partners, Mayfield, JAFCO Ventures and SAP Ventures.

    # InformationWeek reported that Motorola has vacated its seat on the LiMo


      [Read more...]
    451 CAOS Links 2009.10.06
    +0 Vote Up -0Vote Down

    Patents. M&A. Adoption. Business strategies. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    This bumper edition of 451 CAOS Links is brought to you courtesy of the Open World Forum’s temperamental wireless connection.

    Patents
    # Red Hat urged the Supreme Court to to make clear that it excludes software from patentability, while the SFLC and the FSF also filed briefs with the US Supreme Court arguing against software patents.

    Investment and M&A
    # The WSJ reported



      [Read more...]
    Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL
    Employee +0 Vote Up -0Vote Down
    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 working on this book. And I have found that he is always investigating something interesting.

    Now to buy a pair of those cheap terabyte disk



      [Read more...]
    451 CAOS Links 2009.09.01
    +0 Vote Up -1Vote Down

    Intalio acquires Jetty. Red Hat updates JBoss platform. $12m funding for Medsphere. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    # Intalio acquired Webtide, developer of Jetty application server.

    # Red Hat delivered JBoss Enterprise Application Platform 5.0, as well as JBoss Operations Network (ON) 2.3 and launched Catalyst partner program.

    # Medsphere raised $12m to support ongoing development and expansion in open source health IT.

    # Xen.org


      [Read more...]
    "Pentaho Solutions": copies hit the mail
    +6 Vote Up -0Vote Down
    Hi!

    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:



    Yes - it's true!! Copies of my and Jos' book







      [Read more...]
    451 CAOS Links 2009.07.31
    +0 Vote Up -0Vote Down

    When open source goes bad. Is open source a success or failure? And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    When open source goes bad

    The H reported on the apparent turmoil at the CentOS project, while Jay Lyman offered the CAOS perspective. Meanwhile Slashdot reported that Alan Cox has quit as Linux TTY subsystem maintainer.

    Success or failure?
    Danny Windham, Digium CEO, responded to Peter Yared’s





      [Read more...]
    My OSCON 2009 Session: Taming your Data...
    +1 Vote Up -0Vote Down
    Yes!

    Finally, it's there: In a few hours, I will be flying off to San Franscisco to attend OSCON 2009 in San Jose, California. This is the first time I'm attending, and I'm tremendously excited to be there! The sessions look very promising, and I'm looking forward to seeing some excellent speakers. I expect to learn a lot.

    I'm also very proud and feel honoured to have the chance to deliver a session myself. It's called Taming Your Data: Practical Data Integration Solutions with Kettle.

    Unsurprisingly, I will be talkig a lot about Kettle, a.k.a. Pentaho Data Integration. Recently, I





      [Read more...]
    Starring Sakila: MySQL university recording, slides and materials available onMySQLForge
    +0 Vote Up -0Vote Down
    Hi!

    Yesterday I had the honour of presenting my mini-bi/datawarehousing tutorial "Starring Sakila" for MySQL University. I did a modified version of the presentation I did together with Matt Casters at the MySQL user's conference 2009. The structure of the presentation is still largely the same, although I condensed various bits, and I added practical examples of setting up the ETL process and creating a Pentaho Analysis View (OLAP pivot table) on top of a Mondrian Cube.

    The slides, session recording, and materials such as SQL script, pentaho data integration jobs and transformations, and Sakila Rentals Cube for Mondrian are all available here on MySQL



      [Read more...]
    451 CAOS Links 2009.06.16
    +0 Vote Up -0Vote Down

    Open source and SMBs. New funding for Lucid Imagination. And more.

    Follow 451 CAOS Links live @caostheory

    On open source and SMBs
    Savio Rodrigues contrasted Dell’s plans to target SMBs with bundles of hardware and open source with research from Forrester that indicated that SMBs are still wary of open source, while Matt Asay noted that there are significant opportunities for open source vendors if they can work out how to crack the SMB market and suggested that the way to make software easier for SMBs and to monetize it might actually be cloud-based computing.

    OStatic noted that the issue may well be one of lack of awareness and that Dell’s initiative, as well as the


      [Read more...]
    Proven and Cost Effective BI Deployment Strategies with MySQL and Pentaho
    +0 Vote Up -0Vote Down

    What if you could evaluate, deploy and maintain a Data Warehouse (DW) and Business Intelligence (BI) solution for up to 90% less than the cost of proprietary software? What if you can find a solution that has been adopted by customers in all industries and is technically sound and scalable? 

    You can, with open source Data Warehousing from MySQL and Business Intelligence from Pentaho.

    Join this webcast to find out about real world BI/DW deployment strategies that that offer you robust capabilities, yet with a lower total cost of ownership (TCO).  

    The MySQL and Pentaho solution has been proven in diverse deployments, from small companies to large enterprises. The subscription support model aligns customer and vendor interests, lowering both your costs and project risks. Join this webcast and learn how to be successful in your BI/DW

      [Read more...]
    Proven and Cost Effective BI Deployment Strategies with MySQL and Pentaho
    +0 Vote Up -0Vote Down

    What if you could evaluate, deploy and maintain a Data Warehouse (DW) and Business Intelligence (BI) solution for up to 90% less than the cost of proprietary software? What if you can find a solution that has been adopted by customers in all industries and is technically sound and scalable? 

    You can, with open source Data Warehousing from MySQL and Business Intelligence from Pentaho.

    Join this webcast to find out about real world BI/DW deployment strategies that that offer you robust capabilities, yet with a lower total cost of ownership (TCO).  

    The MySQL and Pentaho solution has been proven in diverse deployments, from small companies to large enterprises. The subscription support model aligns customer and vendor interests, lowering both your costs and project risks. Join this webcast and learn how to be successful in your BI/DW

      [Read more...]
    Proven and Cost Effective BI Deployment Strategies with MySQL and Pentaho
    +0 Vote Up -0Vote Down

    What if you could evaluate, deploy and maintain a Data Warehouse (DW) and Business Intelligence (BI) solution for up to 90% less than the cost of proprietary software? What if you can find a solution that has been adopted by customers in all industries and is technically sound and scalable? 

    You can, with open source Data Warehousing from MySQL and Business Intelligence from Pentaho.

    Join this webcast to find out about real world BI/DW deployment strategies that that offer you robust capabilities, yet with a lower total cost of ownership (TCO).  

    The MySQL and Pentaho solution has been proven in diverse deployments, from small companies to large enterprises. The subscription support model aligns customer and vendor interests, lowering both your costs and project risks. Join this webcast and learn how to be successful in your

      [Read more...]
    451 CAOS Links 2009.06.12
    +0 Vote Up -0Vote Down

    Yahoo opens up Hadoop distribution. Microsoft and Novell claim customer wins. And more.

    Follow 451 CAOS Links live @caostheory

    The elephant in the room
    Plenty of news emerged form the Hadoop Summit this week, including Cloudera announced support for Amazon Elastic Block Storage (EBS) and introduced Sqoop, open source tool for importing databases into Hadoop, while Yahoo! Released! The! Yahoo! Distribution! Of! Hadoop! opening up its Hadoop developments to the wider community. As Savio Rodrigues noted, there has been a surge in the number of contributors for the Hadoop project in the last year.

    Best of the rest
    # Novell and Microsoft


      [Read more...]
    451 CAOS Links 2009.06.02
    +0 Vote Up -0Vote Down

    Cloudera lands funding. SourceForge acquires Ohloh. Novell reports Linux growth. And more.

    Follow 451 CAOS Links live @caostheory

    Cloudera shows signs of progress

    GigaOM reported that Cloudera raised $6m Series B funding from Accel and Greylock and is now looking beyond web applications to wider enterprise adoption of Hadoop. Cloudera also announced its first certification program for Hadoop.

    Open source goes mainstream in the UK
    There have been signs of change recently with regards to open source adoption in the UK, which has traditionally lagged behind the rest of Europe and the US. CBR Magazine provided an analysis of open source in the UK




      [Read more...]
    Google Goodies and Lego
    +0 Vote Up -0Vote Down

    Dear Kettle friends,

    Will Gorman and Mike D’Amour, Senior Developers at Pentaho, are presenting Pentaho’s Google integration work at the Google I/O Developer Conference. (at the Sandbox area to be specific)   Yesterday, Pentaho announced that much.

    Here are a few of the integration points:

    • Google maps dashboard (available in the Pentaho BI server you can download)
    • A new Google Docs step was created for Pentaho Data Integration Enterprise Edition
    • Running (AVI, 30MB) the Pentaho BI server on
      [Read more...]
    Completed Draft for the "Pentaho Solutions" Book
    +1 Vote Up -0Vote Down
    Yes!

    Last night, I completed the draft of "Pentaho Solutions", which is a book I'm writing together with my friend and colleague Jos van Dongen for Wiley.

    (Actually, the full title is: "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL")

    Here's an overview of the contents, just to give you an idea what we have been doing:

    • Part I: Getting Started, Prerequisites, Installation and Configuration and Overview

      • Chapter 1: Quick Start: Pentaho PCI Examples

      • Chapter 2: Prerequisites

      • Chapter 3: Server Installation and Configuration

      • Chapter 4: The Pentaho BI Stack













      [Read more...]
    Playing fantasy M&A with the Benchmark/Accel open source investment portfolio
    +0 Vote Up -0Vote Down

    Javier Soltero, former CEO of Hyperic, has maintained that the sale of Hyperic to SpringSource was driven by discussion between himself and SpringSource CEO, Rod Johnson, but the fact that the companies shared investors - Accel Partners and Benchmark Capital - no doubt accelerated the deal (and I wonder whether either could have afforded to acquire the other without shared investors).

    When examining the open source vendor landscape it is tempting to imagine that the combined total could be bigger than the sum of its parts - that a combination of many open source product specialists could mount a challenge to Red Hat and Sun to claim the title of biggest open source software vendor.

    Benchmark and Accel

      [Read more...]
    PDI cloud : massive performance roundup
    +0 Vote Up -0Vote Down

    Dear Kettle fans,

    As expected there was a lot of interest in cloud computing at the MySQL conference last week.  It felt really good to be able to pass the Bayon Technologies white paper around to friends, contacts and analysts.  It’s one thing to demonstrate a certain scalability on your blog, it’s another entirely to have a smart man like Nicholas Goodman do the math.

    Sorting massive amounts of rows is hard problem to take on.  Making it scale on low-cost EC2

      [Read more...]
    Next week : MySQL UC
    +0 Vote Up -0Vote Down

    Dear Kettle & MySQL fans!

    I’m really looking forward to go to the MySQL User Conference next week, not just because I’m speaking in 2 sessions again, but perhaps also because these are “interesting” times for MySQL and Sun Microsystems.  Pivotal times it would seem.

    Here are the 2 sessions I’m going to do:

    • Cloud Computing with MySQL and Kettle : I’m particularly happy that MySQL accepted this session: it will demonstrate how easy it has become to do cloud computing exercises with tools like MySQL and Kettle.
      [Read more...]
    Pentaho Partner Summit ‘09
    +0 Vote Up -0Vote Down

    Dear reader,

    In a little over 3 weeks, April 2nd and 3rd, we’re organizing a Pentaho Partner Summit at the Quadrus Conference Center in Menlo Park near San Francisco.

    If you are (as the invitation describes) an “Executive, luminary, current or prospective partner from around the world” and if you come over you’ll meet myself, Julian Hyde and perhaps a couple of other architects as well.  That is outside of a host of other interesting people like Zack Urlocker (MySQL) and of course Richard Daley our CEO. We’ll be doing a couple of lengthy sessions on Kettle and Mondrian among other things.

    See you

      [Read more...]
    Make Mondrian Dumb
    +0 Vote Up -0Vote Down

    I had a customer recently who had very hierarchical data, with some complicated measures that didn’t aggregate up according to regular ole aggregation rules (sum, min, max, avg, count, distinct count). Now, one can do weighted averages using sql expressions in a Measure Expression these rules were complex and they also were dependent on the other dimension attributes. UGGGGH.

    Come to that: their analysts had the pristine, blessed data sets calculated at different rollups (already aggregated to Company Regions). Mondrian though, is often too smart for it’s own good. If it has data in cache, and things it can roll up a measure to a higher level (Company Companies can be rolled up to Regions if it’s a SUM for instance) Mondrian will do that. This is desirable in like 99.9% of cases. Unless, you want to “solve” your cube and

      [Read more...]
    Self Service Data Export using Pentaho
    +0 Vote Up -0Vote Down

    Every BI installation has power users that just want “data dumps.” They may need the dumps for a variety of reasons:

    • You’ve built crappy reports. They can’t get the information they need in *YOUR* reports.
    • They need to feed the data into another system. They want to select all customers who bought product X in time period Y to send them a recall notice. Need a dump of email / addresses to send them the notice.
    • They are addicted to Excel; they feel like a super hero whizzing through the data making fancy graphs and doing a few of their own ratios/calculations.
    • They want to munge the numbers. They will export it to Excel, throw out the data that makes them look bad, and then present it to their boss with shiny positive results.

    I had a customer who needed something to “feed

      [Read more...]
    Writing a Book: Building Pentaho Solutions
    +0 Vote Up -0Vote Down
    Ok - this has been stewing for some time now, and I think now is the right time to announce that I am working together with Jos van Dongen from Tholis Consulting to create a book for Wiley with the tentative title "Building Pentaho Solutions".

    My personal aim is to make this book the primary point of reference for DBAs and Application Developers that are familiar with Open Source products like MySQL and PostgreSQL but have no prior BI skills, as well as BI professionals that are familiar with closed source BI products like Microsoft BI and Business Objects that want to learn how to get things done with Pentaho.

    The book



      [Read more...]
    "Starring Sakila": a Data Warehousing mini-tutorial at the MySQL UC 2009
    +0 Vote Up -0Vote Down
    Hi!

    Recently I wrote about how glad I was to see two of my proposals for the upcoming MySQL Conference approved.

    I am absolutely thrilled to see my third proposal has been approved as well: "Starring Sakila: data warehousing explained, illustrated and subtitled". I'm very proud to announce that I'm doing this talk together with Matt Casters, chief data integration of Pentaho and creator of the popular ETL/Data Integration suite Kettle (a.k.a Pentaho data integration).

    During this 45-minute





      [Read more...]
    Maturity of Open Source ETL / Why do people fail to do their homework?
    +0 Vote Up -0Vote Down
    I just read this post on Matt Casters' blog. Here, Matt describes why Element 61's Jan Claes is dead wrong in the way he assesses the maturity of open source ETL tools.

    Well, I've just read Jan Claes' article in the "research and insights" area of the Element61 website, and frankly, it is pretty easy to see how unsubstantiated it is. Some may be tempted to classify the article as

      [Read more...]
    It is FINALLY here - Manage Datasources
    +0 Vote Up -0Vote Down

    Since the very first time I downloaded the Pentaho suite I’ve been wailing, screaming, shouting, snarking that there absolutely MUST be a way to manage data sources that does not involve XML.

    Well… Holy Shit. At just under 3 years it’s here (Pentaho Administration Console from 2.0.M3 build):

    This is a most appreciated feature for those getting started with Pentaho! Thank you to the Pentaho

      [Read more...]
    Changing Lanes: Leaving Sun/MySQL
    +0 Vote Up -0Vote Down
    After having worked for two years and one quarter of a year with MySQL AB (now Sun), I have decided to resign and pursue another career.

    Before I joined MySQL AB I was working as a database consultant and application developer. I knew that joining MySQL would mean giving that up, but I was happy to do so because I really liked the MySQL product. I was also attracted by the company itself, the flexible working hours, working from home, travelling abroad, and, very important, being one of the few companies that is capable creating FOSS software on a commercial basis.

    I have had a splendid time at MySQL AB, and later Sun. I met lots of smart people and travelled to a bunch of places I would probably not've had the chance



      [Read more...]
    Pentaho changes
    +0 Vote Up -0Vote Down

    I’m back at my favorite spot at the Orlando airport:

    This week has gone bye so fast it’s kinda scary.  I got dragged into one meeting after another design session after another knowledge transfer opportunity for 5 days in a row.  After our long working days, the discussions and talks just continued over dinner and beers.

    It was great to meet everyone and as always we had a good time around the office and at the Ale House.  I even managed to stay sober this time around.  Well at least most of the time.

    As always, the thing that struck me the most was how fast Pentaho changes.  It’s almost like visiting a different company every time I drop in.  Since I don’t see the day-to-day changes around the office, the difference between the first time I visited (15 people) and now (70+) is striking.  The office

      [Read more...]
    Applying the Bee Keeper model beyond captive open source projects
    +0 Vote Up -0Vote Down

    I?ve been reading The Bee Keeper (also here in PDF), an explanation of the relationship between professional open source software (POSS) vendors and their communities, written by Pentaho?s CTO James Dixon. It is a very elegant explanation of the development/business model employed by the POSS vendors such as MySQL, Pentaho, JBoss and Alfresco.

    James uses the analogy of the Bee Keeper to explain the model. It?s worth reading the paper in its entirety to understand just how appropriate this is but to put it very simply: the vendor is the bee keeper; the community is the bees; the open source project is the honey; and

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 70 Next 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    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.