The poker database is a very important part of the game system; monitoring and managing the daily operation of a poker room is essential. Think of the poker database essentially as the common repository for dynamic data like game records, money transactions, etc. and static data such as user profile, game properties, etc. and it is widely used by almost all subsystems. The game system uses the Oracle database.

The poker database has the following prominent features:

o The schema is designed to be flexible, scalable, and maintainable with data integrity, performance, normalization, and simplicity in mind.

o Each parent table in the system has a corresponding record table to track changes to master data.

o Indexes are chosen carefully to get the best retrieval performance without costing much in insert performance.

o The poker database is accessed from applications using what our programmers call a bit-mechanical Java Database Connectivity (JDBC) connection pool API.

o Applications query/manipulate data using stored procedures to keep data access clean and consistent across all application modules, while centralizing all business logic within the poker database.

o The poker database has more than 300 tables with more than 600 stored procedures.

Some of the important tables in the poker database:

T_USER – This is a main table that contains user profile details like account name, password, first and last name, email id, address and also other essential user information like affiliate id, referrer, last access time, etc

T_GAME_LIVE – Records information about every game played on the site, such as game number, table type, table name, time, total rake, etc.

T_PLAYER – Records game information such as bets, wins, rake contributions, etc. of each game of each user.

T_INVESTIGATION – This is the main table for capturing the poker research team’s findings about a user and their activities on the site and helps control fraud and collusion.

T_Wallet_Transaction – This table records all of the user’s real money transactions such as purchases, redemptions, bonuses, etc.

T_BONUS_RULE: This main table that captures various promotional bonus schemes configured in the System.

T_TOURNAMENT – Records details about all tournaments played on the site, such as time, tournament type, table name, etc.

The poker database is a very essential component of the gaming system. A dedicated team is required to first design the poker database and then manage and maintain it 24/7. He provides absolute input to all teams from transaction management, customer service and fraud control. If the gaming system has a backbone, it’s the poker database.