Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

I'm performing some research and analysis on bug/issue tracking databases and more specifically on how programmers and teams of programmers actually interact with them. What I'm looking for involves understanding how those databases change over time.

So what I don't need for example: is a database of all the bugs of some open source project as the bugs exist today. What I do need is a complete set of revision history for every issue/bug in the database. This would enable me to pick a specific datetime and say here were the list of all the issues/bugs that existed at that moment in time.

Anyway know of some publicly accessible issue/bug databases that expose this revision data?

Ideally, the revision would look something like this (shown for a single bug, with two revisions)

 ISSUEID  PRI  SEV  ASSIGNEDTO  MODIFIEDON      VALIDUNTIL
 1        2    2    mel         apr-1-2010:5pm  apr-1-2010:6pm
 1        2    3    steve       apr-1-2010:6pm  NULL
share|improve this question
1  
JIRA exposes related data via its REST API, I don't really know of an easier / less complicated way. If you go that way, ASF's JIRA will be a great source for data. –  Yannis Rizos Dec 29 '11 at 16:03
    
What bug tracking system you this for? Any analysis is predicated on the existence of the data source which I am assuming already exists for you. –  Karlson Dec 29 '11 at 19:41
    
@Karlson - It doesn't matter what bug tracking system this is. I've just looking for any large sample set of data from somewhere that I can analyze. –  namenlos Dec 30 '11 at 7:37
    
@namenlos Reading your question again I am puzzled. Are you looking for someone to publicly expose the raw data on their bug tracking to the public? You might have to register for quite a few of them and see what you can do in terms of reports. That might give you what you need. Start with Bugzilla implementations on launchpad.net –  Karlson Dec 30 '11 at 14:53
1  
What you probably need to to do is to extract the data from a bug tracking system (possible with both Jira and Bugzilla). Look at any ASF or JBoss Jira or Bugzilla project. –  Marco Feb 18 '12 at 9:37

2 Answers 2

You might want to have a look at Philip Guo's publications (and maybe get into contact). If I remember correctly, he published a few papers for which he had access to data of big bug trackers. http://www.pgbovine.net/academic.htm#pubs

share|improve this answer

Use this presentation:

http://summit.atlassian.com/archives/2012/jira-everywhere/digging-for-gold

to write queries you want against (for example) this database:

http://javafx-jira.kenai.com/

good luck!

share|improve this answer
    
why? What's good about it? How did it help you? Providing links is useful but not any one can google and find them. What google cannot provide is the insight you have and your experience. That's the value added in a good answer. –  Walter Oct 10 '12 at 13:02
    
Thanks for the feedback, @Walter. Like you said, "not anyone can google and find them", so sometimes it useful to provide them for someone. Will do better next time! –  Adam Adamaszek Oct 12 '12 at 19:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.