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