Abacus International is the leading provider of Global Distribution Systems to the travel industry in Asia Pacific, serving over 100,000 travel agents across 59 markets They process more than 1.1 trillion transactions each year so they have large volumes of data that can be explored to uncover business insights.
Abacus International business wanted to improve their business intelligence and analytics capabilities to understand travel patterns and customer buying behaviour using a multitude of data sources like online ticket sales and passenger itinerary data.
Their challenge was that the current on-premise infrastructure was difficult to scale up and struggled to keep up with growing data volumes. They had to process more than 1.3 trillion transactions each year and the volumes were growing rapidly.
Because of the amount of data they had in different sources and structures, it also took a long time for their existing on-premise databases to process the data and deliver the required business reports.
We worked with Abacus to use Amazon Redshift for one of their markets in Asia Pacific (Korea) as a test case to look at performance and scalability benefits.
We set up an automated process using Bryte CDC software to sync their Korean market data from the existing on-premise Oracle Database with Amazon Redshift. This enabled new data to be available in Redshift near real time.
Our team then used ELT processing to integrate their data in Amazon Redshift so that it could be processed as fast as possible. Then, our team conducted Redshift performance monitoring and optimization to deliver the following results.