I only recently discovered this pattern for data model design. If you’ve heard of the centipede schema previously, then it’s probably as a warning rather than a recommendation. This rare dimensional modeling pattern represents what happens when the normalization philosophy of snowflake schemas is taken to its logical (or perhaps illogical) extreme. Named for its … Continue reading Centipede Schema