The Cygnus Project: HM Database Study

Cygnus · 11-13-2008, 11:00 AM

Greetings all.

Like many of you, I used other software for my poker needs for a long time. I had heard about HM and finally felt I owed it to myself to give it a shot.

I was impressed with HM and took a big leap and converted. I believe HM is better. However, will the community be better? The old community was damn good and was no small part of the value of the product. HM can also have a strong community but it is up to us.

There is one certainty of poker software. If you build it, there will be guys like me who want to understand the database underneath it so they can write their own queries. It's like death and taxes.

The custom reports feature is great. I'm just more comfortable with sql and would rather do my research that way.

I don't see alot of HM table research out here, so I'm going to start my own project. The goal will be to understand every table and column in HM.

I intend to have a thread per table for ease of discussion. Each thread will start with "The Cygnus Project: [Tablename] Table" to make later searching easier.

Cheers,

Cygnus

Al1 · 11-13-2008, 11:18 AM

Don't know if it helps but you can find every stats "formula" here:

http://208.109.95.123/forum/showthread.php?t=3595

Cygnus · 11-13-2008, 11:21 AM

Yes I have seen that thread and it's extremely helpful.

Thanks!

Cygnus

Cygnus · 11-13-2008, 12:03 PM

I've noticed that many tables have a twin with "_hero" at the end.

It looks like this is the same table, with only hero data in it. Fairly obvious but thought I'd mention it.

Also, hero data does appear to be included in the base table. I'm guessing _hero tables are there to calc hero stats more quickly since there's so much more data to parse through.

Cygnus

Rvg72 · 11-13-2008, 08:56 PM

Quote:

Originally Posted by Cygnus

I've noticed that many tables have a twin with "_hero" at the end.

It looks like this is the same table, with only hero data in it. Fairly obvious but thought I'd mention it.

Also, hero data does appear to be included in the base table. I'm guessing _hero tables are there to calc hero stats more quickly since there's so much more data to parse through.

Cygnus

Exactly - this is a new thing. If you had an older version and upgraded to a recent one you would notice that it goes through an optimization which basically copies all hero data from the main tables into these _hero ones. New inserts into the DB happen on both the main and the _hero when applicable.

Doing this can increase performance by 10-20x on large DB's with mined data when reporting on a hero.

Roy

cotte · 11-13-2008, 09:40 PM

This project is an excellent idea.

It will be a great reference for anyone who doesn't quite understand the meaning of each table and column (= myself

) in the database.
I'm looking forward to the results.

11-13-2008, 11:00 AM	#1 (permalink)
Cygnus Junior Member Join Date: Nov 2008 Posts: 19	The Cygnus Project: HM Database Study Greetings all. Like many of you, I used other software for my poker needs for a long time. I had heard about HM and finally felt I owed it to myself to give it a shot. I was impressed with HM and took a big leap and converted. I believe HM is better. However, will the community be better? The old community was damn good and was no small part of the value of the product. HM can also have a strong community but it is up to us. There is one certainty of poker software. If you build it, there will be guys like me who want to understand the database underneath it so they can write their own queries. It's like death and taxes. The custom reports feature is great. I'm just more comfortable with sql and would rather do my research that way. I don't see alot of HM table research out here, so I'm going to start my own project. The goal will be to understand every table and column in HM. I intend to have a thread per table for ease of discussion. Each thread will start with "The Cygnus Project: [Tablename] Table" to make later searching easier. Cheers, Cygnus Last edited by Cygnus; 11-14-2008 at 11:37 AM.

11-13-2008, 11:18 AM	#2 (permalink)
Al1 Senior Member Join Date: Aug 2008 Location: Geneva Posts: 2,873	Don't know if it helps but you can find every stats "formula" here: http://208.109.95.123/forum/showthread.php?t=3595 __________________ Al1 Holdem Manager Support

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Supported Sites

Downloads

Quick-Start Guides

Forums

FAQs

About Us

Contact Us

11-13-2008, 11:21 AM	#3 (permalink)
Cygnus Junior Member Join Date: Nov 2008 Posts: 19	Yes I have seen that thread and it's extremely helpful. Thanks! Cygnus

11-13-2008, 12:03 PM	#4 (permalink)
Cygnus Junior Member Join Date: Nov 2008 Posts: 19	I've noticed that many tables have a twin with "_hero" at the end. It looks like this is the same table, with only hero data in it. Fairly obvious but thought I'd mention it. Also, hero data does appear to be included in the base table. I'm guessing _hero tables are there to calc hero stats more quickly since there's so much more data to parse through. Cygnus

11-13-2008, 09:40 PM	#6 (permalink)
cotte Junior Member Join Date: Nov 2008 Posts: 5	This project is an excellent idea. It will be a great reference for anyone who doesn't quite understand the meaning of each table and column (= myself ) in the database. I'm looking forward to the results.