视图层
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
FHIR 资源和 Parque-on-FHIR 架构的深层嵌套性质要求使用复杂的 SQL 查询，这可能会使其难以用于分析用例。
解决此问题的常见方法是将数据展平为一组视图（虚拟视图或具体化视图），然后使用更简单的 SQL 语句对其进行查询。
使用 FHIR 数据流水线，您可以通过多种方法生成平面表格视图，以便在分析应用中使用，从而满足部署要求：
用于生成虚拟视图的 SQL 查询（在流水线之外）
FHIR ViewDefinition 资源，用于生成可以以任何表格格式输出（目前支持 Parquet 和数据库表）的具体化视图（在流水线中）
对于这两种方法，系统都提供了一组适用于常见 FHIR 资源的“预定义视图”。这些时间可以修改或延长。
前往开发者文档
如未另行说明，那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可，并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情，请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC)：2025-07-25。
[null,null,["最后更新时间 (UTC)：2025-07-25。"],[[["\u003cp\u003eFHIR data's nested structure necessitates complex SQL queries, making analytics challenging.\u003c/p\u003e\n"],["\u003cp\u003eFlattening FHIR data into views simplifies querying for analytics.\u003c/p\u003e\n"],["\u003cp\u003eFHIR Data Pipes offers two approaches for generating flat tabular views: SQL queries for virtual views and FHIR ViewDefinition resources for materialized views.\u003c/p\u003e\n"],["\u003cp\u003ePredefined views for common FHIR resources are available and customizable.\u003c/p\u003e\n"],["\u003cp\u003eExplore detailed information and implementation guidance in the developer documentation.\u003c/p\u003e\n"]]],["FHIR data's complexity necessitates flattening for analytics. This is achieved by creating tabular views, either virtual or materialized. Virtual views are created using SQL queries, while materialized views are generated via FHIR ViewDefinition resources, outputting in formats like Parquet or DB tables. FHIR Data Pipes supports both methods, providing predefined views for common FHIR resources that can be customized, to facilitate analytics applications. Further details are available in the developer documentation.\n"],null,["# View Layer\n\nThe heavily nested nature of FHIR resources and the Parque-on-FHIR schema\nrequires complex SQL queries that can make them difficult to work with for\nanalytics use cases.\n\nA common approach to address this is to flatten the data into a set of views\n(virtual or materialized) which can then be queried using simpler SQL\nstatements.\n\nUsing FHIR Data Pipes, there are multiple approaches for generating flat tabular\nviews for use in analytics applications to match the deployment requirements:\n\n1. SQL queries to generate virtual views (outside the pipeline)\n\n2. [FHIR ViewDefinition](https://build.fhir.org/ig/FHIR/sql-on-fhir-v2/StructureDefinition-ViewDefinition.html) resources to generate materialized views (within the pipeline)\n which can be outputted in any tabular format (with current support for Parquet\n and DB tables)\n\nFor both of these approaches, a set of \"predefined views\" for common FHIR\nresources are provided. These can be modified or extended.\n\nGo to [developer documentation](https://google.github.io/fhir-data-pipes/)"]]
