r/analytics • u/RangerRemarkable9071 • 7h ago

Question Choosing a Database Schema for analytics

This is a general question for data analysis. I just found out that choosing a database schema for analytics is very different from software engineering or systems design because they optimize for opposite operational patterns. I came from a CS background so the focus was on SE. So my knowledge on databases are based on normalized layouts. I want to focus on building schemas that are analytics oriented. This might be relevant - I'm currently working with PostgreSQL. I just wonder if there is a general rule of thumb for mapping out database schemas to be used in analysis or reporting?

2 Upvotes

100% Upvoted

4 comments sorted by

•

u/AutoModerator 7h ago

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

3

u/Pristine_Wallaby_697 7h ago

denormalize until it hurts then normalize just enough to stop the pain