[dba-SQLServer] Baseball database(s)

[James Barash]

Arthur,

What you are looking for is The Elias Sports Bureau, www.esb.com. They are the keeper of all sports records; at least according to them. I did work with an early version of a database for baseball about 35 years ago, mostly doing data entry. Unfortunately, that one never did go live mostly due to money problems.
I know that for Major League Baseball, the official scorer for each game submits a pitch by pitch record of the game to Elias who then codes everything and updates their database. Then, each team and the broadcasters have low-paid staffers that query Elias for all those interesting stats.

Here is a link to a paper on Elias and STATS:

https://docs.google.com/viewer?url=http%3A%2F%2Fmoxie.oswego.edu%2F~dstack2%2Fisc110%2FESB.pdf

James Barash

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, June 09, 2015 5:56 AM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] Baseball database(s)

I've often wondered what sort of database technology underlies sportscasts of major league baseball. (Soccer, too.) These sportscasters always seem to have on hand such facts as who currently has the longest string of hits in consecutive games. The reason this example came to mind is because yesterday a Toronto Blue Jay extended his run to 16 games in which he's hit at least once -- currently the longest run this season.

This is of course just one such statistic, and baseball fans seem more concerned than most with stats. It seems there's a stat for virtually every measure you could imagine, and then some. Number of times a given batter has hit off a left-hander with two men on. Number of times a pitcher has struck the batter out with bases loaded and two out in the bottom of the ninth.

The closest I've ever come to such database technology is seeing the movie "Moneyball", which I thought was terrific but hardly a tutorial on the technology. Also to be considered is the rapidity of updates: not many when compared with, say, Amazon, but still when you consider the number of games played simultaneously and the granularity (every pitch to every player, its result and its place in any pattern (this pitcher likes to throw two fastballs and then a curve; this batter loves to steal second base when there's one out.)

Has any lister had experience with such a database? I'd love to learn more about this subject.

--
Arthur
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com