fhir search for server devs (martijn)

© 2014 HL7 ® International. Licensed under Creative Commons. HL7 & Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.

SEARCH for

server developersMartijn Harthoorn

FHIR DevDays 2015November 19, 2015


2

Name: Martijn Harthoorn Company: Furore Background:

Programmer in C# (mainly)

Project manager Furore FHIR team Programmer of

Spark Search Engine SIMPLIFIER.NET search engine

Who am I?


3

Dealing with what’s behind the question mark.

Search


4

"FHIR client should be easy.

FHIR server needs to solve the complex issues."

Search has some…

FHIR paradigm


5

Use casesfor a FHIR server


6

UC1: The registrar

patient forgot hospital card (with id)

"what is your name and birthdate?"


7

UC2: The doctor

“give me all data on patient x”


8

UC3: The researcher

“give me all data on a specific allergy that conforms to a set of conditions”


9

UC4: The manager

“how many patients did we treat last month?”


10

UC5: The lab

“Give me the list of tests to process”


11

UC6: The nurse

“Alert me on any patient with a measurement in the danger zone.”


12

UC Summary

- the registrar - the doctor - the researcher - the manager - the lab worker - the nurse


13

Do what?

Do what?

Search Query

"Give me your top results." "Give me exactly what I ask"


14

Build upon REST

Do what?

Search Query

URL/[resource]?<parameters>


15

Where do we stand?


16

Types


17

FHIR Data types


18

Search parameters types

number

date

string

token

reference

quantity

uri

composite


19

Mapping of number

number integer

Parameter data type Content data type

~/Procedure?date=>2010-01-01&date=<2011-12-31


20

Mapping of date

dateDate


Period

~/Procedure?date=>2010-01-01&date=<2011-12-31

DateTime

Instant


21

Mapping of string

stringString


HumanName

~/Patient?name=eve


22

Mapping of token

tokenCoding


Codeable concept

~/Patient?name=eve

Identifier

(Code)


23

Mapping of quantity

quantity Quantity


~/Patient?name=eve


24

Logical operators


25

Logical operators

a=x & c=y & e=z

a=x & a=y

a=b,d

a-b=c$d

AND

OR / IN

(nested) AND


26

Building an expression tree

URL?a=A&a=A2&c=C1,C2&d-e-=D&E

AND

EQ a=A2

OR

c=C1

c=C2

AND

d=D e=E

a A

ELEM


27

Comparison operators


28

Logical operators

eqnegtltgele.....

value=le100


29

Levels of parameters


30

Global parameters:

_id_lastupdated_tag_profile_list, ...



31

Predefined parameters:

Patient.addressPatient.familyPatient.emailOrganization.nameOrganization.partof...



32

Profiled parameters:

Patient.mycustomfield...



33

A small historyHOW WE IMPLEMENTED SPARK reference implementation


34

History

Version 1. Patient only Per parameter

No meta data No index

Limited

every change is rework

Slow!!!


35

History

Version 2. All resources Self generated meta data

Indexing in Lucene Client side joins

Fast

Lot of work


36

History

Version 3.

All resources Model meta data Indexing in Mongo

Even faster!

changes in the standard are now applied automatically


37

Indexing


38

Indexing


39

Indexing


40

Indexing

REST Service

Storage

Index&

Search

DB


41

How to index?


42

How to index?

<family value=“Chalmers”>

chalmers

Patient?name=chal

chal*match

PUT SEARCH


43

How to index?

<valueQuantity=“10g”>

0.1

value-quantity=>0.1||kg

0.05>

http://unitsofmeasure.org http://unitsofmeasure.org

kg = kg

=

PUT SEARCH


44

Logic and filtering


45

_include_revinclude


46

Chained parameters


47

Paging


48

Canonical search


49

Canonical search

UCUM

http://unitsofmeasure.org/


50

Fuzzy search


51

Fuzzy search

1. STARTS WITH


52

Fuzzy search

2. LIKE


53

Fuzzy search

3. SOUNDEX


54

Fuzzy search

4. Damerau-Lehvenstein


55

Fuzzy search

5. More advanced searching


56

Full text search


57

Debugging

To test a client – you must have a tested serverTo test a server – you must have a tested client

“One fool can ask more questions than seven wise men can answer”


58

Debugging

“One fool can ask more questions than seven wise men can answer”

Sprinkler(testtool) Spark MongoDB

Visual Studio Visual Studio MongoVue

Fiddler

fhir search for server devs (martijn)

Healthcare