Fwd: Shortlist of issues from the meeting

FYI


---------- Forwarded message ----------
From: Eric Prud'hommeaux <eric@w3.org>
Date: Mon, Aug 2, 2010 at 12:51 PM
Subject: Re: Shortlist of issues from the meeting
To: Srikalyan Swayampakula <srikalyan@semanticbits.com>
Cc: "M. Scott Marshall" <mscottmarshall@gmail.com>, joshua phillips
<joshua.phillips@semanticbits.com>


* Srikalyan Swayampakula <srikalyan@semanticbits.com> [2010-06-04 17:08-0400]
> Hi Everyone,
>                     Here is a short list of issues we have identified during
> our conversation.
>
> 1) Fixing the filters in sparql.

should be working in the SPARQL11 bins on sourceforge (note, no mac
yet).

> 2) Adding features to specify the primarykey column name.

in map files (as in $(SPARQL -m <mapfile>) ), you can now add
PRIMARYKEY [ "commonID" ] { "Trucks"."truckID" "Patients"."patID"
"Cars"."CarID" }
where "commonID" is the default primary key, but the table Trucks has
truckID as a primary key.

> 3) Fixing the Name mapping between the sparql query and mapping rules to
> generate the sql command (instead of using a simple name match).
> 4) We also discussed about finding a good algorithm for backward chaining to
> fix the name mapping issue.

This is what you should get now (if you grab the tests directory):
[[
eric@ubu:~/checkouts/swobjects/tests$ ../bin/SPARQL -m
healthCare/cabig/twoWayHL7-BGMap.rq healthCare/cabig/twoWayBGQuery.rq
-np
SELECT ?pat ?midName ?bd ?sex
WHERE
{
 ?pat <http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#entityName>
?midName .
 ?pat <http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#livingSubjectBirthTime>
?bd .
 ?pat <http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#administrativeGenderCodePrintName>
?sex .
 ?_med_0_b0x94b6c10 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#SubstanceAdministration>
.
 ?_med_0_b0x94b7158
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#displayName>
?takes .
 ?_med_0_b0x94b7488
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#classCode>
?_med_0_ingred .
 ?_med_0_b0x94b7158
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#activeIngredient>
?_med_0_b0x94b7488 .
 ?_med_0_b0x94b6c10
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#consumable>
?_med_0_b0x94b7158 .
 ?_med_0_b0x94b70e8
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#start>
?indicDate .
 ?_med_0_b0x94b6c10
<http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#effectiveTime>
?_med_0_b0x94b70e8 .
 ?pat <http://www.hl7.org/v3ballot/xml/infrastructure/vocabulary/vocabulary#substanceAdministration>
?_med_0_b0x94b6c10 .
 FILTER (( ?bd >
"1999-01-01T00:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> ))
 FILTER (( ?indicDate <
"2010-01-01T00:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> ))
}


eric@ubu:~/checkouts/swobjects/tests$ ../bin/SPARQL -m
healthCare/cabig/twoWayHL7-BGMap.rq healthCare/cabig/twoWayBGQuery.rq
-np | ../bin/SPARQL -m healthCare/lists-notBound/db-hl7.rq - -np
SELECT pat.ID AS pat, pat.MiddleName AS midName, pat.DateOfBirth AS
bd, _sex_0_sexEntry.EntryName AS sex
      FROM Person AS pat
           INNER JOIN Sex_DE AS _sex_0_sexEntry ON _sex_0_sexEntry.ID=pat.SexDE
           INNER JOIN Item_Medication AS _person2drug_0_itemMed ON
_person2drug_0_itemMed.PatientID=pat.ID
           INNER JOIN Medication AS _person2drug_0_medication ON
_person2drug_0_medication.ItemID=_person2drug_0_itemMed.ID
           INNER JOIN Medication_DE AS _person2drug_0_medDE ON
_person2drug_0_medDE.ID=_person2drug_0_medication.MedDictDE
           INNER JOIN NDCcodes AS _person2drug_0_medCodes ON
_person2drug_0_medCodes.NDC=_person2drug_0_medDE.NDC
 WHERE (pat.DateOfBirth > "1999-01-01 00:00") AND
(_person2drug_0_itemMed.PerformedDTTM < "2010-01-01 00:00")
]]

> Thanks,
>
> Have a great day.
> ~Sri.

--
-ericP

Received on Tuesday, 3 August 2010 15:49:52 UTC