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, because I tried all same command, "autogen.sh", "configure", "make", "make install", by just omitting the "--program-transform-name" option, and the binaries got generated correctly in the "prefix" path bin folder. I missed the last "/" in the regex for program-transform-name. But to my surprise the entire installation process completed without error, so it was hard to detect. Thanks. Medha On Mon, Aug 4, 2014 at 6:45 PM, Hugh Williams <hwilli...@openlinksw.com> 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 <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
