I have recently joined the Computer Science department of TELECOM SudParis as an intern. My job is to integrate Triplify and Bugzilla in order to create semantic data. In other words, I have to export data from the Bugzilla database to an RDF file. All this is possible due to Triplify, a php script that can be configured to query given tables from a specified database.

The main part is the definition of a number of SQL queries selecting information that is meant for public use. In order for Triplify to be able to convert the results of your SQL queries into RDF, the query results are required to have a certain structure.

This is the classmap for the database tables queried by Triplify (class->table):

• bom:Issue -> bugs
• bom:product -> products
• bom:component -> components
• bom:milestone -> milestones
• bom:computersystem -> op_sys + rep_platform
• sioc:User -> profiles
• foaf:Person -> profiles

The main vocabulary used for the Bugzilla triplification is EvoOntBom, with occasional Bugzilla specific classes found in heliosBtOntology.

If you want to see the RDF+n3 output, please click here.

If you find this stuff interesting, don’t hesitate to contact me for more info. The full WiKi page can be found on the project website.

Andrei~