Preventing a Database Dumpster FHIR: Constraining Searches
summary
Redox builds an internal FHIR server called Data Chateau that translates FHIR search into SQL with a dynamic query engine, but supporting full search features (includes, _revinclude, joins) produces queries that can overwhelm a shared RDBMS — one example pulls all male patients born after 1900 plus their allergyintolerance and medicationrequest includes. Tests show timeouts, joins and counts still kill infrastructure, so constraints use manual parameter validation rather than simple result limits or paging.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 0:32Overview
- 0:53Who am I
- 1:44Agenda
- 2:43Traditional Interoperability
- 3:35Reducing Interoperability Friction
- 4:25What is Data Chateau
- 5:17Why FHIR
- 6:47FHIR Architecture
- 7:31FHIR Schema
- 8:15FHIR Documentation
- 9:28Dangerous Searches
- 10:34Constraining Searches
- 12:34Other Problems
- 14:30Questions
