fact table as "fat" table

Discipline

Databases

Form

Database Analogies

Attribution — Origin / Source

Collected by Daphne Miedema — Hellerstein, J. M., & Stonebraker, M. (2005). Readings in Database Systems. 4 ed. MIT Press.

Topic

Conceptual modeling

Domain

Anything else

Conceptual Advantage

The concept of a 'fat table' conjures an anthropomorphic image

Mapping

SymbolConcept

Draws Attention To

How tables in a star schema can get bigger than our normal conception of 'big'.

Details

Text

The key observation is that Fact tables [in the star schema] are generally “fat” and often contain a hundred or more attributes. Obviously, they also “long” since there are many, many facts to record.

Comments or Feedback?

Do you have feedback on this notional machine? Did you find a mistake, or do you have a request for improvement? You can create an Issue on GitHub, where the description is hosted. This way we can see your feedback and address it.

For this, you need a GitHub account. Then follow this link to see the source file of this page. In there, click the ... left of the highlighted line, then pick "Reference in a new issue".

Create an Issue on GitHub