Categories : All, Case Study, Mobile and Wireless
This is an internal application for users (advisors) to evaluate/survey customers on their electrical usage and rate their e-score based on the below parameters.
|Operating System & Server Management||Red Hat Linux OS, 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|
|Development Tools & Environments||PHP5+, LAMP Platform, Android Platform, Rational Rose Enterprise Edition|
|Database||MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups|
|Quality Assurance Testers||1|
Since the targeted users were internal staff members – Android, NoSQL, PHP and MySQL formed the basis of development. SOAP based web service were designed to communicate between Android and Web server applications.
The entire application data was being stored in device in NoSQL (database that provides a mechanism for storage and retrieval of data that employs less constrained consistency models than traditional relational databases) to work in offline mode. The architecture was designed to get all application level data through web service as per the user’s credentials.
To update information to and fro, background service was designed in android application which calls web services to transfer all updated data and fetch all updated data from the web server. In case of any conflicts the data modified last as per timestamp takes precedence.
With robust and secure communication in place, data syncing happened real-time without any glitch. All data transmission is been logged in case of failure to maintain data consistency and integrity. To keep the track of previous records, information is maintained into application device for pre-configured time period which lead to reduced bandwidth usage.