Created
December 22, 2025 09:06
-
-
Save perfaram/53f96043fbd0258fc937fc939663bccd to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Medallion - Silver layer - Variants | |
| 3 variants: | |
| *"Schema normalization"*: still semistructured OBT, but with an interpretation of facts according to protocols and sources, into a standardized business-oriented schema. | |
| *"Value extraction"*: records are extracted (through MVs) to tables that represent business use-cases. These tables are "regular", where relevant values are mapped to their own columns. | |
| *"Projection"*: as above, but only values necessary for filtering (determined by business needs) are extracted to their own columns in projections. The content is still mainly stored in the raw fact. Aliases or (non-M) views are used to simplify interpretation at the querying stage. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment