1

How to improve real-time analytics in the finance sector? A case study

NoSQL
MySQL
Ruby
Marketing
Social media
Telecommunications
Finance
Data-driven analytics

Start your digital transformation to win the fintech race

Get a consultation

Big data isn't new to the finance industry. Leaders in providing predictive analytics and data feed equip investment institutions with data based on public social signals. Those insights alert to major opportunities in the stock market.

The following article answers the question of how to enhance real-time analytics and empower investors. Learn how Altoros helped to improve the performance and uptime of a social media platform for online investing.

The customer

The customer is an application based on the concept “invest in what you like,” which helps users to find potential investment opportunities through analyzing brand awareness in social networks. It aggregates conversations, status updates, likes, and check-ins from social networks into a proprietary database. Then it links these keywords and phrases to publicly traded companies and translates the data into investment ideas.

The need

The company turned to Altoros to apply best practices in cloud transformation Ruby development to their existing system in order to satisfy the high requirements to the level of concurrency, load, response times, etc.

The challenge

The Web site was based on a distributed architecture that was not able to scale as expected. In addition, there were several issues with DB contention and background jobs. It was estimated that the solution would have to serve 10,000 users simultaneously with at least 100 new user registrations per minute. Every new user would need to view a partial portfolio right after signing up. The system had to interact with APIs of multiple social networks and remain within the limits of request quotas. It also had to apply complex business logic to extract investment information from social network data. Additionally, profiles of every existing user had to be synchronized with all the latest updates on their social networks.

The solution

Having analyzed the infrastructure, software architecture, and application code, we were able to implement improvements that have resolved all the issues mentioned above. The optimizations helped included reconfiguring the Amazon EC2 instances, implementing a Redis pub/sub mechanism to decouple jobs from DB operations, managing social networks quotas internally, so that the application would never exceed the allowed number of requests, and much more.The solution was written with Ruby and features a distributed, scalable architecture able to serve 10,000+ users simultaneously. To provide scalability and service availability, the application was deployed on Amazon’s infrastructure and utilized Redis—a scalable NoSQL store—for caching and network scalability (the pub/sub model).

The outcome

Thanks to the improvements introduced by our team, the customer was able to launch several marketing campaigns without being afraid of performance issues due to increased traffic. The application’s overall uptime and performance have been improved significantly by 70%.

Taking into account the customers' focus on social networks, Altoros made sure that it complies with the required API quota/limits.

Technology stack

Server platform

Amazon Web services (EC2, Route 53, CloudWatch, RDS), Redis

Programming languages

Ruby

Technologies

Ruby on Rails, Sidekiq, Capistrano

Databases

Amazon RDS for MySQL

Client Platform/Application Server

Unicorn

We can scale up your product

See our services

You May Also Like

Automation of In-field Job Planning and Performance Optimization
Java
JavaScript
PostgreSQL
Information technology
Marketing
Call Recording, Analytics, and Workforce Optimization Solution
.NET
jQuery
C#
JavaScript
MS SQL
Information technology
Highly Scalable System for DNA Analysis
Hadoop
Java
Information technology
Healthcare
Sport
A Highly Secure Smart Home System Wins a Kickstarter Funding
Ruby
Ruby on Rails
JavaScript
Angular
PostgreSQL
MySQL
Information technology
The Image Recognition System
Java
MongoDB
NoSQL
e-Commerce
Integrated logistics solutions to the offshore industry
Android
LikeFolio: Best Practices of Cloud and Ruby Development for Application Optimization
NoSQL
MySQL
Ruby
Ruby on Rails
Marketing
Social media
Telecommunications
Finance
Data-Driven Analytics
Software for Selecting and Mixing Paint
.NET
MS SQL
C#
WP
Information technology
Retail
Software Suite for Mobile Technicians and Field Service Management
.NET
MS SQL
iOS
Android
Logistics and transportation
The System for Emergency Control Centers
.NET
C#
MS SQL
Healthcare
Sport
Logistics and transportation
The Cloud-based Document Exchange System
Java
jQuery
NoSQL
Information technology
e-Commerce
The Marketing Information Messaging System
.NET
C#
MS SQL
iOS
Marketing, Social media
Telecommunications
The NuoDB Migrator for Moving SQL Data to a NoSQL Database
Java
NuoDB
MySQL
PostgreSQL
Information technology
Manufacturing
Toyota Automates Its System for Holding Tenders
.NET
C#
Manufacturing
Warehouse Workload Monitoring Application
.NET
C#
MS SQL
WP
Logistics and transportation
Web-Based Personal Styling
Ruby
Ruby on Rails
JavaScript
jQuery
MySQL
Social media
e-Commerce
Web-Based System for Retailers
Ruby
Ruby on Rails
MySQL
MongoDB
Retail
e-Commerce
A Blockchain-Based Platform for Automating Bond Issuing Worth $10M
Bash
JavaScript
Blockchain
Finance

Contact us

Contact us and get a quote within 24 hours

Headquarters

Toll-free

Email