Discuss a joint project
Automotive market data analysis online system
2017
Java
Spring
PostgreSQL
Microsoft SQL Server
Olap4j
GraphQL
Client
3 Front-end developers
3 Back-end developers
1 QA-engeneer
1 Project manager
3 Back-end developers
1 QA-engeneer
1 Project manager
Team
Autostat is an analytical agency that specializes in processing automobile databases and compiling marketing reports on the automotive market.
The legacy system did not allow the implementation of new functionality at the proper level. The outdated legacy codebase has become difficult to support, and hiring developers for the old stack in the new HR market has become extremely difficult.
Outdated processes and service logic only allowed the user to access individual databases, without the necessary flexibility in combining them, and that limited the customer’s pricing options.
Outdated processes and service logic only allowed the user to access individual databases, without the necessary flexibility in combining them, and that limited the customer’s pricing options.
Problem
We had to completely update the codebase, implement new functionality, update the business logic and implement additional more flexible options for selling the service based on different data access packages, such as the one by the number of queries and temporary ones.
Task
All data was stored in Microsoft SQL, and OLAP cubes technology was actively used.
For end-users of the analytical data of the service, mastering the syntax for working with OLAP cubes (MDX) was very difficult, so one of the most important requirements was the ability to provide data in a user-friendly web interface and API.
For end-users of the analytical data of the service, mastering the syntax for working with OLAP cubes (MDX) was very difficult, so one of the most important requirements was the ability to provide data in a user-friendly web interface and API.
Project features
- We completely updated the logical interaction layer of a web application with a complex multidimensional data structure;
- We replaced the outdated interface and developed a light web version of the service with the ability to personalize and brand the interface for individual clients;
- We created a contract constructor that allows users to flexibly form customer access to the data packages of the analytical system;
- In addition, we implemented the possibility of interaction with the service via API to integrate with the internal products of the customer's clients (insurance companies, banks, car dealers), which receive data on the cost of used cars, car ownership history, etc.
Solution
Discuss a joint project
COSYSOFT LLC 08216886
