Poker Database
The poker database is a totally important share of the gaming system; to monitor and administer the hours of daylight-to-day operation of a poker room it is a must. Consider the poker database as really the common repository of both full of zip data as soon as game archives, maintenance transactions etc. and static data subsequently than fanatic profile, game properties etc. and it is extensively used by regarding all sub-system. The gaming system uses Oracle database.
The poker database has the behind salient features:
o The schema is expected consequently as to save it gymnastic, scalable and easy to retain by keeping the data integrity, be swift, 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 selected carefully to profit the bigger retrieval undertaking without costing heavily concerning insertion take effect.
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/shout insults the data using stored trial to save the data entry tidy and consistent across all the modules of application, at the linked grow olden centralizing all the business logic within the poker database.
o The Poker Database has on peak of 300 tables subsequent to on zenith of 600 stored events.
A few of the important tables in the Poker Database:
T_USER: This is a primary table which contains enthusiast profile details with, account reveal, password, first & last post, email-id, domicile and also add-on indispensable devotee recommendation in the space of affiliate id, referrer, last accessed period etc.
T_GAME_LIVE: It archives recommend just very roughly every one of game played upon the site once game number, type of table, table make known, era, quantity rake etc.
T_PLAYER: It archives game motion mention to come bets, wins, rake contributions etc. of each and every one one one game of every one enthusiast.
T_INVESTIGATION: This is the primary table for capturing the poker psychiatry team's findings roughly a user and his activities upon the site and helps for fraud and collusion manage.
T_Wallet_Transaction: This table chronicles every user's legitimate money transactions later purchases, redeems, bonuses etc.
For more info dewapokerqq
T_BONUS_RULE: This primary table which captures various promotional added schemes setup in the System.
T_TOURNAMENT: It records details about the every tournament played upon the site, in imitation of time, type of tournament, table state etc.
The poker database is a highly choking component of the gaming system. It requires a dedicated team to firstly design the poker database and later control and preserve it 24/7. It gives unconditional inputs to all teams from transaction commissioner, customer further and fraud manage as ably. If the gaming system has a backbone, it is the poker database.
Comments
Post a Comment