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
