Hello Vanessa,
Finding all graphs on a busy database is indeed a problem.
The most popular way is to "cheat" a bit in hope that every graph
contains at least one triple for some rdf:type of some subject. The
query
SELECT DISTINCT ?g WHERE { GRAPH ?g {?s a ?t}}
has much more changes to complete, a better speed and the result is
usually the same.
Some applications track graphs in their posessions by recording their
names into a dedicated catalog graph. Or, alternatively, SPARUL CREATE
GRAPH statements are used in order to declare all new graphs explicitly,
and the list of graphs can be obtained from
DB.DBA.RDF_EXPLICITLY_CREATED_GRAPH table via SQL query. Both methods
may require some additional coding but the results are simply the
fastest.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
On Thu, 2010-12-02 at 15:01 +0000, Vanessa Lopez wrote:
> Hi all!
>
>
> How can obtain all graph URIs in a given Virtuoso sparql end point?
>
>
> I tried in http://demo.openlinksw.com/sparql with the query
> SELECT DISTINCT ?g
> WHERE { GRAPH ?g {?s ?p ?o}}
>
>
> But it just gives me
> 40001 Error SR172: Transaction deadlocked
> in
> DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS([executable]/sparql.sql:5705),
> <Top Level>
>
> SPARQL query:
> define sql:signal-void-variables 1 SELECT DISTINCT ?g
> WHERE { GRAPH ?g {?s ?p ?o}}
> Thanks!
> Vanessa.
>
> --
> The Open University is incorporated by Royal Charter (RC 000391), an
> exempt charity in England & Wales and a charity registered in Scotland
> (SC 038302).
> ------------------------------------------------------------------------------
> Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
> Tap into the largest installed PC base & get more eyes on your game by
> optimizing for Intel(R) Graphics Technology. Get started today with the
> Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
> http://p.sf.net/sfu/intelisp-dev2dev
> _______________________________________________ Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
