Thursday, August 13, 2009

Baseball Data Modeling

Anyone out there like baseball? Ever had a desire to model a baseball game?

I do and I have tried a few times in the past. It get's pretty hairy down at the game game/inning/player level. If I remember correctly, substitutions tripped me up a bit. There there's the whole datawarehouse side, I'd like that to be part of the project as well.

I started a project on Google Code here, the name is pretty vanilla, baseball-database. If you join you can suggest a better name.

I'd like to try and talk Oracle into giving a few licenses to the recently released production version of SQL Developer Data Modeler. I've hit up @krisrice on Twitter, but he has no control over licenses, just development. I've also hit up Justin Kestelyn (@oracletechnet) who said he would look into it.

I've had no time lately to bother him; perhaps with a few more people...

If you are interested, just drop me a line chet at oraclenerd or message me through twitter.

3 comments:

Crisatunity said...

I didn't find SQL Developer Data Modeler very team-friendly. Did you?

You should give it a go modeling without a visual modeler more sophisticated than paper/pencil.

If I wasn't hip deep in my own thing, this would be right good fun.

oraclenerd said...

Haven't tried it in a team environment...well, that's not completely true. When I first started using it for the PMDV project, I realized quickly that the one xml file was not enough...there was a whole subdirectory of folders and files.

I can honestly say I don't care a whole lot about the ability to generate DDL, I care more about the visual representation of the model. For some sick reason I write all my DDL by hand.

BTW, I thought you didn't care for baseball?

Shay said...

Try using the database modeler in JDeveloper - it is free.
Demo here:
http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/DB_Dev_Templates/11g_DB_Templates.htm