Checking RDF index have been repaired
The following operations can be performed to verify the RDF indexes on the RDF_QUAD table repaired by either of the above methods have been fixed.
Database Integrity Check
Run a database integrity with the command:
backup '/dev/null';
Check RDF index counts
First check with the following count queries on all the indexes on the RDF_QUAD table by running the following queries for Virtuoso:
select count (*) from rdf_quad a table option (index rdf_quad) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_pogs, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index primary key, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_op, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_sp, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_gs, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
Attributes | Values |
---|
type
| |
described by
| |
name
| |
description
| - Checking RDF index have been repaired
The following operations can be performed to verify the RDF indexes on the RDF_QUAD table repaired by either of the above methods have been fixed.
Database Integrity Check
Run a database integrity with the command:
<code>backup '/dev/null';</code>
Check RDF index counts
First check with the following count queries on all the indexes on the RDF_QUAD table by running the following queries for Virtuoso:
<pre>
select count (*) from rdf_quad a table option (index rdf_quad) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_pogs, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index primary key, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_op, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_sp, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
select count (*) from rdf_quad a table option (index rdf_quad_pogs) where not exists (select 1 from rdf_quad b table option (loop, index rdf_quad_gs, no exists join) where a.g = b.g and a.p = b.p and a.o = b.o and a.s = b.s);
</pre>
|
schema:nextItem
| |
position
| |
is topic
of | |
is schema:nextItem
of | |
is schema:step
of | |
Faceted Search & Find service v1.17_git149 as of Dec 03 2024
OpenLink Virtuoso version 08.03.3331 as of Aug 25 2024, on Linux (x86_64-ubuntu_noble-linux-glibc2.38-64), Single-Server Edition (378 GB total memory, 40 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2025 OpenLink Software