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 The business processes more than 1.1 trillion transactions each year, providing a rich source of data that can be explored to uncover business insights.
Abacus wanted to improve business intelligence and analytics capabilities to understand travel patterns and customer buying behaviour in near real time 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. 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 information and deliver required business reports.
Bryte worked with Abacus to deploy Amazon Redshift for one of their key markets in Asia Pacific (Korea) as a test case to look at performance and scalability benefits.
An automated process was set up to continuously sync their Korean market data from the existing on-premise Oracle Databases with Amazon Redshift. This enabled new data to be available in Amazon Redshift near real time. Our team then developed a range of highly efficient ELT processing jobs to wrangle multiple data sources and build rich Data Marts / Business reports. Then, our team conducted Amazon Redshift performance monitoring and optimisation to deliver the following results.