On Sat, Sep 21, 2013 at 12:00 PM, <users-list-request@monetdb.org> wrote:

Send users-list mailing list submissions to
users-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request@monetdb.org

You can reach the person managing the list at
users-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."

Today's Topics:

1. Re: How to automate creation of property tables in monetdb?
(Rose Beck)
2. Re: How to automate creation of property tables in monetdb?
(Martin Kersten)

----------------------------------------------------------------------

Message: 1
Date: Sat, 21 Sep 2013 11:49:10 +0530
From: Rose Beck <rosebeck.82@gmail.com>
To: users-list@monetdb.org
Subject: Re: How to automate creation of property tables in monetdb?
Message-ID:
<CAPx9ze9DR0bmy9joSZewwrSL_UNQGP=HefZLHax=WZAAfDK3Cw@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

A gentle reminder. Can someone please help me with this?

On Fri, Sep 20, 2013 at 7:58 PM, Rose Beck <rosebeck.82@gmail.com> wrote:

> 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?
> <users-list@monetdb.org>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20130921/2c158a0f/attachment-0001.html>

------------------------------

Message: 2
Date: Sat, 21 Sep 2013 08:30:31 +0200
From: Martin Kersten <Martin.Kersten@cwi.nl>
To: users-list@monetdb.org
Subject: Re: How to automate creation of property tables in monetdb?
Message-ID: <523D3D07.5020201@cwi.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 9/21/13 8:19 AM, Rose Beck wrote:
> A gentle reminder. Can someone please help me with this?
Consult your SQL background. You should know that SQL standard does not
permit/support conversion of string-expressions into table-names.

RDF processing and its catalog management is not an integral part
of the system, there is no RDF base type.

good luck. Martin
>
>
>
>
> On Fri, Sep 20, 2013 at 7:58 PM, Rose Beck <rosebeck.82@gmail.com
> <mailto:rosebeck.82@gmail.com>> wrote:
>
> I am trying to load data (from myfile, the format of myfile is
> explained below) into monetdb using its|SQL|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> copy10000000 recordsinto mytablefrom 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:
>
> |INSERTinto prop1 SELECT subject, object FROM triples_tablewhere
> 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?
>
> <mailto:users-list@monetdb.org>
>
>
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>

------------------------------

Subject: Digest Footer

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list

------------------------------

End of users-list Digest, Vol 13, Issue 16
******************************************