Sunday, June 10, 2012

Baseball Statistics Data Model

16 comments
A few months ago I was working in a sports portal project. As a database developer, my first task was designing data model for Baseball sports. I am living in Bangladesh where I have not ever played the game. Even I did not watch the game in television let alone my knowledge on game rules and statistics. But I have to solve the task.
So what I did I read the following two links :-
Baseball Rules
Baseball Statistics

These two links help to gather knowledge on the game. But theoretical knowledge was not enough for me and as I am a sports lover from my childhood, I collect the game BASEBALL 2005 by EA Sports. Playing the game I got myself interested in Baseball and also I got the knowledge about it.
Finally, I designed the data model for the development team which I added here below:-



I designed the data model in 3 layers-
1. Common Layer : 
This layer was designed to support player profile entry, player roster management, teams, stadium. It was named Common as we planned to re-use this part for other games also. The tables are  - Players
- Team_Rosters
- Season
- Roster_details
- Team
- Stadium
- Position
- Game
- Game_Roster
2. Game Layer:
This layer was designed specifically to support Baseball game. Tables are
- Half_innings
- Batter_at_bat
- Pitcher
- Plate_outcome
- Plate_outcome_types
- Picher_statistics_at_half_innigs
- Batter_statistics_at_half_innigs
3. Statistics Layer:
This layer was designed to summarize the game layer's data to display the statistics.Tables are
-Batter_stats_in_game
-Picther_stat_in_game

The rest of the logic was written in application layer.





16 Responses so far

  1. alex mark says:

    Your hands may persevere through an unbelievably intense and desensitizing stinger from an inside fastball on an icy day, yet the bat won't break. axialsports

  2. Irvin says:

    How did you make the relationship entity model?

  3. anna says:

    I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article.: best in ground basketball hoop

  4. Jack son says:

    This year, the competition begins the fifth of March up to the 23rd and again will highlight 16 baseball playing countries over the globe. 안전놀이터

  5. markson says:

    The AI motor will be the one breaking down your information and conveying modified reports with respect to your business group.ai courses

  6. seoexpert says:

    I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. 안전놀이터

  7. seoexpert says:

    I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. qqdewa

  8. seoexpert says:

    I love the way you write and share your niche! Very interesting and different! Keep it coming! daftar sbobet

  9. seoexpert says:

    Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. เว็บแทงบอล

  10. seoexpert says:

    Thank you for taking the time to publish this information very useful! bet88

  11. seoexpert says:

    Your website is really cool and this is a great inspiring article. https://reelkorea.com/

  12. seoexpert says:

    This blog is so nice to me. I will keep on coming here again and again. Visit my link as well.. 릴게임야마토

  13. seoexpert says:

    Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. Situs QQ

  14. seoexpert says:

    This particular papers fabulous, and My spouse and i enjoy each of the perform that you have placed into this. I’m sure that you will be making a really useful place. I has been additionally pleased. Good perform! แทงบอลออนไลน์

  15. seoexpert says:

    I would like to say that this blog really convinced me to do it! Thanks, very good post. บาคาร่าออนไลน์

  16. seoexpert says:

    I would like to say that this blog really convinced me to do it! Thanks, very good post. บาคาร่าออนไลน์

Leave a Reply

Labels