HomePortfolioThe Web-Based System for Retailers

The Web-Based System for Retailers

Business intelligence
Cloud-native
NoSQL
Retail
Ruby

A Web-based system that enables retailers to gather statistics on consumer demand for their products and adjust their sales strategy according to these figures.

The Web-Based System for Retailers

The need

TapMap is a start-up company that needed a solution to synchronize retailers’ Point of Sale systems with online accounts.

The solution had to include a Web system providing information on stock and prices. The information was to be updated on a daily basis and accessible to customers through free iPhone and Android apps. The customers would scan barcodes with their smartphone cameras to compare prices while the Web system gathers statistics and generates reports for retailers. Apart from that, searches and scans were to be displayed on a visual map in real time.

The reports produced by the system had to enable minute-by-minute tracking of shopping trends for particular products and the entire stock, so that a retailer using the product could, for instance, compare the demand for Chardonnay in a number of districts throughout a month and forecast the amount of wine required in stock for the following month. The system was also to help estimate expected sales and analyze, if the demand in a particular area is sufficient to open a new POS.

The challenge

The system had to feature the highest level of performance and scalability to collect, process, and display statistics in real time. The existing solution was slow and could not satisfy the growing needs of the customer.

The solution

Our team of Ruby on Rails developers analyzed the architecture of the solution and found a way to improve it. The connections between the objects were optimized to enhance the structure of the database. This greatly improved the overall performance and provided nearly endless scalability.

The outcome

The customer was one of the three winners at the International EXPO 2011. The event was held in the heart of the Silicon Valley at the Plug and Play Tech Centre and hosted the world’s leading technology experts. The iEXPO featured a number of promising startups who presented their projects to the audience.

Technology stack

Server platform

CentOS

Client platforms/Application servers

Web browser/Nginx + Passenger, Apache + Passenger

Programming language

Ruby 1.8.7

Technologies

Ruby on Rails 2.3.8, Sphinx, MongoDB, MapReduce

Databases

MySQL 5.1 (primary), MongoDB 1.8 (for statistics)

/
01
02
03

Contact us

Let's see what we can do together

Ryan Meharg

Ryan Meharg

Cloud Solutions Architect

ryan.m@altoros.com650 265-2266

830 Stewart Dr., Suite 119 Sunnyvale, CA 94085