Modelling Conventions

All Open Data Blend Datasets are created by using dimensional modelling techniques to optimise the data for data analysis. We carefully transform the source data into facts (i.e. the tables with columns containing measurable values such as the number of prescription items) and dimensions (i.e. tables with the columns containing descriptive values such as the name of a prescribed medicine).
There are a vast number of resources that explain what these modelling practices are and why they exist. Rather than reinventing the wheel, we recommend looking through this comprehensive glossary by the Kimball Group.

We use the following column prefixes in our data files:
Prefix
Description
nlm_
Metadata column*
nll_
Licence information column*
src_
Source column
srk_
Source column that is also a natural key
drv_
Derived column*
drk_
Derived column that is also a natural key*
*The values in these columns either originate from Open Data Blend or are derived from source columns by Open Data Blend.

All column names are in lower-case, alpha-numeric (no special characters), and spaced using underscores. This is to ensure the broadest level of compatibility across all tools and platforms.

Acronyms are expanded to their corresponding word parts except for when the acronym is very well known and non-ambiguous. Even then, it may still be expanded.

Foreign key references are implied. It's safe to assume that whenever two tables each have a column name that starts with drv_ and ends with _key (e.g. drv_prescribing_practice_key), these columns are intended to be joined.
Copy link
On this page
Star Schemas
Naming Conventions
Column Prefixes
Column Names
Acronym Handling
Foreign Key References