Re: [Virtuoso-users] Storing & retrieving data into virtuoso?

2016-06-11 Thread Hugh Williams
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 ma

Re: [Virtuoso-users] Storing & retrieving data into virtuoso?

2016-06-11 Thread Vikrama Sanjeeva
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 st

Re: [Virtuoso-users] Storing & retrieving data into virtuoso?

2016-06-11 Thread Hugh Williams
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:/

[Virtuoso-users] Storing & retrieving data into virtuoso?

2016-06-11 Thread Vikrama Sanjeeva
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