0

I want to design a database of basketball players and their stats. I hear star schema databases are the best for these type of tasks.

If I'm not mistaken, star schema has dim and fact tables.

I plan to load scores/stats into the fact tables and teams,year, coach, conference, etc in the dim tables. Is this an acceptable approach?

Im a noobie at database design so please help if you can or give me your thoughts on my process. Thanks!

user3747201
  • 1
  • 4
  • A fact table represents a process or event that you want to analyze. You can have multiple fact tables. So the question is, what is the process or event that you want to analyze? – Neil McGuigan Jul 02 '14 at 17:43
  • I want to be able to show stats(points, assists, rebounds, blocks, steals, etc) for each player. If understood you correctly, you suggestI have a fact table for each type of stat? ex. one for points, one for assists, etc – user3747201 Jul 02 '14 at 23:15
  • It depends on the grain of your analysis. Are you analyzing by play? possession? game? – Neil McGuigan Jul 03 '14 at 01:59
  • by game. I want to be able to look up the avg points per game,assist per game, steals per game for any given player at any given year – user3747201 Jul 03 '14 at 02:17
  • Not sure if you're still interested in doing this, but I have designed a schema that scrapes nba.com and populates player data associated with teams so you can analyze information granularly (i'm still learning queries in ruby on rails so that's taking a while) – MageeWorld Jul 06 '16 at 14:48

0 Answers0