Not logged in : Login
(Sponging disallowed)

About: Answer to question: How do I determine if there are invalid IRIs in my Virtuoso DBMS?     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:Answer, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=http%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Ffaq%2FVirtuoso%2FDeterminingInvalidIRIsAnswer%23this

AttributesValues
described by
title
  • 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?
type
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);
is topic of
is about of
is acceptedAnswer of
Faceted Search & Find service v1.17_git122 as of Jan 03 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 25 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software