data fabric
data_fabricDefinition
ISO-11179 Definition
A data management architecture that uses metadata, knowledge graphs, and AI-driven automation to integrate data across heterogeneous environments — on-premises, cloud, and multi-cloud — providing a unified semantic layer that simplifies data discovery, access, and governance without requiring physical data movement. In healthcare, data fabric approaches are used to create virtual integrated views across EHR systems, claims databases, and external reference data sources.
Standard Abbreviation
data_fabric
Category
Production DDL — DIM_SYSTEM
CREATE OR REPLACE TABLE DIM_SYSTEM (
sys_key INTEGER NOT NULL -- surrogate key,
sys_id VARCHAR(50) NOT NULL -- system identifier,
sys_nm VARCHAR(200) NOT NULL -- system name,
sys_type_cd VARCHAR(50) -- system type code,
sys_vrsn VARCHAR(50) -- system version,
vndr_nm VARCHAR(200) -- vendor name,
intfc_type_cd VARCHAR(50) -- interface type code,
intfc_proto_cd VARCHAR(20) -- interface protocol,
env_cd VARCHAR(20) -- environment code,
host_nm VARCHAR(200) -- hostname,
ip_addr VARCHAR(45) -- IP address,
sts_cd VARCHAR(20) -- status code,
eff_dt DATE NOT NULL -- effective date,
exp_dt DATE -- expiration date,
rec_creat_dt TIMESTAMP NOT NULL -- record created date
);
Standard Snowflake DDL for the canonical technology table. Convert to BigQuery or Databricks →
Why This Term Matters
Healthcare data terminology is foundational for any data engineer working in this industry. Precise understanding of standard terms enables accurate schema design, reduces downstream data quality issues, and ensures pipelines meet the regulatory and interoperability requirements imposed by HIPAA, HL7 FHIR, and CMS reporting frameworks. Without this foundation, even technically well-built pipelines produce data that fails validation when it reaches payers or regulators.
Related Content
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms