Inserting data from a SPARQL endpoint into a relational database - bobdc.blog

Inserting data from a SPARQL endpoint into a relational database - bobdc.blog: "Inserting data from a SPARQL endpoint into a relational database
27 April 2011


Via XML.
Retrieval of triples from relational databases is a popular topic in the semantic web world, but I was recently wondering how much trouble it would be to go in the opposite direction: to retrieve data from a SPARQL endpoint and load it into a relational database. It wasn't much trouble at all. When you retrieve the results in the SPARQL query results XML format, a straightforward XSLT spreadsheet can convert it into the necessary SQL INSERT statements. I was able to automate the data retrieval, conversion to INSERT statements, and actual insertion into a MySQL database with a three-line batch file that used no Windows-specific tricks, so I'm sure it would work on Linux just as well."