Healthcare
Role
Semantic Architect
OMOP Common Data Model
Implementation Catalogue
Object and field catalogue for vocabulary mapping, ETL design and semantic validation in healthcare.
Architecture Flow
§ 01 Context
An implementation-oriented catalogue of the OMOP Common Data Model: principal objects, field-level contracts, source concepts, standard concepts and vocabulary resolution, together with structural and semantic validation used to guide ETL design.
§ 02 Designed System
◆Principal OMOP objects catalogued
◆Field-level contracts
◆Source concepts and standard concepts mapping
◆Vocabulary resolution
◆Structural and semantic validation
§ 03 Capabilities
- —Vocabulary alignment across sources
- —ETL guidance driven by explicit field contracts
- —Semantic validation ahead of publication
§ 04 Objects & Stack
Data Objects
- Person
- Visit Occurrence
- Condition Occurrence
- Drug Exposure
- Measurement
- Observation
- Concept
- Vocabulary
Technologies
PostgreSQLPythonOMOP CDM
§ 06 Related Reading
Essay 14
Contract-First: Design Meaning Before Loading Data
Essay 06
Every Source Speaks a Dialect
<mark>Heterogeneous information systems do not merely encode the same reality in different technical formats. They often partition reality differently, assign different identities, privilege different events, and embody different professional practices. To say that every source speaks a dialect is therefore more than a metaphor for incompatible column names. It is a statement about local ontologies. This essay examines data integration as a problem of translation rather than transcription. Drawing on linguistics, philosophy of language, ontology engineering, and category-theoretic intuition, it distinguishes lexical mapping from structural and pragmatic equivalence. It proposes a typed translation model that preserves local expressions while projecting them into shared Data Objects, and it explains why some mappings are exact, some contextual, and some irreducibly lossy. The goal of a mature Data Platform is not to abolish dialects but to establish a governed interlanguage through which local systems can participate in common computation without having their differences silently erased.</mark>