在FHIR上的SQL - 使用FHIRPath查看FHIR数据的表格视图
John Grimes1, Ryan Brush2, Nikolai Rhyzhikov3
1Australian e-Health Research Centre, CSIRO Health and Biosecurity, Brisbane, Australia. John.Grimes@csiro.au.
NPJ digital medicine
|June 9, 2025
概括
从Fast Healthcare Interoperability Resources (FHIR) 中创建表格数据视图的新标准方法解决了医疗保健分析方面的挑战. 这种关于FHIR的SQL方法提高了大型复杂数据集的数据可访问性和查询性能.
科学领域:
- 医疗信息学 医疗信息学
- 数据管理数据管理
- 数据库系统 数据库系统
背景情况:
- 在分析中采用快速医疗互操作性资源 (FHIR) 被复杂的数据结构 (JSON/XML) 和大数据集的性能问题所阻碍.
- 现有的FHIR数据转换和查询解决方案往往难以实施.
- 需要一种标准化,实现无关的方法来促进FHIR数据分析.
研究的目的:
- 开发和验证一种新的规范,用于定义从FHIR资源中生成表格数据的视图.
- 创建一个不依赖实施的方法,以便在医疗保健分析中更容易采用.
- 证明拟议方法在不同平台上的可移植性和一致性.
主要方法:
- 一个国际工作组在18个月的时间里制定了新的规范.
- 开发和测试了多个独立的实现来验证规范.
- 通过使用各种视图运行器和数据库实现,复制先前研究的结果来评估可行性.
主要成果:
- 为在FHIR视图上定义SQL而建立了一个标准的,实现无关的方法.
- 这些视图定义可以在各种技术平台上执行.
- 对现有研究结果的复制表明了该方法的可移植性和一致性.
结论:
- 开发的SQL on FHIR视图定义方法为FHIR分析中的挑战提供了可行和有效的解决方案.
- 这种方法简化了将复杂的FHIR数据转换为可用的表格格式.
- 证明的可移植性和一致性支持更广泛的采用,以改善医疗保健数据的可访问性和分析.
相关概念视频
01:45ER Retrieval Pathway
3.8K
In the secretory pathway, vesicles transport proteins from one cellular compartment to another in forward transport to deliver the protein to its correct location. Occasionally, misfolded proteins and incorrect proteins escape their original compartments, and a retrieval pathway is used to return the escaped proteins to their original compartment.
The ER uses many checkpoints to prevent the entry of incorrectly folded or a resident protein as cargo onto a transport vesicle. These mechanisms...
The ER uses many checkpoints to prevent the entry of incorrectly folded or a resident protein as cargo onto a transport vesicle. These mechanisms...
3.8K
01:17Flow Sheet
1.5K
Flowsheets are valuable tools in nursing documentation. They enable healthcare professionals to efficiently record and monitor various patient assessments and measurements in a consolidated format.
Here's a closer look at the examples of flowsheets commonly used by nurses:
Graphic Sheet Documentation:
Here's a closer look at the examples of flowsheets commonly used by nurses:
Graphic Sheet Documentation:
1.5K
01:30Health Information Technology and Healthcare Information System
810
Health Information Technology (HIT)
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
810
01:26Methods of Documentation IV: Focus Charting
1.0K
Focus Charting, also known as the focus charting system or "focus documentation," is a systematic documentation approach used in healthcare to organize patient information in medical records.
It typically involves three columns for recording information:
It typically involves three columns for recording information:
1.0K
01:28Formats for Nursing Documentation
918
Nursing documentation encompasses various formats designed to capture precise patient data, facilitate communication among healthcare team members, and ensure comprehensive and accurate patient records. Let's explore each of these formats in detail:
Nursing Assessment Form:
• A nursing assessment form is a foundational document that captures detailed patient data from physical assessments and nursing histories.
• It includes patient demographics, medical history,...
Nursing Assessment Form:
• A nursing assessment form is a foundational document that captures detailed patient data from physical assessments and nursing histories.
• It includes patient demographics, medical history,...
918
01:17Pathophysiology of Heart Failure
1.5K
Heart failure (HF) is a progressive syndrome involving ventricles that leads to inadequate cardiac output. It can be classified based on location and output or ejection fraction. Ejection fraction (EF) is an essential measurement in the diagnosis and surveillance of HF. Reduced EF corresponds to systolic heart failure (HFrEF). However, HF with preserved ejection fraction (HFpEF) is becoming increasingly prevalent. Also known as diastolic HF, this form of HF is related to aging. The...
1.5K