When does normalization occur in your data warehouse?


Response: There are two uses of the term “normalization” in healthcare data management. In traditional database design, normalization is the term used to describe the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. In healthcare, we use the term normalization to describe the process of rationalizing data to a common vocabulary or definition, such as Patient ID, SNOMED, CPT, LOIN, RxNorm, etc. The term can also be used to describe the process of standardizing the representation of clinical algorithms and business rules, such as calculating length of stay, provider-patient attribution, and defining cohorts of patients for inclusion and exclusion from patient registries. Catalyst has deep and successful experience in all of these definitions of the term. Our Late-Binding™ Data Warehouse methodology is unique in the industry in its ability to quickly adapt and map to the constantly changing vocabulary standards, business rules, and clinical algorithms in healthcare. The diagram below shows the two layers at which data is normalized in the Catalyst architecture.