%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+ Generating a Unique ID via SPARQL HTTP Suppose you need unique IDs from within Virtuoso (unique only to a given Virtuoso instance/cluster would suffice), and that this should be done via SPARQL HTTP prior to issuing a SPARQL insert. One solution would be to create a table and procedure that keeps track of an incremental ID and returns each ID only once. Then you can access this procedure via SPARQL HTTP by using: ( SELECT ( bif:foo() ) AS ?id WHERE { ?s ?p ?o } limit 1 ) ---++ An optimized solution Virtuoso's built-in functions (BIFs) [[http://docs.openlinksw.com/virtuoso/fn_sequence_next.html][sequence_next()]] and [[http://docs.openlinksw.com/virtuoso/sequenceobjects.html][sequence_set()]] will streamline this task. Like any other SQL functions without INOUT or OUT parameters, these can be called from SPARQL simply as bif:sequence_next() or bif:sequence_set(), but an IN parameter may be used to get one sequence per graph, i.e., bif:sequence_next("GRAPH_IDENTIFIER"), e.g., bif:sequence_next("<http://my.example.com/graph1>"). SQL> SPARQL INSERT INTO GRAPH { <:a> <:p> `bif:sequence_next("")` } ; callret-0 VARCHAR _______________________________________________________________________________ Insert into , 1 (or less) triples -- done 1 Rows. -- 141 msec. SQL> SPARQL INSERT INTO GRAPH { <:a> <:p> `bif:sequence_next("")` } ; callret-0 VARCHAR _______________________________________________________________________________ Insert into , 1 (or less) triples -- done 1 Rows. -- 4 msec. SQL> SPARQL SELECT * FROM WHERE { ?s ?p ?o } ; s p o VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ :a :p 0 :a :p 1 2 Rows. -- 1 msec. SQL> ---++ Side-note -- bif: prefix vs. sql: prefix For user-defined functions, the sql: prefix is preferred over the bif: prefix; e.g., sql:foo(x) -- will call -- DB.DBA.foo(x) The difference is that bif:foo will make an unqualified call to foo(). If no built-in function foo() exists, and the system contains many users and database qualifiers, the search for exact name of XXX.YYY.foo() adds needless overhead. Further issues may arise if multiple XXX.YYY.foo() procedures have been defined. ---++ Related * [[VirtSPARQLOptGuide][Virtuoso SPARQL Optimization Guide]]