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.
I didn't find SQL Developer Data Modeler very team-friendly. Did you?
ReplyDeleteYou 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.
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.
ReplyDeleteI 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?
Try using the database modeler in JDeveloper - it is free.
ReplyDeleteDemo here:
http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/DB_Dev_Templates/11g_DB_Templates.htm