On 9/17/09 18:28 , Sebastian Hellmann wrote:
Yes, thank you,
if this was a forum you could make the mail sticky :)
I will forward it to everybody, who asked me the export question in
the past.
Sebastian
We do have a HowTo section in the VOS wiki. Probably could add this info
there... could also be a case beginning a FAQ section.
Yrjänä
Yrjänä Rankka schrieb:
On 9/17/09 00:31 , Georgi Kobilarov wrote:
*push*
I'd be also very interested in seeing a solution to the question
Sebastian
brought up...
Ok. If you want to dump huge graphs you probably don't want to work
through the regular SPARQL endpoint. There's a little-known PL
procedure that'll do the trick:
create procedure DB.DBA.RDF_GRAPH_TO_TTL (in graph_iri varchar, inout
ses any)
Second argument is a string_output, which is a stream - to make a
long story short, here's a simple stored proc I just cooked up that
would dump a graph to local file system:
create procedure
graph_to_ttl_file (in graph_iri varchar, in f_name varchar)
{
declare ses any;
ses := string_output();
DB.DBA.RDF_GRAPH_TO_TTL (graph_iri, ses);
string_to_file (f_name, ses, 0);
}
Just make sure the f_name has a path component that points somewhere
your Virtuoso is allowed to go in virtuoso.ini - my very dangerous
setting for the test case was:
[Parameters]
DirsAllowed = .,../vad
and then run with something like this:
SQL> graph_to_ttl_file ('http://danbri.org/foaf.rdf',
'danbri-dump.ttl');
Done. -- 10 msec.
SQL>
Voilà!
The RDF_GRAPH_TO_TTL is a bit less efficient that it could be as it
uses old PL functions for things we now have BIFs written in C - it
will be rewritten shortly. It should be useable as is, though.
Let me know how it works for you!
Best Regards,
Yrjänä
Cheers,
Georgi
-----Original Message-----
From: Sebastian Hellmann [mailto:kur...@googlemail.com]
Sent: Wednesday, September 16, 2009 5:15 PM
To: virtuoso-users@lists.sourceforge.net; Michael Martin
Subject: [Virtuoso-users] Virtuoso export
Hello,
what is the best way to export data from Virtuoso.
I want to export a graph,
should I really use SPARQL construct with LIMIT, OFFSET and ORDER BY ?
I just wanted to check in case there is a better function.
Regards,
Sebastian Hellmann, AKSW
-----------------------------------------------------------------------
-------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart
your
developing skills, take BlackBerry mobile applications to market and
stay
ahead of the curve. Join us from November 9-12, 2009. Register
now!
http://p.sf.net/sfu/devconf
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart
your
developing skills, take BlackBerry mobile applications to market and
stay
ahead of the curve. Join us from November 9-12, 2009. Register
now!
http://p.sf.net/sfu/devconf
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Yrjana Rankka | gh...@openlinksw.com
Developer, Virtuoso Team | http://www.openlinksw.com
| Making Technology Work For You
