The application focuses on basic reporting and data mining such as statistical analysis
of each player (Win/loss, fold/check/call/bet/raise) and individual hand data (players
in hand, winners, last round, pot size, rake size); however the database schema
can support arbitrarily complex data mining and reporting. Our key features are
a simple user interface with many different reporting options and the ability to
create charts and graphs dynamically.
Here are some of our current database statistics:
|
Statistic
|
Value
|
|
Total DB Size
|
188MB
|
|
DB Size without HTML Logs
|
55MB
|
|
Number of Tables
|
13
|
|
Number of Views
|
9
|
|
Number of Indexes
|
33
|
|
Number of Stored Procedures
|
12
|
|
Table Name
|
Row Count
|
|
Action
|
243,924
|
|
|
BlindType
|
5
|
|
|
Card
|
53
|
|
|
CardSet
|
61,109
|
|
|
CardSetEntry
|
98,085
|
|
|
ConstantTypes
|
18
|
|
|
Hand
|
9,857
|
|
|
Player
|
1671
|
|
|
PlayerOutcome
|
71,611
|
|
|
RawData
|
28,769
|
|
|
Round
|
56,500
|
|
|
StartHandData
|
51,252
|
|
|
Table
|
10
|
|
|