A gentle reminder. Can someone please help me with this?
On Fri, Sep 20, 2013 at 7:58 PM, Rose Beck
I am trying to load data (from myfile, the format of myfile is explained below) into monetdb using itsSQL interface. mytable format:
1 2 3 5 7 8 8 2 3.....
The commands which I am using for performing the same are given below:
sql> create table mytable(subject integer, property integer, object integer);
sql> copy 10000000 records into mytable from myfile delimiter ' ','\n';
For each property value (i.e. middle column) I create a separate table:
create table prop1(subject integer, object integer); create table prop2(subject integer, object integer); create table prop3(subject integer, object integer); ...
and then fill these tables using the following commands:
INSERT into prop1 SELECT subject, object FROM triples_table where property=prop1 ORDER BY subject, object;
Is there some way to automate this process. i.e. right now I am manually creating a separate table for all the distinct properties (using create table prop1(subject integer, object integer); ) and then filling this table using insert command (INSERT into prop1 SELECT subject, object FROM triples_table where property=prop1 ORDER BY subject, object; ). Is there some way by which I may automate this procedure.
One of the methods which I know of is to create a C++/python program and then call all functions like "create table" by using shell script. But is there a faster method to achieve the same.
Also can you please guide as to how can I create and integrate dictionary (RDF: id to string mapping) to sql queries?