[Virtuoso-users] Obtain all graphs

2010-12-02 Thread Vanessa Lopez
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

Re: [Virtuoso-users] Obtain all graphs

2010-12-02 Thread Hugh Williams
Hi Vanessa, Please use the following special function for obtaining a list of available graphs in Virtuoso: DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() Which can be run from an isql command line prompt or the Virtuoso conductor SQL interface. Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] Obtain all graphs

2010-12-02 Thread Ivan Mikhailov
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,