Case Study Track Casino Revenue Reports through Google App Engine
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 4
Client
Requirement
The purpose of this application is to help the client to track revenues at each of his casino centre located in geographically diverse areas. The application is a centralized system for calculating revenue generated through each activity in the casinos. Client already possessed a domain with Google. He developed using Google App Engine and to be authentication to hosting and report generation, throughout the system. The application users are as
demanded a Google-centric application to be hosted on Google Cloud SQL. From user Google technologies are used successfully below:
Admin: The Admin type of user’s will create role and assign access to each role. They will manage and keep an eye on the activities carried out throughout the system. Input provider: Input providers are basically those users who have the authority to track the revenues at each casino centre. Users can choose the centre for which they wish to add information and proceed to fill in details in the required fields. Each field is programmed (assigned calculations) to yield a right output. Report viewers: This group of users can only view the reports based on the data provided by the input providers. The system also allows choosing from a varied report types. The application is comprehensive as it stores the details about every property (casino centre) and games played in each casino. The games are well defined, categorized and calculations are applied to each category. The category has a revenue type and each revenue type has a different formula for calculation. The application is made scalable which means Admin can add more games to a particular centre, categorize them and can also activate and deactivate the games in the centre. The non-functioning games are deactivated for a particular day or record. The system by default allows input entry to be done only for last three days and then auto-locks the database for entries for days earlier than three from present. The application allows auto-report generation as well and while generating report the data is used from the application while the actual report generation is performed through Google Drive.
Project
Challenges
Team faced the following challenges:
Date-wise addition of records. Allowing access and modification to transactions pertaining to last 3 days only and auto-locking rest of the past dates. Applying different calculation to each field and providing varied report generation option. Authenticating with Google account. Generating reports with Google Drive. Dynamic reports generation based on statistics and formulas. Calculating adhoc average of the revenue.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 4
Technologies Operating System & Server Management
Development Tools & Environments Database
Used Red Hat Linux, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance JSP Servlet, Google Apps Script, Google App Engine, Google Cloud SQL, Google Spreadsheet, Google Drive API, Apache POI, AJAX, HTML, CSS etc. MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Manpower Project Leader
1
Developers
2
Designers
1
Planning Keeping in mind the structure of the website and the challenges involved, a four-tier development approach was adopted consisting of:
The Database layer containing MYSQL Server Database, Tables, Stored Procedures and so on.
The Interface layer and Database Abstraction layer for converting data between incompatible type systems in databases and accessing data from the database respectively.
The Business Logic layer consisting of all the business logic procedures for interactive modules.
The User Interface layer which forms the Graphical User Interface of the website.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 4
Architecture
Development
Highlights
The site offered a centralized access to multiple users. Developed using robust architecture the system allowed personalization to the users. Customizable viewing options were designed to enhance the user experience. Access control and other security measures were applied. The entire application was reliant on varied Google technologies and was built according to the latest standards. The web application was developed keeping in mind the SEO activities for the site. For timely delivery of the solution, Google App Engine was used. The system made use of Google POI for reading excels files as well as Google spreadsheet and Google Drive was used for reporting purpose. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of HTML and CSS controls. The site was developed and fully functional within a span of 1 month.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4