Tom - I am looking over the Events DDL you posted on your blog. Could you also post the list of fields in your Games table? thanks Brian...
2
tangotiger
Apr 30, 2008 11:41 pm
I've uploaded what I have so far here: http://sports.groups.yahoo.com/group/RetroSQL/files/Beta/ Until they are production-ready, I'll reserve the right to...
3
Mat Kovach
matkovach
May 1, 2008 1:20 pm
... These are Oracle SQL files, correct? Since we are using Chadwick, I created extra tables for subs (from CWSUB), and tables for the teams and rosters also....
4
tangotiger
May 1, 2008 2:07 pm
... I just added the ROSTERS and TEAMS tables to the BETA folder, along with the accompanying files and perl script. Note that I expect very shortly to create...
5
Brian L. Cartwright
brianlcartwr...
May 1, 2008 2:09 pm
Sent: Thursday, May 01, 2008 9:20 AM ... What is the SUBS file? These may be the tables we need for storing just the Retro data, but I would propose designing...
6
Mat Kovach
matkovach
May 1, 2008 2:14 pm
On Thu, May 1, 2008 at 10:09 AM, Brian L. Cartwright ... Subs is a table I create from data generated from the CWSUB command: mysql> select * from...
7
Brian L. Cartwright
brianlcartwr...
May 1, 2008 2:21 pm
1. BEVENT field 96 is "event num" - I do not see this in your event table (please correct me if I overlooked it) I find this important to be able to explicitly...
8
Brian L. Cartwright
brianlcartwr...
May 1, 2008 2:22 pm
Sent: Thursday, May 01, 2008 10:14 AM ... I agree - just keep these things in mind when we take our baby steps Brian...
9
Mat Kovach
matkovach
May 1, 2008 2:28 pm
... I only gave a quick glance at those files and was a bit confused. I figured my EVENTTYPES table was included in there, so I posted about it hoping to...
10
tangotiger
May 1, 2008 2:45 pm
... ,EVENT_ID INTEGER Note that it's in the middle of the listing, since CWEVENT has an extra 50 fields beyond the initial ones from BEVENT. ... I don't follow...
11
tangotiger
May 1, 2008 3:38 pm
I uploaded the "030" and "040" files. When we go to prod-ready, we should have similar instructions for the other database flavors out there. Tom...
12
Brian L. Cartwright
brianlcartwr...
May 1, 2008 4:05 pm
Sent: Thursday, May 01, 2008 10:45 AM ... Cool ... Yes, I am saying it's not normalized. That might not be the objective of CWEVENT, but it must be our...
13
tangotiger
May 1, 2008 4:22 pm
... There can be thtee objectives: 1. build a normalized database 2. build a database-version of CWEVENT, CWGAME 3. build a database warehouse We can in fact...
14
Brian L. Cartwright
brianlcartwr...
May 1, 2008 4:39 pm
Sent: Thursday, May 01, 2008 12:22 PM ... True, but I thought we were trying to develop an "industry standard" ... LI, Run Expectancy and Win Expectancy are...
15
tangotiger
May 1, 2008 5:42 pm
... That would be an industry standard, to have a datawarehouse! As well, the names being common would be another industry standard. ... Right, exactly my...
16
Alan Karben
karben
May 1, 2008 7:02 pm
Hello Folks, Just posted to Retrolist introducing the SQL effort we've been undertaking for the past few months. Would love to find ways that our effort could...
17
tangotiger
May 1, 2008 8:12 pm
... I use Creative Commons as noted at the bottom of this page: http://www.tangotiger.net/wiki/ "Creative Commons Attribution-Noncommercial-Share Alike...
18
Mat Kovach
matkovach
May 1, 2008 8:12 pm
D'oh! My filter was only look for retro and yahoogroups.org! ... From: Tangotiger <tom@...> Date: Thu, May 1, 2008 at 4:10 PM Subject: Re:...
19
tangotiger
May 1, 2008 8:15 pm
Forwarding here, and keeping all discussions pertinent to RetroSQL here, not RetroList. Tom ... Subject: [RetroList] Re: SQL database from Retro data: More...
20
Mat Kovach
matkovach
May 1, 2008 8:15 pm
... Give me a day to get the difference listed so we can make the best choice available. I typically write code, so I avoide the CC licenses. It will take me...
21
Brian L. Cartwright
brianlcartwr...
May 1, 2008 9:31 pm
Sent: Thursday, May 01, 2008 1:42 PM ... Thanks...I need to familiarize myself with the extended fields The main reason for normalization is file maintenance....
22
tangotiger
May 1, 2008 9:51 pm
... I'm totally on board with all things 3NF. But, our tables are data dumps of Chadwick. So, we definitely cannot correct anything, since we are not the...
23
Brian L. Cartwright
brianlcartwr...
May 1, 2008 10:15 pm
Sent: Thursday, May 01, 2008 5:51 PM Subject: Re: [RetroSQL] Event fields ... YES ... Not concerned ... OK, then I may have misunderstood - you want to take...
24
Mat Kovach
matkovach
May 1, 2008 10:24 pm
On Thu, May 1, 2008 at 6:15 PM, Brian L. Cartwright ... Actually, there is two parts (from my view) Make a standard "dump" of Retrosheet into SQL. This is...
25
tangotiger
May 1, 2008 10:36 pm
... Not instead of, but in addition to. We'll have three schemas: RETRODUMP, RETRONORM, RETROHOUSE, each representing a set of tables (with common field...
26
tangotiger
May 2, 2008 10:24 am
... Based on our last posts each (Mat, Brian, me), I think we're finally clear on our goals here. We can proceed with our triple-objective, which we can ...
27
Mat Kovach
matkovach
May 2, 2008 5:02 pm
... Worked with John at SABR: ``I've added this to my spreadsheet -- an hour in Superior Room at 1pm on Thursday.'' Just wanted to give everybody an FYI, we'll...
28
tangotiger
May 3, 2008 10:50 am
I'm thinking of making the following changes for GAMES (old name first, new name second). The reason is that I used to have a limited number of field types...
29
Theodore Turocy
arb1ter
May 3, 2008 7:43 pm
Hi all, One of the obvious upshots of this effort is to make it obvious that the Chadwick documentation has been suffering from benign neglect over the last...
30
Theodore Turocy
arb1ter
May 4, 2008 6:56 pm
Hi all, Tom and I have had some discussions regarding adding extended columns to cwevent to flag Retrosheet plays which are marked as uncertain, or which...
