Menu
▾
▴
Re: [d2rq-dev] dump-rdf and postgresql: all is all
|
From: Diogo FC P. <djo...@gm...> - 2013-10-08 18:16:50
|
Hi Richard Now I'm able to dump data correctly. Thanks a lot! -- diogo patrão On Wed, Sep 25, 2013 at 4:58 AM, Richard Cyganiak <ri...@cy...>wrote: > On 24 Sep 2013, at 23:06, Kārlis Čerāns <kar...@lu...> wrote: > > would it be possible to get the latest version of the "master" branch > for Windows, if it is going to appear somewhere? > > I've built a snapshot and made it available for download: > http://download.d2rq.org/d2rq-master-snapshot-20130925.zip > > (I've not tested it at all, so let me know if something is horribly broken > with the build.) > > > We are currently using r2rml preview version in our development, not for > reason of r2rml but rather due to some bugs present in 0.8.1. re property > discriminated subclasses (on MS SQL Server); something along the lines of > https://github.com/d2rq/d2rq/issues/154 (r2rml preview works fine in our > case). > > Yes, this issue was fixed on both branches, and both for SQL Server and > Oracle. > > Best, > Richard > > > > > > Thanks, > > Karlis Cerans > > > > On 22.09.2013 18:59, Richard Cyganiak wrote: > >> Diogo, > >> > >> I dug a bit deeper and fixed the underlying problem, both on the master > and on the develop branch. > >> > >> The issue was this: When we have a SQL table or SQL result with a > column of type BOOL, then the The PostgreSQL JDBC driver reports the type > of that column as BIT(1), but the values in the column will still be "t" > and "f" as in PostgreSQL. This confused D2RQ, which expects BIT(1) columns > to actually contain bit strings. As a result, any value of such a column > ended up being interpreted as true. > >> > >> The fix: When on PostgreSQL, we now inspect the reported JDBC type name > for BIT columns. If it is "BOOL", then we know that the column is actually > of a boolean type, and treat it as such. > >> > >> So I recommend that you get the latest version of the "master" branch > (if you use SPARQL) or of the "develop" branch (if you only use dump-rdf) > from git, and build it. If you're not set up to get code from git and build > it yourself, then just let me know, and I'll upload a build somewhere for > you. > >> > >> Best, > >> Richard > >> > >> > >> On 21 Sep 2013, at 19:10, Richard Cyganiak <ri...@cy...> wrote: > >> > >>> Hi Diogo, > >>> > >>> I've been able to reproduce the problem. It's an issue with the > interpretation of boolean results in D2RQ v0.8.1. The issue has been fixed > on the develop branch as part of the engine re-implementation, but the > problem is still present on the master branch. > >>> > >>> For now, I recommend you use the R2RML preview build, which is a > snapshot of the develop branch: > >>> http://download.d2rq.org/d2rq-r2rml-preview-v4.tar.gz > >>> > >>> It fixes this particular problem, and dump-rdf is reliable on develop. > I don't recommend this version for use with SPARQL yet. > >>> > >>> (In your mapping, where it has dtnasc, you probably meant rhc.dtnasc?) > >>> > >>> Best, > >>> Richard > >>> > >>> > >>> On 20 Sep 2013, at 20:55, Diogo FC Patrao <djo...@gm...> > wrote: > >>> > >>>> Hi Richard, > >>>> > >>>> Have my mapping cleared something? > >>>> > >>>> If you need anything else, let me know. > >>>> > >>>> Thanks, > >>>> > >>>> -- > >>>> diogo patrão > >>>> > >>>> > >>>> > >>>> > >>>> On Tue, Sep 17, 2013 at 9:00 AM, Diogo FC Patrao < > djo...@gm...> wrote: > >>>> Hi Richard > >>>> > >>>> I'm providing a minimal example of a problematic map and there you go > - two classmaps. > >>>> > >>>> If I dump-rdf the mapping below, I get 36086 instances of both > classes vocab:PacienteMaiorDe18Anos and vocab:Quimioterapia; however, if I > comment out the first mapping (map:18a), I end up with 10625 instances of > vocab:Quimioterapia. Which is correct. When I use the same mapping on > D2R-server, and run a SELECT count(*) on each class, I got 36086 for > PacienteMaiorDe18Anos and 10625 for Quimioterapia. > >>>> > >>>> I thought that it would get the first class map instances and apply > the other classes to all of them. However, if I swap the order, I get the > same results as above. > >>>> > >>>> Let me know if you need further details. > >>>> > >>>> dfcp > >>>> > >>>> > >>>> @prefix map: <#> . > >>>> @prefix db: <> . > >>>> @prefix vocab: < > http://www.cipe.accamargo.org.br/ontologias/estudo_clinico.owl#> . > >>>> @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . > >>>> @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . > >>>> @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . > >>>> @prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> . > >>>> @prefix d2r: < > http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> . > >>>> @prefix jdbc: <http://d2rq.org/terms/jdbc/> . > >>>> > >>>> > >>>> <> a d2r:Server; > >>>> rdfs:label "rhc"; > >>>> d2r:sparqlTimeout 0; > >>>> d2r:port 2024; > >>>> . > >>>> > >>>> > >>>> map:database a d2rq:Database; > >>>> d2rq:jdbcDriver "org.postgresql.Driver"; > >>>> d2rq:jdbcDSN "jdbc:postgresql://localhost/bancos_clinicos"; > >>>> d2rq:username "whatever"; > >>>> d2rq:password "whatever"; > >>>> jdbc:autoReconnect "true"; > >>>> jdbc:zeroDateTimeBehavior "convertToNull"; > >>>> . > >>>> > >>>> # > >>>> # > >>>> # > >>>> map:18a a d2rq:ClassMap; > >>>> d2rq:dataStorage map:database; > >>>> d2rq:uriPattern " > http://www.cipe.accamargo.org.br/ontologias/estudo_clinico.owl#paciente/@@rhc.rgh_mv@@ > "; > >>>> d2rq:class vocab:PacienteMaiorDe18Anos; > >>>> d2rq:containsDuplicates "true"; > >>>> d2rq:condition "dtnasc < now() - interval '18 year'"; > >>>> . > >>>> > >>>> map:qt a d2rq:ClassMap; > >>>> d2rq:dataStorage map:database; > >>>> d2rq:uriPattern " > http://www.cipe.accamargo.org.br/ontologias/estudo_clinico.owl#paciente/@@rhc.rgh_mv@@ > "; > >>>> d2rq:class vocab:Quimioterapia; > >>>> d2rq:containsDuplicates "true"; > >>>> d2rq:condition "rhc.quimio like '1%'"; > >>>> . > >>>> > >>>> > >>>> > >>>> > >>>> -- > >>>> diogo patrão > >>>> > >>>> > >>>> > >>>> > >>>> On Tue, Sep 10, 2013 at 2:37 PM, Diogo FC Patrao < > djo...@gm...> wrote: > >>>> Yes, 0.8.1. > >>>> > >>>> -- > >>>> diogo patrão > >>>> > >>>> > >>>> > >>>> > >>>> On Tue, Sep 10, 2013 at 2:33 PM, Richard Cyganiak < > ri...@cy...> wrote: > >>>> On 10 Sep 2013, at 18:27, Diogo FC Patrao <djo...@gm...> > wrote: > >>>>> For the record, I have the same database in MySQL as well, with the > same structure, and rdf-dump went well with the same mappings. > >>>> > >>>> That's interesting. Off the top of my head I can't think of any > reason why this would be happening. > >>>> > >>>> I assume this is v0.8.1? > >>>> > >>>> Richard > >>>> > >>>> > >>>> > >>>>> > >>>>> Cheers, > >>>>> > >>>>> -- > >>>>> diogo patrão > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> On Tue, Sep 10, 2013 at 2:25 PM, Richard Cyganiak < > ri...@cy...> wrote: > >>>>> On 10 Sep 2013, at 17:39, Diogo FC Patrao <djo...@gm...> > wrote: > >>>>>> Anyone have any thoughts on that? > >>>>> > >>>>> Something funky going on in the mapping? Accidentally overlapping > URI patterns? It's very hard to say without additional details. I doubt > that it has anything to do with the use of PostgreSQL. > >>>>> > >>>>> Try removing stuff from the mapping until you have a minimal mapping > that shows the problem. > >>>>> > >>>>> Best, > >>>>> Richard > >>>>> > >>>>> > >>>>>> > >>>>>> -- > >>>>>> diogo patrão > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> On Fri, Sep 6, 2013 at 4:24 PM, Diogo FC Patrao < > djo...@gm...> wrote: > >>>>>> Hello > >>>>>> > >>>>>> I'm trying to dump a postgresql database with dump-rdf, however the > generated RDF maps all instances to all classes at the same time. > >>>>>> > >>>>>> Anyone having the same problem? > >>>>>> > >>>>>> -- > >>>>>> diogo patrão > >>>>>> > >>>>>> > >>>>>> > >>>>>> > ------------------------------------------------------------------------------ > >>>>>> How ServiceNow helps IT people transform IT departments: > >>>>>> 1. Consolidate legacy IT systems to a single system of record for IT > >>>>>> 2. Standardize and globalize service processes across IT > >>>>>> 3. Implement zero-touch automation to replace manual, redundant > tasks > >>>>>> > http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________ > >>>>>> d2rq-map-devel mailing list > >>>>>> d2r...@li... > >>>>>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > >>>>> > >>>>> > >>>>> > ------------------------------------------------------------------------------ > >>>>> How ServiceNow helps IT people transform IT departments: > >>>>> 1. Consolidate legacy IT systems to a single system of record for IT > >>>>> 2. Standardize and globalize service processes across IT > >>>>> 3. Implement zero-touch automation to replace manual, redundant tasks > >>>>> > http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________ > >>>>> d2rq-map-devel mailing list > >>>>> d2r...@li... > >>>>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > >>>> > >>>> > >>>> > >>>> > >>>> > ------------------------------------------------------------------------------ > >>>> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > >>>> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, > SharePoint > >>>> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack > includes > >>>> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. > >>>> > http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk_______________________________________________ > >>>> d2rq-map-devel mailing list > >>>> d2r...@li... > >>>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > >>> > >>> > >>> > ------------------------------------------------------------------------------ > >>> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > >>> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, > SharePoint > >>> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack > includes > >>> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. > >>> > http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk > >>> _______________________________________________ > >>> d2rq-map-devel mailing list > >>> d2r...@li... > >>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > >> > >> > >> > ------------------------------------------------------------------------------ > >> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > >> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, > SharePoint > >> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack > includes > >> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. > >> > http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk > >> _______________________________________________ > >> d2rq-map-devel mailing list > >> d2r...@li... > >> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > >> > > |
