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 <medha.a...@gmail.com> 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 <hwilli...@openlinksw.com>
> 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. // 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
>>
>> [1] http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html
>> [2] http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSSQL2RDF
>> [3] http://virtuoso.openlinksw.com/features-comparison-matrix/
>> [4] http://virtuoso.openlinksw.com/download
>>
>> On 4 Aug 2014, at 12:20, Medha Atre <medha.a...@gmail.com> wrote:
>>
>> 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
>>
>> ------------------------------------------------------------------------------
>> Infragistics Professional
>> Build stunning WinForms apps today!
>> Reboot your WinForms applications with our WinForms controls.
>> Build a bridge from your legacy apps to the future.
>> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
