Importing and Exporting RDF Ntriples from IMM
A question that always comes up is how to bulk export and bulk import raw nTriples or RDF/XML into and out of the IMM Semantic Store.
Its actually quite simple. You should open up the RDFQA.exe application in the %Program Files%\Microsoft Interactive Media Manager\Semantic Metadata Store folder, connect to your database, and then execute the following commands.
USE IMM; Export data as [c:/backup/mydata.rdf];
var datas = new DataSource("inet?url=C:\\backup\\mydata.rdf.1&
parsetype=ntriples");
//insert {?p ?s ?o} into data using #datas where {?p ?s ?o};
LOAD {?p ?s ?o} INTO data USING #datas;
As you notice here I commented out the insert command. Insert can be used for small loads, but for larger bulk loads of nTriples or rdf/xml you should use the LOAD command. The LOAD command is targeted at bulk imports.
To parse ntriples, set the parsetype=ntriples. For Rdf/XML set the parsetype=rdf.
