Categories : Advertising, All, Case Study
Location Based Restaurant Survey System application is a web and mobile-based survey system for restaurants. It extensively makes
use of the location-based technology.
|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||PHP, Linux, Apache, Mysql, Android, IOS, Blackberry, AJAX, Java Script, HTML5, CSS3 etc.|
|Database||MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups|
|Quality Assurance Testers||2|
The online survey characteristic of the website called for the design approach to be built around PHP and MYSQL Server. Modules like Survey Creation, Location Creation, Location Manager Creation, User Prof iles and Reporting were developed in PHP such that they can be executed directly from the UI layer. These PHP f iles consisted of all the business logics used for respective modules like Save (Add/Update), Delete, Get Single Object, Get Multiple Objec ts for Listing and were designed to be capable of handling many more logics which were not related to the database. In order to most effectively access the database in an object -oriented context, an interface translating the object logic to the relational logic was used to communicate with the relational databases in an object-oriented manner.
An intermediary abstraction layer was created for accessing data from the database. Stored procedures were used only for complex retrieval of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the website. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers.
The site was equipped with a robust architecture to offer centralized access for numerous survey creation, survey fill up and monitoring statistics such of survey under one roof. An extensive database of statistics and graphs was incorporated to provide systematic survey reports based on each server. Extensive pre-development research was carried out to make the entire database compatible. SEO activities performed ensured high visibility for the site over the internet. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of AJAX, CSS and HTML controls. The site was developed and fully functional within a span of 4 months.