rimbaa
DESCRIPTION
RIMBAA. Andy Harris Harbuk Ltd 27 October 2009. Background. Self employed from 1993 -2004, prototyping systems for NHS (primarily management data, not clinical) first RIMBAA db (in Access) 2003 2004 – 2009 UK Biobank Using Oracle HTB. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/1.jpg)
RIMBAA
Andy HarrisHarbuk Ltd
27 October 2009
1
![Page 2: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/2.jpg)
Background
• Self employed from 1993 -2004, prototyping systems for NHS (primarily management data, not clinical)
• first RIMBAA db (in Access) 2003• 2004 – 2009 UK Biobank
– Using Oracle HTB.– Process summary – transform flat data structures into CDA format,
import into HTB. – Very powerful product. Based on Java API and Oracle DB– Enterprise terminology Services very mature– close mapping to HL7 class structure, but no roleLink table ??
• 2009 - Employed myself, Harbuk Ltd• Data Architect for NIHR – existing systems based on classic Logical
Data Model. Problem is that the business model keeps changing…
2
![Page 3: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/3.jpg)
My standpoint
• Coming from a data layer perspective
• RIM based data layer will then make message generation 'simpler' in the future, not that I want to go there…
• Need to deliver something fast that is also a good fit for the longer term
3
![Page 4: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/4.jpg)
Research Lifecycle
4
Integrated NIHR Systems exchange data, provide expert
decision support, toolkits, templates, reminders and
repositories
AnalysisReview
PublicationArchiving
Research Idea Initiation Institutional Sign-Off
Conclusion/Termination
ReportingMonitoring
Data Recording RecruitmentRegistration
Commencement
Scientific ReviewFunding Decision
Regulatory Authorisation
Ethical Review
![Page 5: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/5.jpg)
Legacy Model – Simplified and stereotyped
5
![Page 6: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/6.jpg)
BRIDG DAM Model
6
![Page 7: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/7.jpg)
RCRIM Outputs – Study Design
7
![Page 8: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/8.jpg)
RCRIM Outputs – Study Participation
8
![Page 9: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/9.jpg)
My Issues
• Not a fully HL7 domain (yet)• Current HL7 models do not cover our realm• .NET• Status model
– Overloading HL7 Status or 'characteristic/observation'• temporal updates
– Versioning– timestamps and timespans
• class structures - break out or roll up?• localised terminologies• Some datatypes (IVL/GTS, PQ)• Where is Participation.id? (not managedParticipation.id)
9
![Page 10: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/10.jpg)
10
![Page 11: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/11.jpg)
11
![Page 12: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/12.jpg)
Current wiki Issues
12
![Page 13: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/13.jpg)
Object Versioning within RIMBAA
• Maintain history!– How?
• In-table versioning, makes relational model more difficult, as FKs would be linked to ??ID + versionNumber + 'isCurrentVersion'
• ODS/Archive versioning - i.e. most current record in ODS, older versions in archive (mirror + archive fields)
• Current record - SINCE column• Archive Record - FROM, TO columns• Pros and Cons either way.
• Maintain Control Acts!
13
![Page 14: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/14.jpg)
Processing Logic in RIMBAA Applications
• data layer should be context driven (though context may be given by content)
14
![Page 15: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/15.jpg)
RIM based on interoperability mindset
• CD– What are the 'Management issues' associated
with OIDs?– Storing Code System AND valueset OIDs– If the Terminology service is well grounded,
this is less of an issue IMHO
15
![Page 16: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/16.jpg)
RIMBAA Performance
• Yes, querying is complex and relatively slow because of recursion, but that's why there should be a BI stack for heavy report lifting.
• at UK Bionbank, we were 'crosstabbing' 200,000 patients and approx 600 data points from an act table within approx 8 minutes - 120,000,000 data points
16
![Page 17: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/17.jpg)
RIMBAA ReferenceApplication
• I would say a running application, not an IDE
17
![Page 18: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/18.jpg)
Safe querying of a RIM-based data model
• it depends on the context!, so basically all acts should be made available
18
![Page 19: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/19.jpg)
Template Implementation
• I am planning on heavy use of templates, question is more around the detail (e.g. how far from the core classes should you build the templates
19
![Page 20: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/20.jpg)
Use of terminology servers in RIMBAA applications
• Absolutely
• we are developing CTSv1
20
![Page 21: RIMBAA](https://reader035.vdocuments.us/reader035/viewer/2022062518/5681476b550346895db4a6af/html5/thumbnails/21.jpg)
User Interface for RIMBAA Applications
• integration with templates/LIMs, commonality is one of the key reasons for using RIM
• start with the generic controls, make them work, bolt them together, less generic as you go up the data stack.
21