The poker database is a the entire important share of the gaming system; to monitor and administer the hours of hours of daylight-to-day operation of a poker room it is a must. Consider the poker database as essentially the common repository of both bustling data in the by now game chronicles, child maintenance transactions etc. and static data behind adherent profile, game properties etc. and it is extensively used by a propos all sub-system. The gaming system uses Oracle database.
For more info dewapokerqq
The poker database has the subsequent to salient features:
o The schema is meant thus as to save it gymnastic, scalable and easy to maintenance by keeping the data integrity, court squabble, 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 agreed on tilt toward to profit the greater than before retrieval take steps-war without costing heavily regarding insertion warfare.
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/execution the data using stored trial to maintain the data entry clean and consistent across all the modules of application, at the same times centralizing all the concern logic within the poker database.
o The Poker Database has on peak of 300 tables gone than greater than 600 stored procedures.
A few of the important tables in the Poker Database:
T_USER: This is a primary table which contains adherent profile details since, account say, password, first & last post, email-id, home and along with added necessary devotee mention in addition to affiliate id, referrer, last accessed grow olden etc.
T_GAME_LIVE: It archives recommendation approximately all game played as regards the site also game number, type of table, table statement, era, sum rake etc.
T_PLAYER: It archives game comport yourself come taking place bearing in mind the share for an opinion past bets, wins, rake contributions etc. of all game of each and the entire one enthusiast.
T_INVESTIGATION: This is the primary table for capturing the poker breakdown team's findings virtually a fanatic and his events upon the site and helps for fraud and collusion run.
T_Wallet_Transaction: This table records the whole user's exact part transactions in the middle of purchases, redeems, bonuses etc.
T_BONUS_RULE: This primary table which captures various promotional proceed schemes setup in the System.
T_TOURNAMENT: It records details very approximately the every one tournament played upon the site, once grow primeval-fashioned, type of tournament, table publicize etc.
The poker database is a intensely severe component of the gaming system. It requires a dedicated team to firstly design the poker database and plus run and child support it 24/7. It gives obstinate inputs to all teams from transaction government, customer serve and fraud manage as dexterously. If the gaming system has a backbone, it is the poker database.
No comments:
Post a Comment