Sunday, June 10, 2012

Baseball Statistics Data Model

20 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.





20 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. บาคาร่าออนไลน์

  17. seoexpert says:

    I am jovial you take pride in what you write. It makes you stand way out from many other writers that can not push high-quality content like you. https://toto-connect.com/

  18. seoexpert says:

    You have performed a great job on this article. It’s very precise and highly qualitative. You have even managed to make it readable and easy to read. You have some real writing talent. Thank you so much. แทงบอลสเต็ป

  19. seoexpert says:

    The article looks magnificent, but it would be beneficial if you can share more about the suchlike subjects in the future. Keep posting. soccer scores api

  20. markson says:

    What you have to make sense of from the model where the client will drop the membership. Data Analytics Courses

Leave a Reply

Labels