Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-10-02 Thread Yrjänä Rankka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 On 09/09/2014 08:35, Medha Atre wrote: > Hi Hugh, > > This is in reference to our previous conversation about using > Virtuoso as a pure DB store and using SQL commands. > > Basically I want to upload my own raw integer valued 3-column > table (it'

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-09-09 Thread Medha Atre
Hi Hugh, I was also trying to use the bulk loader script that you pointed me to http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtCsvFileBulkLoader. I have a table created as "CREATE TABLE rdftest (s INT, p INT, o INT);" My sample data looks like follows (the directory where data is

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-09-09 Thread Medha Atre
Hi Olivier, Thanks, but I don't think this addresses my question. I do not want to use Druid (or any such utility), because it's more about my own understanding of the "alter index" and "create index" commands and their effect on data organization in of Virtuoso, than having a GUI based tool to do

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-09-09 Thread Olivier Rossel
I might be off-topic, but Druid (http://druid.sourceforge.net/) has always been a life saver when I have to deal with an unknown database. Roughly, you launch the jar by a java -jar druid.jar, and then point it to the JDBC driver of your database, and you can do most of the things you need (loadin

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-09-08 Thread Medha Atre
Hi Hugh, This is in reference to our previous conversation about using Virtuoso as a pure DB store and using SQL commands. Basically I want to upload my own raw integer valued 3-column table (it's RDF data parsed and converted to integer IDs, as I don't want Virtuoso or any system to deal with th

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-08-04 Thread Kingsley Idehen
On 8/4/14 1:07 PM, Medha Atre wrote: I do NOT want to map relational data to RDF! I simply want to use Virtuoso opensource as_a relational DB_! But all the tutorials and instruction pages have only information of handling RDF data. I believe Virtuoso is a native relational DB and support for RDF

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-08-04 Thread Medha Atre
Hi Hugh, Thanks a lot for the links. I will check them out. Yes, I am looking for standard ANSI SQL data loading (my tables will have mostly integers only). For the "installation" problem, actually I believe it has something to do with the "--program-tranform-name" param given to configure, becau

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-08-04 Thread Hugh Williams
Hi Medha, What then is the form of the SQL data you are seeking to load, as if standard ANSI SQL you are seeking to load this can done using the "load" command of the isql command line tool: http://docs.openlinksw.com/virtuoso/isql.html#isqlcommands or if in CVS form it can be loaded w

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-08-04 Thread Medha Atre
I do NOT want to map relational data to RDF! I simply want to use Virtuoso opensource as _a relational DB_! But all the tutorials and instruction pages have only information of handling RDF data. I believe Virtuoso is a native relational DB and support for RDF is added "on top of it", am I right?

Re: [Virtuoso-users] Loading relational data into Virtuoso

2014-08-04 Thread Hugh Williams
Hi Medha, Virtuoso open source does not have the necessary Virtual Database (VDB) support for mapping relational databases (transiently or persistently) to RDF using Virtuoso Linked Data Views [1][2] , as this is a commercial only feature [3]. The commercial product is for evaluation download f

[Virtuoso-users] Loading relational data into Virtuoso

2014-08-04 Thread Medha Atre
Hi, I want to use the opensource edition of Virtuoso to load relational data into it, create indexes, and run SQL queries on it. Can someone point me to a tutorial or instructions for it? I mostly came across instructions for RDF data loading. Thanks in anticipation. Medha -