Data mining

[tjh]

Has anyone done any data mining of the SNG hands that they have in Poker Tracker ?

I am thinking about dumping the database tables to MySQL and running some queries on them. I am quite familiar with MySQL and SQL but I also see no need to reinvent the wheel so I thought I would see if anyone has done similar work.

Seems like it would be trivial to get data that would be useful such as ...
Range of hands that players push in level x
Range of hands that players call an all-in in level x

Seems like you could test a lot of assumptions. Such as
"how much tighter do they get on the bubble ? "
Or
"how effective is a stop and go compared to a preflop push? "

So if anyone wants to discuss data structure, data mining and some sample SQL queries then please use this thread to discuss.

Thanks

Tom

[brimstone1]

Just out of curiosity, which level are you planning on doing this for?

[tjh]

I play the 22's at party and the 22's at UB so that is all that I have data for. Judging by the lack of response to this thread nobody else is messing around with data mining. I will let the forum know when I give it a try because I assume someone may want to run my queries on larger more meaningful data sets at various levels.

--
tjh

[swiftrhett]

Poker tracker already stores it in access or postgresql. I'm also more experienced with mysql, but are you really going to convert the whole database rather than just do some postgresql queries?