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 the strings or URIs/IRIs).
I was following the RDF performance tuning instructions given at
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning
for Virtuoso, and I am confused about two points -
1) What is the difference between datatype IRI_ID_8 and INTEGER?
2) If I want to use INTEGER datatype in my tables (e.g. "CREATE TABLE
rdftest (S INTEGER, P INTEGER, O INTEGER, PRIMARY KEY (P,S,O)
COLUMN)"), how should the ALTER INDEX command like "ALTER INDEX rdf_s
ON rdftest PARTITION (S INT (0hex00));" be re-written? What does
"S INT (0hex00)" do? Does it depend on the datatype of the column
or does it only specify the blocksize of partition?
Could you please clarify this to me?
Thanks.
Medha
On Mon, Aug 4, 2014 at 6:45 PM, Hugh Williams wrote:
> 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 with the CVS loader:
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtCsvFileBulkLoader
>
> The following white paper details the Virtuoso RDF Quad Store implementation
> on top of its SQL engine:
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSRDFWP
>
> What does make or make install report then, I assume the compilation is
> completed with out errors and you are running make install as a user that
> has access to the location you are seeking to install to ? Is there a
> Virtuoso binary in ~/binsrc/virtuoso/virtuoso-t as that would confirm the
> compilation at least completed successfully ?
>
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 4 Aug 2014, at 13:07, 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 is added "on top of it", am I right? So I want to use the native
> relational DB.
>
> E.g. I want to load a relational table with say 5 columns A, B, C, D,
> E in Virtuoso and run SQL queries on that data directly by creating
> indexes etc.
>
> No RDF conversion required!
>
> I have a couple more questions/problems. My next question is unrelated
> this the previous one.
>
> 1. If I want to load RDF data into Virtuoso opensource, are strings
> and URIs in the RDF database mapped first to hash or integer (or some
> IDs), and stored in that form? If yes, then if I run a SPARQL query,
> say "select ?s ?o where {?s ?p ?o}", can I get values of ?s and ?o in
> the hash or integer ID forms instead of string or URI forms? (This is
> for the sake of measuring the "raw" query evaluation speed of
> Virtuoso, where I do not want to account for the "ID --> String"
> conversion time.
>
> 2. I tried to compile and setup Virtuoso-opensource 7.1 on Ubuntu
> 12.04 LTS. I ran "autogen.sh", and "./configure
> --prefix=/work/tools/virtinstall
> --program-transform-name="s/isql/isql-v", and then "make", and "make
> install", but even after all the steps completing successfully, I have
> an EMPTY "bin" directory under "/work/tools/virtinstall" (the "prefix"
> install path given to the configure script).
>
> Why is this happening? The "autogen", "configure", and "make" do not
> show any errors, and all the required dependencies as mentioned on
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSMake#Package%20Dependencies
> are installed on my machine!
>
> Could you please let me know answers of these questions?
>
> Thanks.
> Medha
>
>
>
> On Mon, Aug 4, 2014 at 5:46 PM, Hugh Williams
> wrote:
>
> 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 from [4].
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. //