-----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'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).
>
It looks to like you're trying to "optimize" handling RDF by using our
own reader, replacing IRIs with integer IDs in a regular table.
However, Virtuoso already does that, and more. You might be trying to
reinvent the wheel here.
The RDF_QUAD table already replaces all IRIs with an IRI_ID native
datatype which supports lookups for the original serialization. There
is a virtuoso function iri_to_id, as well as its reverse which map
between the IDs and their string serialization.
AFAIK there are index compression methods that work specifically for
RDF, which you might be losing there as well, resulting in larger
working set, and hence (if you are limited by RAM, and disk seeks need
to be done) several orders of magnitude slower performance.
If you want to just run SQL on the quads, you are free to do so - the
RDF_QUAD table is just that - a table:
select id_to_iri(p) from RDF_QUAD where s = iri_to_id
('http://dbpedia/resource/Berlin'); -- get all predicates of Berlin
Though the SPARQL compiler often does better job than you or me would
to produce optimised (and a lot more difficult to read) SQL from
SPARQL queries.
Yrjänä
> 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
>>
>>
>
> ------------------------------------------------------------------------------
>
>
Want excitement?
> Manually upgrade your production database. When you want
> reliability, choose Perforce. Perforce version control. Predictably
> reliable.
> http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
>
>
_______________________________________________
> Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
- --
Yrjänä Rankka (gh...@zonk.net)
Grand Praetor of Excruciations - ZONK.NET Propaganda HQ
ZONK.NET - Advancing the Thermal Death of the Multiverse Since 1998
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBCgAGBQJUDtAwAAoJEPwzzlnBROJ7KYwQAKy54Fl/6PDc+JiTAOwk6Je+
Kf2Ld/qKFOzmQeUsyqNX9quOad0Y6c27n1WguWEEuS4y/iWTjSSHqLo1gLLz8W7y
BuIjno2WC9V1oQ60rowipYGN1+QvIy6LH8LFF19xUrmWNts14kF8vT3LKcRSU3EL
REBeh1ZTbQZORKfJNFRBt3AB9yOIuxG4/uXNvbB9F6e9nEhGpjp4MsnFtpun/qMI
Are7r0QMXve1nEZAq8l9JGrso6LFfxwd6LYPyq5SRzpDb++9B8zpiZ5Vy3XsSBTP
2YuS/wgTeElNz5rwXNV4LO5Rg8efR6XZEZNyVrk0rnPBa5N17OA3vyDRH0Zki6XJ
afKoZW3eLjTpUmplgTOjG8QQrtmZEYIwp7adNP4MuLWAUUzc8qgs2z7G+ZPStb0k
yYKGNiu5/iEPz0dM+nzGBeJ9zmnzZLAAFJHfpPCul3MNOM+14uZGY4H9p3tTmNrS
03ezKojX1mCpMRsfvjkgveOa1LEsJKUrySsSCrGrIXfz0C1e+h/7nlN+tjw28ALc
w49/JslDZ2CvjA65sCd2uOlz1UOhL7HGW6YzitjuwmNv6YGWP7c5mipdKWaIi4+m
dZWgQ9Yel/MaA0EoHPo6/gCYnQtuLyuL3rpu6RSRMM/JXO+6S9vwqxKt1mr8dOb9
qTseQnuz1EBLQ0kHGGpX
=sT+Y
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
