Data Management with Ontologies
Bijan Parsia bparsia@cs.man.ac.uk
1
1 Friday, 7 December 2012
Data Management with Ontologies Bijan Parsia bparsia@cs.man.ac.uk - - PowerPoint PPT Presentation
Data Management with Ontologies Bijan Parsia bparsia@cs.man.ac.uk 1 Friday, 7 December 2012 1 The Future is Coming...Soon Reducing Paperwork and Administrative Costs. Health care remains one of the few industries that relies on paper
1
1 Friday, 7 December 2012
http://en.wikipedia.org/wiki/File:ColumbiaStahrArtwork.jpg http://uncyclopedia.wikia.com/wiki/File:Uncle_Sam_I_Want_You_1.jpg
2 Friday, 7 December 2012
http://www.washingtonpost.com/blogs/ezra-klein/wp/2012/07/19/about-half-of-doctors-use-electronic-records/
3 Friday, 7 December 2012
http://thehealthcareblog.com/blog/2011/12/02/2011-ehr-adoption-rates/
4 Friday, 7 December 2012
“I wish the doctor had spent as much time with me as she did with her PC” Many years ago, an excited friend who worked for one of the electronic health record (EHR) vendors at that time — it was really more of a billing and patient tracking and management system than an EHR — was desperate to show me some of their latest applications. In particular, a new module they had developed to capture clinical data. My friend pulled out his laptop (see here for visual), fired up the application, selected a patient and proceeded to enter blood pressure (BP). Some 20-plus clicks later, he had entered a BP of 120/80. While he was excited, I was
have time for 20 clicks to record BP years ago and they definitely don’t have that luxury in today’s demanding medical environment.
http://ehrintelligence.com/2012/07/12/clinical-documentation-in-the-ehr/
5 Friday, 7 December 2012
enter search:
Acute cystitis Subacute cystitis, NOS Follicular cystitis Cystitis, NOS Idiopathic cystitis Chemical cystitis Postoperative cystitis Drug induced cystitis Iatrogenic cystitis Radiation cystitis Chronic cholecystitis Acute cholecystitis Bacterial Cholecystitis Cholecystitis, NOS Bacterial cystitis
next page
http://www.cs.man.ac.uk/~rector/presentations/snomed-rector-history-and-future-of-terminology.ppt
6 Friday, 7 December 2012
7 Friday, 7 December 2012
http://thehealthcareblog.com/blog/2012/01/27/medical-records-supporting-san-francisco%E2%80%99s- universal-care-add-millions-to-official/
A separate and much more complex piece of technology — electronic health records — is proving difficult and expensive. Knitting together incompatible computer systems across the 35 medical sites so they can easily share detailed patient medical records could costs the city millions beyond what is included in the official price tag. An incomplete survey of technology costs borne by the clinics themselves this year reveals spending of at least $15 million in addition to what was budgeted for the whole program...But that sum is likely millions higher, since eight clinics could not or would not say how much they spent
The current patchwork of at least 11 different computer systems across the network do not easily talk with one another. ... This incompatibility of record keeping sometimes causes delays, repeated tests, unnecessary procedures and gaps in care as patients move from doctor to doctor. Ideally, say technology planners, there ought to be just one system citywide. But that is unlikely to happen soon.
8 Friday, 7 December 2012
9
9 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-1.html
10 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-1.html
11 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-1.html
12 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-1.html
13 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-1.html
14 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-1.html
15 Friday, 7 December 2012
16 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-2.html
17 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-2.html
18 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-2.html
19 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-2.html
20 Friday, 7 December 2012
http://www.inf.unibz.it/~franconi/icom/tutorial-2.html
21 Friday, 7 December 2012
22 Friday, 7 December 2012
23 Friday, 7 December 2012
Person Student Employee
hasAge hasSalary
create table employee (id number(4) hasAge number(3), hasSalary number(6); create table student (id number(4) hasAge number(3), hasSalary number(5);
24 Friday, 7 December 2012
Clinical Model OBDA Model (Mappings) OBDA Aware Query Engine Legacy Database Query Report Data Entry Form Query Report Data Entry Form
https://babbage.inf.unibz.it/trac/obdapublic/raw-attachment/wiki/ObdalibQuestIntro/virtual.png
25 Friday, 7 December 2012
Clinical Model OBDA Model (Mappings) OBDA Aware Query Engine Query Report Data Entry Form
Legacy Database Query Report Data Entry Form
OBDA Model (Mappings)
Legacy Database Query Report Data Entry Form
26 Friday, 7 December 2012
27 Friday, 7 December 2012
28 Friday, 7 December 2012
29 Friday, 7 December 2012
– Tautologies hold: Bijan Types: owl:Thing.
– Open world assumption (and no unique name assumption) – Think of the various models
30 Friday, 7 December 2012
– 1, 2, 0, 1.0, “I’m a string!”, "51"^^xsd:integer
– integer, xsd:string, xsd:nonNegativeInteger, xsd:decimal, etc.
– On the abstract side, this is only true for owl:Thing, owl:Nothing,
connectives – (The actual meanings for the tops will vary with the domain)
31 Friday, 7 December 2012
– Bijan Facts: height 6, height 2 » Inconsistent!
32 Friday, 7 December 2012
– The subset of integers between 0 and 150, inclusive
– That the values respect, e.g., 1<=2 but not 2 <=1 – Formalize THAT on the logic side!
33 Friday, 7 December 2012
34 Friday, 7 December 2012
35 Friday, 7 December 2012
36 Friday, 7 December 2012
37 Friday, 7 December 2012
38 Friday, 7 December 2012
39 Friday, 7 December 2012
40 Friday, 7 December 2012
41 Friday, 7 December 2012
Each main category is disjoint from the rest
42 Friday, 7 December 2012
– personAge EquivalentTo: integer[<= 0 , >= 150]
– personAge EquivalentTo: xsd:nonNegativeInteger[>= 150] – Even though the definitions are equivalent! – (Consider what happens when they are not) – Hidden cyclish thing!
43 Friday, 7 December 2012
44 Friday, 7 December 2012
– A top predicate – Closed under negation – Satisfiability of conjunctions is decidable » integer[>=0] and integer[<=-10] is unsatisfiable
Bijan
height
Bijan
height
Zoe
hasSpouse
45 Friday, 7 December 2012
46 Friday, 7 December 2012
47 Friday, 7 December 2012
48 Friday, 7 December 2012
49 Friday, 7 December 2012
(defrelation UNIT-Of-MEASURE ;; units are scalar quantities (=> (unit-of-measure ?u) (scalar-quantity ?u)) ;; units are positive (=> (unit-of-measure ?u) (forall ?u2 (=> (and (unit-of-measure ?u2) (= (quantity.dimension ?u) (quantity.dimension ?u2))) (positive (magnitude ?u ?u2))))) ;; units can be combined using * (abelian-group unit-of-measure * identity-unit) ;; units can be combined using expt (=> (and (unit-of-measure ?u) (real-number ?r)) (unit-of-measure (expt ?u ?r))) ;; * is commutative for units and other Qs (=> (and (unit-of-measure ?u) (constant-quantity ?q))) (= (* ?u ?q) (* ?q ?u))))
50 Friday, 7 December 2012
51 Friday, 7 December 2012
– SubClassOf(River – DataAllValuesFrom(length-in-miles length-in-kilometers – DataComparison(Arguments(mi km) eq( mi (* 1.609 km) ))))
52 Friday, 7 December 2012
53 Friday, 7 December 2012
54 Friday, 7 December 2012
length Yangtze "3937.5 miles"ˆˆowl:quantity
55 Friday, 7 December 2012
height "200 cm"ˆˆowl:quantity
height "2 cm"ˆˆowl:quantity
– EquivalentClasses(Tall SomeValuesFrom(height DatatypeRestriction(xsd:integer minExclusive "6 feet"ˆˆowl:quantity)))
56 Friday, 7 December 2012
– I.e., ft, cm etc. go to m – This eliminates the need for equations in the ontology
– JohnDoe Facts: height "6.0 ft"ˆˆowl:quantity to – JohnDoe Facts: mint:height new:d1. – new:d1 Types: mint:DimLength – Facts: quantity:magnitude "1.8288"ˆˆowl:real
disjoint from all the others).
57 Friday, 7 December 2012
58 Friday, 7 December 2012
59 Friday, 7 December 2012
60 Friday, 7 December 2012
http://www.mindswap.org/2005/services-policies/
61 Friday, 7 December 2012
<wsp:Policy xmlns:sp="http://docs.oasis-open.org/ws-sx/ws-securitypolicy/200702" xmlns:wsp="http://www.w3.org/ns/ws-policy"> <wsp:ExactlyOne> <wsp:All> <sp:SignedParts> <sp:Body/> </sp:SignedParts> </wsp:All> <wsp:All> <sp:EncryptedParts> <sp:Body/> </sp:EncryptedParts> </wsp:All> </wsp:ExactlyOne> </wsp:Policy>
http://www.w3.org/TR/ws-policy/#Normal_Form_Policy_Expression
62 Friday, 7 December 2012
63 Friday, 7 December 2012
64 Friday, 7 December 2012
<ClassAssertion> <Class IRI="ExactlyOne"/> <NamedIndividual IRI="MyPolicy"/></> <ClassAssertion> <Class IRI="All"/> <NamedIndividual IRI="All1"/></> <ObjectPropertyAssertion> <ObjectProperty IRI="hasAlt"/> <NamedIndividual IRI="MyPolicy"/> <NamedIndividual IRI="All1"/></> <ObjectPropertyAssertion> <ObjectProperty IRI="hasProposition"/> <NamedIndividual IRI="All1"/> <NamedIndividual IRI="SignedPart"/></>
65 Friday, 7 December 2012
– Axiom: Parents must have at least one child – Axiom: Sally is a Parent – In XML, the latter isn’t valid – In OWL, it is consistent » We just don’t know who the child is »Open World Assumption (OWA)
66 Friday, 7 December 2012
* Cheating a bit: it’s exclusive or
67 Friday, 7 December 2012
68 Friday, 7 December 2012
– Subclasses! Not disjoint per se, but not equivalent
– But we can also see that they are not using the same policy
69 Friday, 7 December 2012
policy?”
70 Friday, 7 December 2012
– Up to a point
71 Friday, 7 December 2012
72 Friday, 7 December 2012
– http://www.w3.org/DesignIssues/LinkedData.html
73 Friday, 7 December 2012
– XML waves its arm wildly
– Look up the meaning
– I.e., ontologies
74 Friday, 7 December 2012
– EL “looks like (biomedical) ontologies” – QL “looks like UML/ER diagrams” » And has nifty DB implementations – RL “looks like databases” » plus rules
75 Friday, 7 December 2012
http://events.linkeddata.org/ldow2012/papers/ldow2012-paper-16.pdf
76 Friday, 7 December 2012
77 Friday, 7 December 2012
Samantha Bail FishMark: A Linked Data Application Benchmark
78
Factor = comparison against MySQL performance
Query name Virtuoso Virtuoso factor Quest Quest factor MySQL CSpeciesInformation CAquariumTrade CUsedForAquaculture CommonName PicturePage Species FamilyNominalSpecies Genus FamilyAllfish CEndemic CPotentialAquaculture CollaboratorPage FamilyListOfPictures CGameFish FamilyInformation SpeciesPage CCommercial CIntroduced CAllFish CPelagic CReefAssociated CFreshwater 15 1.10% 866 65.40% 1324 84 6.40% 910 69.80% 1303 14 1.10% 850 66.70% 1274 128 10.20% 850 67.50% 1258 149 12.10% 893 72.10% 1238 197 16.30% 951 78.40% 1212 173 15.40% 849 75.40% 1126 157 14.50% 818 75.20% 1087 155 14.70% 796 75.90% 1049 19 1.90% 733 70.70% 1037 45 4.50% 714 70.40% 1014 26 2.60% 657 65.40% 1006 105 10.60% 728 73.30% 993 11 1.10% 639 65.20% 979 17 1.90% 593 65.60% 903 1 0.10% 578 71.20% 811 14 1.80% 541 70.20% 771 14 2.10% 442 67.90% 651 28 5.10% 413 74.70% 553 9 1.90% 349 74.10% 471 5 1.40% 273 70.40% 388 7 2.30% 217 69.90% 310
Thanks to
ODBA/OWL QL looks good even though it’s not doing anything!
78 Friday, 7 December 2012
79 Friday, 7 December 2012
80 Friday, 7 December 2012
– Bit shorter (44q last year) – (More essays; fewer MCQs)
– But coursework a bit up
!" #" $" %" &" '" (" )" *" +" #!" % ! ,
+ , " & ! ,
& , " & ' ,
+ , " ' ! ,
& , " ' ' ,
+ , " ( ! ,
& , " ( ' ,
+ , " ) ! ,
& , " ./01/2#"
81 Friday, 7 December 2012