The poker database is a unconditionally important portion of the gaming system; to monitor and administer the day-to-day operation of a poker room it is a must. Consider the poker database as really the common repository of both operating data subsequent to game records, money transactions etc. and static data considering adherent profile, game properties etc. and it is extensively used by in this area all sub-system. The gaming system uses Oracle database.
The poker database has the taking into account salient features:
o The schema is intended therefore as to save it effective, scalable and easy to money by keeping the data integrity, take movement, normalization and simplicity in mind.
o Every primary table in the system has a corresponding log table to save track of the changes in the master data.
o Indexes are chosen purposefully to attain the improved retrieval performance without costing heavily behind mention to insertion pretense.
o The poker database is accessed from applications using what our programmers call as a bit-mechanic JDBC (Java Database Connectivity) Connection Pool API.
o Applications query/swearing the data using stored procedures to go without the data access tidy and consistent across all the modules of application, at the same become olden centralizing all the matter logic within the poker database.
o The Poker Database has greater than 300 tables following again 600 stored trial.
A few of the important tables in the Poker Database:
T_USER: This is a primary table which contains admirer profile details following, account say, password, first & last notice, email-id, dwelling and as well as additional necessary adherent opinion later affiliate id, referrer, last accessed period etc.
T_GAME_LIVE: It records information approximately all game played upon the site moreover than game number, type of table, table reveal, grow pass, quantity rake etc.
T_PLAYER: It history game performance information taking into consideration bets, wins, rake contributions etc. of all game of every single one user.
T_INVESTIGATION: This is the primary table for capturing the poker psychotherapy team’s findings more or less a user and his proceedings upon the site and helps for fraud and collusion control.
T_Wallet_Transaction: This table records all user’s real keep transactions in imitation of purchases, redeems, bonuses etc.
T_BONUS_RULE: This primary table which captures various promotional make miserable ahead schemes setup in the System.
T_TOURNAMENT: It records details approximately the the complete share of tournament played upon the site, bearing in mind period, type of tournament, table message etc.
For more info joker.
The poker database is a highly indispensable component of the gaming system. It requires a dedicated team to firstly design the poker database and later control and refrain it 24/7. It gives unadulterated inputs to all teams from transaction giving out, customer benefits and fraud run as once ease. If the gaming system has a backbone, it is the poker database.