This HTML5 document contains 9 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

Prefix	IRI
wdrs	http://www.w3.org/2007/05/powder-s#
schema	http://schema.org/
n5	https://www.openlinksw.com/about/id/entity/urn/data:openlink:
n6	https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/data/turtle/general/
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n7	https://www.openlinksw.com/about/id/entity/urn/webdev:
xsdh	http://www.w3.org/2001/XMLSchema#
n2	http://data.openlinksw.com/oplweb/faq/Virtuoso/DeterminingInvalidIRIsAnswer#

Statements

Subject Item

n2:this

wdrs:describedby

n5:products n6:virtuoso-general-faq-2023.ttl n7:virtuoso

schema:name

Answer to question: How do I determine if there are invalid IRIs in my Virtuoso DBMS? Answer to question: How do I determine if there are invalid IRIs in my Virtuoso DBMS?

rdf:type

schema:Answer

schema:answerExplanation

Run the following SQL commands. SELECT COUNT(*) FROM RDF_QUAD q WHERE not exists (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.G); SELECT COUNT(*) FROM RDF_QUAD q WHERE not exists (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.P); SELECT COUNT(*) FROM RDF_QUAD q WHERE is_named_iri_id(q.S) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.S); SELECT COUNT(*) FROM RDF_QUAD q WHERE is_named_iri_id(q.O) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.O) SELECT TOP 5 ID_TO_IRI(G) FROM RDF_QUAD q WHERE is_named_iri_id(q.S) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.S); Run the following SQL commands. SELECT COUNT(*) FROM RDF_QUAD q WHERE not exists (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.G); SELECT COUNT(*) FROM RDF_QUAD q WHERE not exists (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.P); SELECT COUNT(*) FROM RDF_QUAD q WHERE is_named_iri_id(q.S) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.S); SELECT COUNT(*) FROM RDF_QUAD q WHERE is_named_iri_id(q.O) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.O) SELECT TOP 5 ID_TO_IRI(G) FROM RDF_QUAD q WHERE is_named_iri_id(q.S) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.S); Run the following SQL commands. SELECT COUNT(*) FROM RDF_QUAD q WHERE not exists (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.G); SELECT COUNT(*) FROM RDF_QUAD q WHERE not exists (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.P); SELECT COUNT(*) FROM RDF_QUAD q WHERE is_named_iri_id(q.S) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.S); SELECT COUNT(*) FROM RDF_QUAD q WHERE is_named_iri_id(q.O) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.O) SELECT TOP 5 ID_TO_IRI(G) FROM RDF_QUAD q WHERE is_named_iri_id(q.S) AND NOT EXISTS (SELECT 1 FROM RDF_IRI i WHERE i.RI_ID=q.S);