Re: [Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

2015-12-10 Thread Thomas Michaux 

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 :


 
  "Part III: a sharp result on the 
lack of uniform 
stabilization"^^ .
 
  "The existence and unicity 
problem for 
bases"^^ .
 
  "System of non linear ordinary 
differential 
equations"^^ .
 
  "Experiences in LAN and WAN 
environments"^^ .


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 
 where {

 GRAPH ?graph {
 
 ?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 
 
where 
{ 
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  wrote:

in SPARQL : select ?titre (DATATYPE(?titre ))from 
 
where 
{ 
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",

Re: [Virtuoso-users] Fwd: Re: Problems using +backup-dump from Virtuoso 6 to Virtuoso 7 with +restore-crash-dump

2015-12-08 Thread Thomas Michaux 

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 > wrote:


in SPARQL : select ?titre (DATATYPE(?titre ))from 
 
where 
{ 
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
___

#i232 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 
Pour : 	virtuoso-users@lists.sourceforge.net 


Copie à :   Hugh Williams 



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) :




  "Variants of nonlinear normal form observer 
design"^^  .




--
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=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users