1 / 27

HL7 version 3

HL7 version 3. Persistence of in-memory object trees. Scope: database models, v3 modeling aspects and their impact on persistence, persisting concepts, extracting data. Slide contents published under the Creative Commons / Attribute-Share Alike license

kina
Télécharger la présentation

HL7 version 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. HL7 version 3 Persistence of in-memory object trees Scope: database models, v3 modeling aspects and their impact on persistence, persisting concepts, extracting data. Slide contents published under the Creative Commons / Attribute-Share Alike license Source: www.ringholm.de/download/HL7v3_implementation.zip

  2. Agenda • Database Models • ER, EAV, XML, Hybrid, Distributed • Persisting RIM object graphs • Update/snapshot mode • Obsolescing v3 documents/messages • Context conduction • Persistence of OIDs and IDs • Persisting concepts • Extracting/querying data

  3. RIMBAA Technology Matrix Persistent Representation Object Representation Serialized Representation RIM (generic) Model RIM Constrained Information Model Application specific Model

  4. Persistence Database Models Slide contents published under the Creative Commons / Attribute-Share Alike license Source: www.ringholm.de/download/implementation_mechanics.ppt

  5. Database Models • EAV (“RDF Triples”) • Pure EAV considered to be too slow • XML • Example implementation • RDBMS (ER) • Focus of the presentation

  6. Persistence Persisting RIM object graphs Slide contents published under the Creative Commons / Attribute-Share Alike license Source: www.ringholm.de/download/implementation_mechanics.ppt

  7. Storage and RetrievalTraditional APIs Use traditional data access API: JDBC, ODBC, ADO Create your own mapping between business objects and a relational database model.

  8. Storage and RetrievalUsing Coding Techniques Object/Relational Mapping Wrap database objects (tables, columns, fields…) in OO classes Hibernate (Java), nHibernate (.NET), HyperJAXB, Jakarta OJB, JPOX Many others available Search on Sourceforge for “object relational mapping” yields several pages (Java and .NET)

  9. Update/Snapshot Mode

  10. Snapshot mode (of object trees) • Object trees are snapshots (of data). An initial laboratory results message (labeled TE1) may be updated by a final laboratory results message (labeled TE2) • Undo any merging that it did upon receipt of TE1 This requires that one persists the fact that certain objects are associated with TE1. It also requires that one has a temporal database to revert to a prior version of objects/attributes. • Merge the contents of TE2 with whatever objects the receiver already was aware about.

  11. Obsolescing v3 messages/documents

  12. OIDs and IDs

  13. Persistence Context Conduction Slide contents published under the Creative Commons / Attribute-Share Alike license Source: www.ringholm.de/download/implementation_mechanics.ppt

  14. Abstract “context conduction” Original slide provided by Ewout Kramer.

  15. Conducting and Blocking (new style) • Conducting relationships: • Participations: • all but _ParticipationAncillary • ActRelationships: • all but COMP, OUTC, SEQL Original slide provided by Ewout Kramer.

  16. Context Conduction (new style) • There are two attributes on ActRelationship: actRelationshipNonConducting : SET<CS>, participationNonConducting : SET<CS> • Only certain Participations/ActRels conduct. We will add a concept property to indicate this. • For types that conduct, they always conduct and are always additive • Conduction still works by following the serialization of models Original slide ptovided by Ewout Kramer.

  17. Context Conduction • Two options for dealing with CC: • Denormalize the conduction on import • Generally viewed as the safer option • CC is a “wire-format optimization technique” • Deal with CC at run-time, i.e. when a query is processed • Lots of joins to go “up the tree” and fetch context • Problem when merging object trees into nets; CC is specific to a serialization

  18. Persistence Persisting Concepts Slide contents published under the Creative Commons / Attribute-Share Alike license Source: www.ringholm.de/download/implementation_mechanics.ppt

  19. Persisting Concepts • Persist all information received • Translations • We may not be able to recreate those • Translation may be “more granular” than primary concept code • Value set OIDs • may need to be aware which ones are implied -by context- when one receives a v3 instance

  20. Persist versions of Value Sets • Over time, updates to the coding system (or value set) must be identified and distributed. New Coding System New OID New Coding System New OID New Coding System New OID

  21. Persistence Implementation Experience Slide contents published under the Creative Commons / Attribute-Share Alike license Source: www.ringholm.de/download/implementation_mechanics.ppt

  22. Use-case 1: Approach • Serialized messages mapped to in-memory message objects (JAXB, code generation) • Application (business-) objects mapped to relational database (Hibernate ORM) • Custom code: mapping of message objects to application objects

  23. Use-case 1: Hibernate • Lazy object loading • Hibernate QL for object based queries

  24. IBM RIMon: DB2

  25. IBM RIMon: RIMified XML Note: Format was created prior to the creation of the RIM ITS

  26. IBM RIMon: Persisting XML

  27. Any Questions ? • Or: post your question/suggestions via • HL7 Wiki: http://bit.ly/d7tSsL • E-mail v3impl@ringholm.com

More Related