mj:
Result Link:
www.oceandriveng.com/query.jpg

Oh, i see what I was doing wrong. I omitted some lines at the top.

Now, that you have Synonyms working, what do you want to accomplish with this new line of queries?

Kobojunkie:

Oh, i see what I was doing wrong. I omitted some lines at the top.

Now, that you have Synonyms working, what do you want to accomplish with this new line of queries?

how can i link the synonyms with the patients that have that disease.

mj:
how can i link the synonyms with the patients that have that disease.

How is Synonym currently defined?

Select *
from Table
Where column like (%constraint1%, %constraint2%,.....)

Heres is the Link:
http://www.oceandriveng.com/ontology.jpg

mj: Heres is the Link:
http://www.oceandriveng.com/ontology.jpg

what I did is to create an Object Property called Synonym, and add it to the object Property of each Disease and added the individual synonym to it.Maybe I need to modify my ontology to make this work, i dont know really, thanks Kobojunkie for the help you'v rendered on this, I really do appreciate, Thanks once again.

jay bee: Select *
from Table
Where column like (%constraint1%, %constraint2%,.....)

im not clear with your query...read the entire post first so you know where we are.

Again, I am also brand spanking new to RDF Protege, and using the Object property there. I have been able to install and open the URI in Protege, and able to view the information you are referring to. From my understanding so far, when I click the "DATA PROPERTIES" tab at the top, I am directly accessing TopDataProperty information on the data that specifies some sort of relationship exists between all the listed properties, right?

I am also working under the assumption that somehow Object properties feed off of this toplevel data? YES OR NO?

If yes, please explain how? Cause in order to help I need to understand what exactly these Object Properties are in relation to other data(I am not asking you how you specified it but how Protege links them). If you find some sort of definition of this information, please forward it so I quickly catch up on that, if I can.

on the "DATA PROPERTIES" the listed properties does not specify the have relationships, CLICK on the Individuals Tab, you will see Disease and Patients Class, you can specify relationship on the individuals using the Object property Assertions on the right side.
look at this:
http://protege-ontology-editor-knowledge-acquisition-system.136.n4.nabble.com/adding-Synonyms-in-Protege-tc4152437.html

ive tried but to know success, but I'll keep trying.

Will try to see if I can figure it out when I am sure I even understand the half of this data property and stuff. This thing reminds me so much of Visual works IDE(before I figured it out). . . lol

This is the mail i got but the code is not working, he said he has not tested it though.

@prefix diag: <http://www.oceandriveng.com/Diagnosis#>

select distinct ?patient ?disease {
?patient diag:Disease ?disease.
?disease diag:DiseaseName ?name1.
OPTIONAL {
?disease diag:Synonyms ?diseaseSynonym.
?diseaseSynonym diag:DiseaseName ?name2.
}
FILTER (regex( "brain tumour", ?name1 ) ||
(bound( ?name2 ) && regex( "brain tumour", ?name2 ))
)
}

So, roughly 'the ?patient has a ?disease, and either that disease has
a ?name1 which matches "brain tumour", OR that disease has a synonym
and that synonym has a ?name2 which matches "brain tumour" '

^^^ Have you tested it?

Kobojunkie: ^^^ Have you tested it?

Yes I have but its not working, ive been debugging it but to know success.

this is the cleaned up version of the code that runs(no records returned).

PREFIX diag: <http://www.oceandriveng.com/Diagnosis#>

SELECT DISTINCT ?patient ?disease
{
?patient diag:Disease ?disease.
?disease diag:DiseaseName ?name1.
OPTIONAL {
?disease diag:Synonyms ?diseaseSynonym.
?diseaseSynonym diag:DiseaseName ?name2.
}.
FILTER (
regex(?name1, "brain_tumor", "i" )
||
(bound(?name2)
&&
regex(?name2, "brain_tumor", "i" ))
)
}

I think I can read it, but can you read it and tell me if the relationships he created in there makes sense to you.

Kobojunkie: this is the cleaned up version of the code that runs(no records returned).



I think I can read it, but can you read it and tell me if the relationships he created in there makes sense to you.

So, roughly 'the ?patient has a ?disease, and either that disease has
a ?name1 (brain_tumor) which matches "brain tumour", OR that disease has a synonym( brain neoplasm)
and that synonym has a ?name2 which matches "brain tumour". this is how he explained it, yeah is making sense, but no results.

This is the working code, thanks so much, I will reach u back later, ur name must be in my project and publication of ontology.

PREFIX diag: http://www.oceandriveng.com/Diagnosis#
select distinct ?patient ?disease
{
?patient diag:Disease ?disease.
?disease diag:DiseaseName ?name1.
OPTIONAL {
?disease diag:Synonyms ?diseaseSynonym.
?diseaseSynonym diag:DiseaseName ?name2.
}
FILTER (regex( ?name1, "brain tumor", "i"||
(bound( ?name2 ) && regex( ?name2, "brain tumor", "i"))
}

I had never heard of SPARQL before this but after this exercise, I too go claim say I be good Spa-co-lo(SPARQL) programmer. ROFLMAO!!

Follow me on twitter, I will follow back @OshadamiMJ.

unfortunately I don't do twitter, or facebook, or all the other social things out there.

Need help on this again, my supervisor doesn't want the datatypes resource of the patient name to show, she wants only there name to show.thanks.