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
