Monthly Archives: July 2009

General

Bad Free.fr!

July 28, 2009 – 7:05 PM

When testing a little program that I’ve made, called ptool (more info here), I have found out that the LAN interface of my ADSL router was operating in promiscuous mode. The router is a standard issue from Free.fr.

I have no reason why this would happen, especially on the LAN port. If this is common practice from Free, then I might even be forced to change ISP. I’m curious how many other providers snoop on their users’ LANs.

If you’re curious whether or not your ISP is listening to your LAN traffic, you could try downloading and running the program that I’ve written. I think it currently supports most linux distributions and might work on Solaris and Mac OS too (not sure if that’s the case for the latest build though).

Please let me know what you find. I really want to get to the bottom of this!

Andrei~

Tags , , , , , | Permalink | Comment (0)
Linked Data

Triplifying Bugzilla

July 28, 2009 – 5:48 PM

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~

Tags , , | Permalink | Comment (0)
General

Welcome!

July 28, 2009 – 2:04 PM

Welcome to my den!

I am starting this personal blog so I can keep track of the recent and future events from my personal life. Please enjoy yourselves and have a great time!



Andrei~

Tags , | Permalink | Comment (0)