Case Study For Track Revenue Reports of Casino through Google App Engine

Case Study For Track Revenue Reports of Casino through Google App Engine

Brainvire Infotech Pvt. Ltd www.brainvire.com

http://www.brainvire.com

Client Requirement This application is to help the client to track revenues Application is a centralized system for calculating revenue Client Possessed a domain with Google Developed using Google App Engine Application users are as demanded Authentication to hosting and report generation Google-centric application to be hosted on Google Cloud SQL

http://www.brainvire.com

From user Google technologies are used successfully below : Admin: The Admin type of user’s will create role and assign access to each role Input provider: Input providers are basically those users who have the authority to track the revenues Report viewers: This group of users can only view the reports based on the data provided

http://www.brainvire.com

Project Challenges Date-wise addition of records Applying different calculation to each field Providing varied report generation option Authenticating with Google account Generating reports with Google Drive Allowing access and modification to transactions Dynamic reports generation based on statistics and formulas Calculating adhoc average of the revenue

http://www.brainvire.com

Technologies Used Operating System & Server Management

Red Hat Linux, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Backups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance

Development Tools & Environments

JSP Servlet, Google Apps Script, Google App Engine, Google Cloud SQL, Google Spreadsheet, Google Drive API, Apache POI, AJAX, HTML, CSS etc

Database

MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups http://www.brainvire.com

Manpower Project Leader

1

Developers

2

Designers

1

http://www.brainvire.com

Planning The Database layer containing MYSQL Server Database, Tables, Stored Procedures Logic layer consisting of all the business logic procedures for interactive modules The Interface layer and Database Abstraction layer Converting data between incompatible type systems in databases and accessing data from the database respectively The User Interface layer which forms the Graphical User Interface of the website

http://www.brainvire.com

Architecture

http://www.brainvire.com

Development Highlights The site offered a centralized access to multiple users Developed using robust architecture Customizable viewing options Access control and other security measures Application was reliant on varied Google technologies Built according to the latest standards Web application was developed keeping in mind the SEO activities For timely delivery of the solution, Google App Engine Google spreadsheet and Google Drive was used for reporting Web usability guidelines were strictly followed The interface was made easily navigable The site was developed & fully functional within a span of 1 month http://www.brainvire.com

Sources : http://www.brainvire.com/track-casino-revenuereports-google-app-engine/

Contact Info : 1-631-897-7276 Email : info@brainvire.com Website : www.brainvire.com http://www.brainvire.com

Contact Us https://www.facebook.com/Brainvire https://twitter.com/Brainvire http://google.com/+Brainvire http://www.linkedin.com/company/brainvireinfotech-pvt-ltd

Contact Info : 1-631-897-7276 Email : info@brainvire.com Website : www.brainvire.com http://www.brainvire.com