ACHDM

American College of Health Data Management

American College of Health Data Management

Finding a proper role for FHIR in an emerging analytical structure

FHIR is a brilliant standard for transactional data exchange, but it is an inherently flawed format for the guts of a data mesh model.



This article is part 2 of a 3-part series. Read part 1: Four pillars that are crucial to a successful data mesh initiative.

As healthcare organizations embrace the decentralized philosophy of a data mesh, tech-savvy leaders face an immediate architectural decision. What should be the native data model for our domain data products?

Because the industry has spent the last decade rallying around the Fast Healthcare Interoperability Resources (FHIR) standard, the immediate temptation is to declare FHIR as the universal data fabric of the mesh. Enforced by federal mandates like the 21st Century Cures Act, FHIR has elegantly solved the semantic nightmare of medical data by standardizing discrete clinical concepts into predictable "Resources" (such as patient, observation, condition and medication request.

However, using FHIR as the native storage and computational engine inside an analytical data mesh is a critical design failure. To build a highly performing, scalable data ecosystem, health data executives must accept a hard architectural truth – FHIR is a brilliant standard for transactional data exchange, but it is an inherently flawed format for large-scale analytical processing.

To succeed, organizations must adopt a strict boundary thesis, anchoring FHIR as a strategic interface at the edge of the mesh while utilizing optimized analytical formats within the domains.

The structural impedance mismatch

The core friction between FHIR and data mesh lies in the fundamental difference between online transactional processing (OLTP) and online analytical processing (OLAP).

FHIR was custom-built for online transactional processing. It is optimized for point-lookup operations, such as a mobile app pulling a single patient’s allergy list, a clinician updating an active medication order or an automated webhook pushing a new appointment slot over HTTP. It’s deeply nested, hierarchical JSON or XML schemas are perfectly isolated to handle small, discrete payloads.

Analytical environments, the foundational output of a data mesh, require an online analytical processing environment. Analytical users — such as data scientists training machine learning algorithms for early sepsis detection or clinical analysts building longitudinal cohort models — do not query single records. They need to aggregate patterns across millions of patients simultaneously.

Confronting three bottlenecks

When a modern cloud query engine attempts to execute massive online analytical processing computations directly on raw FHIR payloads, it encounters three major structural bottlenecks.

The performance penalty of deep nesting. FHIR resources rely heavily on multi-layered arrays to accommodate complex medical qualifiers, custom extensions and localized code systems. For example, a single laboratory observation payload embeds codings within coding arrays, nested inside category structures. To read this data, an analytical engine must expend immense computing power, constantly parsing strings and traversing deep JSON pathways for every single row, resulting in sluggish queries and inflated cloud bills.

The "join explosion" phenomenon. To maintain transactional integrity, FHIR data is highly normalized and fractured. A patient's clinical narrative during a single hospital admission is split across an Encounter resource, several independent Condition resources, scores of individual Observation resources, and a Diagnostic Report. To run a routine population health query (such as mapping diabetic laboratory results against specific outpatient encounters), the compute engine must execute massive, multi-way joins across these highly fragmented collections of documents. This triggers immense data shuffling across database compute nodes, driving latency through the roof.

Incompatibility with columnar compression. Modern analytical platforms achieve processing breakthroughs by storing data in columnar formats like Apache Parquet or Delta Lake. Columnar storage enables an engine to read only the specific data fields requested by a query, such as scanning just the blood pressure values across millions of rows, while completely skipping the rest of the file on disk. Raw FHIR documents are inherently row-based text strings. Even when stored within document databases, they cannot leverage the massive compression ratios and vectorized execution speeds that define modern analytical architectures.

FHIR as the strategic edge gateway

Acknowledging these limitations does not mean abandoning FHIR within a data mesh. Rather, it requires deploying FHIR to where its strengths are maximized, which is at the boundaries of the domain nodes.

In a mature architecture, FHIR acts as a highly protective perimeter interface, executing two vital roles.

The standardized ingest door. Instead of forcing domain data engineers to write brittle, custom extract scripts for proprietary legacy vendor databases, the enterprise exposes data exclusively via standard FHIR feeds (such as Bulk FHIR Export or real-time streaming subscriptions). The domain ingests this data as a clean, semantically predictable baseline. The incoming data is guaranteed to conform to strict, validated international profiles, instantly eliminating the initial wave of parsing friction for the local data team.

The semantic anchor for federated governance. The most difficult aspect of a decentralized data architecture is maintaining global interoperability. If the oncology domain identifies a patient via an internal research code and the revenue cycle domain identifies that same patient via a billing account number, the mesh collapses into un-joinable silos.

FHIR solves this at the governance layer by providing universal "join keys" and terminology frameworks. The federated governance council mandates that while individual domains have the absolute autonomy to transform, flatten and optimize their data internally, any field representing a clinical concept must maintain or link back to its standard FHIR code system mappings (such as LOINC for laboratory results, SNOMED-CT for clinical findings and RxNorm for medications) and utilize the enterprise master patient index as a universal identifier.

By enforcing this boundary thesis, a health system captures the unparalleled semantic interoperability of FHIR at the edge while shielding its core analytical engines from the structural overhead of transactional data structures.

With FHIR secured at the perimeter as a clean ingestion gateway, the internal domain engineers can pivot to their next core task, which involves processing raw streams into high-performance, refined data products.

In the final installment of this series, we will explore how to implement the Medallion architecture strictly as an inner-domain micro-pattern, complete with a technical transformation deep dive and an executive execution blueprint.

Aaron Seib, PMP, FACHDM, CDMP-practitioner, is chief data interoperability officer at Goldbelt Apex LLC, and former senior vice president of strategy and innovation for NewWave Telecom & Technologies.


This article is part 2 of a 3-part series. Read part 1: Four pillars that are crucial to a successful data mesh initiative.

More for you

Loading data for hdm_tax_topic #better-outcomes...