Hi Viki, What makes you think Virtuoso does not support columns as it is a SQL database as it core, with the RDF/SPARQL support implemented on top of the SQL engine and ultimately stored as SQL. Thus ultimately you can stored your data in Virtuoso as SQL and use its RDF Linked Data Views for mapping Relational data to RDF to enable it to be queries with SPARQL as detailed at:
http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html
http://virtuoso.openlinksw.com/whitepapers/relational%20rdf%20views%20mapping.html
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRdb2RDFViewsGeneration
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 11 Jun 2016, at 16:36, Vikrama Sanjeeva <viki.sanje...@gmail.com> wrote:
>
> Hi Hugh,
>
> Thank you for your prompt response.
>
> Actually, I'm new to semantic web, RDF, SPARQL technologies.
>
> I have three java strings, which I want to save in 3 different columns and
> retrieve like below query:
>
> SELECT col2 ,col2 FROM table1 where col1='str1';
>
> I know as you said I don't need to store in columns (because i think there is
> no column concept in virtuoso).
>
> I just want to know, do I've to form an RDF with three strings (str1, str2,
> str3) and then insert RDF into virtuoso?
>
> Just want to know the high-level steps in doing above, so that I can directly
> explore/understand the required topic.
>
> Bye,
> Viki
>
>
>
>
>
> On Sat, Jun 11, 2016 at 11:10 PM, Hugh Williams <hwilli...@openlinksw.com
> <mailto:hwilli...@openlinksw.com>> wrote:
> Hi Viki,
>
> Virtuoso has Native RDF Storage ( as well as SQL), so you do not need to
> store in SQL columns as you seem to imply in point 1 and can just use SPARQL
> 1.1 to perform inserts/updates/deletes etc directly, see:
>
> http://docs.openlinksw.com/virtuoso/rdfandsparql.html
> <http://docs.openlinksw.com/virtuoso/rdfandsparql.html>
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/#How%20Do%20I%20Load,%20Dump,%20and%20otherwise%20Manage%20Data%20with%20Virtuoso?
>
> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/#How%20Do%20I%20Load,%20Dump,%20and%20otherwise%20Manage%20Data%20with%20Virtuoso?>
>
> which should get you started …
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> <http://www.openlinksw.com/>
> Weblog -- http://www.openlinksw.com/blogs/
> <http://www.openlinksw.com/blogs/>
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> <http://www.linkedin.com/company/openlink-software/>
> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
> Google+ -- http://plus.google.com/100570109519069333827/
> <http://plus.google.com/100570109519069333827/>
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> <http://www.facebook.com/OpenLinkSoftware>
> Universal Data Access, Integration, and Management Technology Providers
>
>> On 11 Jun 2016, at 12:39, Vikrama Sanjeeva <viki.sanje...@gmail.com
>> <mailto:viki.sanje...@gmail.com>> wrote:
>>
>> Hi all,
>>
>> I'm new to Virtuoso database. I've worked with RDBMS (MySQL, Oracle) and
>> good experience in RDBMS databases.
>>
>> However, now my objective to store some data into Virtuoso and rertieve it
>> back using SPARQL.
>>
>> requirement is simple.
>>
>> 1: In RDBMS terms, there are 3 columns, in which data will be stored via
>> java program.
>> 2: SPARQL query will be issued from Virtuoso command line interface (if any)
>> to retrieve/select data based on condition.
>>
>> Please advise if there is any tutorial to start with ?
>>
>>
>> Bye,
>> Viki.
>>
>> ------------------------------------------------------------------------------
>> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
>> patterns at an interface-level. Reveals which users, apps, and protocols are
>> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
>> J-Flow, sFlow and other flows. Make informed decisions using capacity
>> planning reports.
>> https://ad.doubleclick.net/ddm/clk/305295220;132659582;e_______________________________________________
>>
>> <https://ad.doubleclick.net/ddm/clk/305295220;132659582;e_______________________________________________>
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> <mailto:Virtuoso-users@lists.sourceforge.net>
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
>
>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
