Hello Richard
Thanks a lot, I'll try it and let you know wether it worked or not.
And yes, it was meant to be rhc.dtnasc. I think it worked that way, without
specifiying the table name.
Cheers,
--
diogo patrão
On Sat, Sep 21, 2013 at 3:10 PM, Richard Cyganiak <rich...@cyganiak.de>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 <djogopat...@gmail.com> 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 <djogopat...@gmail.com>
> 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 <djogopat...@gmail.com>
> wrote:
> > Yes, 0.8.1.
> >
> > --
> > diogo patrão
> >
> >
> >
> >
> > On Tue, Sep 10, 2013 at 2:33 PM, Richard Cyganiak <rich...@cyganiak.de>
> wrote:
> > On 10 Sep 2013, at 18:27, Diogo FC Patrao <djogopat...@gmail.com> 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 <rich...@cyganiak.de>
> wrote:
> > > On 10 Sep 2013, at 17:39, Diogo FC Patrao <djogopat...@gmail.com>
> 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 <
> djogopat...@gmail.com> 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
> > > > d2rq-map-devel@lists.sourceforge.net
> > > > 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
> > > d2rq-map-devel@lists.sourceforge.net
> > > 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
> > d2rq-map-devel@lists.sourceforge.net
> > 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
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
