Feed on

I am working on a project this summer that analyzes Bugzilla. The basis of this project has been started by Nick Goodman and he entitled it Software Quality Reports (SQR). Software Quality Reports gives product managers, project managers, development managers, and software engineers more information on things like bug burn down rate by product, issues by status and product, average days to resolution by priority and product, open vs close trend by product, etc. I am going to take Nick Goodman’s SQR and improve it by making it more scalable and adding addition features that don’t currently exist.

A large part of this project involves doing an ETL(Extract Transform Load) on the bugzilla database into a star schema in side of a data warehouse. To design and run the ETL process I am using a program from the open source community project Pentaho BI (Business Intelligence) Suite called Pentaho Data Integration (PDI, and formerly known as kettle) and spoon — the graphical tool which is used to design and test every PDI process. Once the data is loaded in to the star schema, I will then use the Pentaho BI server to create graphs and charts to visualize and and drill down the data.

I will be reporting my work through out this blog and I hope that it will allow any one interested to participate, learn, or contribute. To get started right now you can read up about Pentaho, Pentaho Data Integration (formerly known as kettle), and Nick Goodman’s Software Quality Reports can be found on sourceforge.

7 Responses to “Software Quality Reports: Bugzilla Analysis”

  1. […] Data Blog Just another Blog.mozilla.com weblog « Software Quality Reports: Bugzilla Analysis […]

  2. […] here and here to check out the first couple posts from Simon Krueger, our metrics intern.  Enjoy! […]

  3. on 11 Jun 2009 at 8:30 am Nicholas Goodman

    Very glad to have some new faces on the project. It’s been teetering in the wind for almost two years now so it definitely needs some help.

    To boot, it was written on Kettle 2.4.x and the first ever combined Pentaho/Kettle solution (shortly after the Kettle acquisition). I recall many workarounds…

    Great stuff…

  4. on 12 Jun 2009 at 7:37 am Nithya

    I have been trying to find something like this and to be honest I dont find enough metrics like what you have suggested

    * Bug input rate
    * Bug output rate
    * Bug input trend (over a time period)
    * Bug output trend (over a time period)

    None of the open source projects seem to be giving out such information, sadly.

    Let me know if I could be of any help. I am trying to implement similar metric measurements myself.

  5. on 12 Jun 2009 at 9:28 am deinspanjer


    As we begin to release updated code, we’d be happy to have you help out where possible. Are you looking at this in the context of bmo or some other bugzilla installation?
    Also, forgive me if this is obvious, but could you elucidate a little on your definitions of input/output? Do you mean new bugs added and bugs closed, or something more detailed?

  6. […] – there’s a current project underway aimed at answering some key analytical questions related to Bugzilla and providing folks […]

  7. on 10 Jan 2010 at 8:50 am James Tanner

    We are thinking of implementing Bugzilla at our ISV that makes Internet Filters for small business. We look forward to developments.

    Comvigo, Inc.

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.