star-schema – Tarik Billa

Data Warehousing – Star Schema vs Flat Table

January 6, 2024 by Tarik

Your question is very good: the Kimball mantra for dimensional modelling is to improve performance and to improve usability. But I don’t think it is outdated, or dogma- it is a reasonable, practical approach for many situations and platforms. The way relational DBs store data means there’s a balancing act to be struck between the … Read more

Star-Schema Design [closed]

March 20, 2023 by Tarik

Using star schemas for a data warehouse system gets you several benefits and in most cases it is appropriate to use them for the top layer. You may also have an operational data store (ODS) – a normalised structure that holds ‘current state’ and facilitates operations such as data conformation. However there are reasonable situations … Read more