one more bad news :(
this time I tried with the dump_one_graph_nt procedure from V6 (because
in V6 dump_nquads() calls the http_nquad() function which is not available)
I then checked with grep that the dump file for the graph (72Mo)
contained the XMLLiteral literals, and it has, here are few examples lines :
<http://www.hub.abes.fr/springerB/ebook/3540192379/chapter/37/w>
<http://dbpedia.org/ontology/subtitle> "Part III: a sharp result on the
lack of uniform
stabilization"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
<http://www.hub.abes.fr/springerB/ebook/3540192379/chapter/86/w>
<http://dbpedia.org/ontology/subtitle> "The existence and unicity
problem for
bases"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
<http://www.hub.abes.fr/springerB/ebook/3540544089/chapter/22/w>
<http://dbpedia.org/ontology/subtitle> "System of non linear ordinary
differential
equations"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
<http://www.hub.abes.fr/springerB/ebook/3540761691/chapter/11/w>
<http://dbpedia.org/ontology/subtitle> "Experiences in LAN and WAN
environments"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
Then, I imported in V7 from this file using bulkloader :
ld_dir('/LN_Hupe', '*.nt',
'http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV');
rdf_loader_run();
....but still got the problem when querying in V7 with DATATYPE
returning http://www.w3.org/2001/XMLSchema#string (instead of
http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral ), for example
same "Subject" uri and same predicate in query from the first example
above :
select ?graph ?titre (DATATYPE(?titre ))from
<http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV> where {
GRAPH ?graph {
<http://www.hub.abes.fr/springerB/ebook/3540192379/chapter/37/w>
<http://dbpedia.org/ontology/subtitle> ?titre
}
}
graph titre callret-2
http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV
"???� rootzPart III: a sharp result on the lack of uniform
stabilization" http://www.w3.org/2001/XMLSchema#string
...hope it will help to investigate
Thomas
Le 08/12/2015 16:13, Thomas Michaux a écrit :
Hugh, new information : same type error when copying V6 virtuoso.db in
a clean "row store original" V7 , we lost XMLLiteral present in V6 datas :
select ?titre (DATATYPE(?titre ))from
<http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV>
where
{<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
dcterms:title ?titre}
returns
titre callret-1
"???� rootbVariants of nonlinear normal form observer design"
http://www.w3.org/2001/XMLSchema#string
so now we can exclude error during the row to column store procedure.
Thomas
Le 08/12/2015 15:34, Thomas Michaux a écrit :
Le 08/12/2015 14:03, Hugh Williams a écrit :
Hi Thomas,
Don’t know what you mean by " pbs on datas” ???
I assume this spurious chars at the beginning of the strings ?
yes (triple count is ok in V7/V7, no RDF data loss)
Are you saying this string values where XMLLiteral in vs but are now
XMLSchema#string in v7 , which may be the cause ?
yes XMLLiteral in V6 (via DATATYPE function call) and
XMLSchema#string in V7
Did you convert the RDF_QUAD table to column store mode also ?
yes
As would be interesting to know if this occurred when it was in v7
row store original mode also …
i will check this and provide information
Have you tried dumping and reloading the RDF Quad data as also
suggested as an alternative previously ? ie
not at the moment but i will do as "plan B" if we have the same
missing types in V7 row store test
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 8 Dec 2015, at 11:55, Thomas Michaux <mich...@abes.fr> wrote:
in SPARQL : select ?titre (DATATYPE(?titre ))from
<http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV>
where
{<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
dcterms:title ?titre}
V7 result :
titre callret-1
"???� rootbVariants of nonlinear normal form observer design"
http://www.w3.org/2001/XMLSchema#string
V6 result:
titre callret-1
Variants of nonlinear normal form observer design
http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral
Thomas
Le 08/12/2015 12:42, Thomas Michaux a écrit :
when we compare the datatypes from V6 and v7 it seems we'd lost
the "strong" typing in V6 to a "generic" V7 type
http://www.w3.org/2001/XMLSchema#string :
SELECT DB.DBA.RDF_DATATYPE_OF_OBJ( "s_1_1_t0"."O") AS
"titre_datatype", DB.DBA.RDF_LANGUAGE_OF_OBJ( "s_1_1_t0"."O") AS
"titre_langage"
FROM DB.DBA.RDF_QUAD AS "s_1_1_t0"
WHERE
"s_1_1_t0"."G" = __i2idn ( __bft(
'http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV'
, 1))
AND
"s_1_1_t0"."S" = __i2idn ( __bft(
'http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w'
, 1))
AND
"s_1_1_t0"."P" = __i2idn ( __bft(
'http://purl.org/dc/terms/title' , 1))
OPTION (QUIETCAST)
V7 :
titre_datatype titre_langage
LONG VARCHAR LONG VARCHAR
_______________________________________________________________________________
http://www.w3.org/2001/XMLSchema#string BLOB 0 chars
1 Rows. -- 2 msec.
V6 :
titre_datatype titre_langage
LONG VARCHAR LONG VARCHAR
_______________________________________________________________________________
#i2320000 BLOB 0 chars
1 Rows. -- 1 msec.
Thomas
-------- Message transféré --------
Sujet : Re: [Virtuoso-users] Problems using +backup-dump from
Virtuoso 6 to Virtuoso 7 with +restore-crash-dump
Date : Tue, 8 Dec 2015 11:16:32 +0100
De : Thomas Michaux <mich...@abes.fr>
Pour : virtuoso-users@lists.sourceforge.net
<virtuoso-users@lists.sourceforge.net>
Copie à : Hugh Williams <hwilli...@openlinksw.com>
Important precision,
we have focused this problems on a specific type of literals :
Je dois préciser que le pb concerne des données de type
Littéraux XML
(http://www.w3.org/TR/REC-rdf-syntax/#section-Syntax-XML-literals) :
<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
<http://purl.org/dc/terms/title> "Variants of nonlinear normal form observer
design"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
