ontolog-forum
[Top] [All Lists]

Re: [ontolog-forum] ONTOLOG community event planning and scheduling sess

To: "[ontolog-forum] " <ontolog-forum@xxxxxxxxxxxxxxxx>
From: Michael Brunnbauer <brunni@xxxxxxxxxxxx>
Date: Fri, 13 Sep 2013 20:22:24 +0200
Message-id: <20130913182224.GA4740@xxxxxxxxxxxx>

Hello Kingsley,    (01)

On Fri, Sep 13, 2013 at 12:44:07PM -0400, Kingsley Idehen wrote:
> >So I can start a transaction with SPARQL (how do I do that ?), update some
> >data with SPARQL, query the updated data with SPARQL and the others do not
> >see the modified data until I commit the transaction ?
> 
> Yes, of course [1].    (02)

That is cool. And probably quite easy to implement if the underlying backend
is a transactional RDB. But the RDB in this case is just that: A backend
with a fixed schema used to store triples. Connecting to such a backend with
SQL is completely pointless.    (03)

> What is the underlying data model ? What happens to the SQL
> >"table row" if I delete one "triple" from it with SPARQL ?
> I think you are referring to the ability to update SQL Data via a Linked 
> Data view.    (04)

I am referring to this *or* the ability to update RDF data via a SQL view.
The latter may make sense, the former not.    (05)

> If so, we don't offer that off-the-bat, but it has nothing to 
> do with impossibility, its just something we haven't packaged as part of 
> the Linked Data view functionality. In addition, when you have a Linked 
> Data view sitting in front of ODBC or JDBC accessible SQL RDBMS data, we 
> are yet to encounter a customer use-case where updates to the SQL DBMS 
> hosted data via the Linked Data views is a requirement.    (06)

Because it does not make sense. How do you handle the SPARQL INSERT of an
arbitrary triple ? Do you ignore it if it does not match the RDB schema ?
Do you create new tables on the fly ?    (07)

> If we are talking about simply Updating and Deleting triples associated 
> with a Named Graph that works fine.    (08)

Yes - if you decide to use the RDF data model and abandon updating the data 
with SQL in favor of SPARQL.    (09)

Regards,    (010)

Michael Brunnbauer    (011)

-- 
++  Michael Brunnbauer
++  netEstate GmbH
++  Geisenhausener Straße 11a
++  81379 München
++  Tel +49 89 32 19 77 80
++  Fax +49 89 32 19 77 89 
++  E-Mail brunni@xxxxxxxxxxxx
++  http://www.netestate.de/
++
++  Sitz: München, HRB Nr.142452 (Handelsregister B München)
++  USt-IdNr. DE221033342
++  Geschäftsführer: Michael Brunnbauer, Franz Brunnbauer
++  Prokurist: Dipl. Kfm. (Univ.) Markus Hendel    (012)

Attachment: pgpX1qQuDVhbj.pgp
Description: PGP signature


_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/  
Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/  
Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
Shared Files: http://ontolog.cim3.net/file/
Community Wiki: http://ontolog.cim3.net/wiki/ 
To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J    (01)

<Prev in Thread] Current Thread [Next in Thread>