- SG: +65 64383504
- IN: 022 25771219
- IN: 022 25792714
- IN: +91 9987536436
88% reduction in time needed for reporting application for one of Malaysia’s largest telecom providers
88% reduction in time needed for reporting application
The customer is a Malaysian converged telecommunications, broadband and 4G service provider. It is one of the four largest telecom groups in Malaysia.
The business team wanted to get certain reports everyday morning by 9am, instead they were getting the reports in the late afternoon. This was impacting the decision making.
On the technical side, the reports were being pulled off from OLTP database which would contend with the production application queries. This does not only slow down the response to reporting query but also put an overhead on application response.
Though offloading the reporting application to a secondary DB server was the obvious solution, the real challenge was in designing the replication solution that can keep Primary and Secondary database in sync for Reporting purposes. Below were some key challenges regarding replication setup –
Ashnik team proposed EnterpriseDB Postgres Plus Advanced Server for reporting database. xDB replication server from EnterpriseDB was proposed to be the solution for replication. Key highlights of the solution-
The Oracle compatibility features provided by EnterpriseDB made the migration quite easy and smooth. The functions and procedures could be migrated without any significant changes. The replication solution design mitigated the initial challenges. Currently, the customer is using Postgres Plus Advanced server for pulling reports and the reports are out for management reviews well in time. Additionally the replication is scheduled to replicate changes during off peak hours and hence OLTP transactions are not impacted. The Oracle server now is dedicated for OLTP workload. The end customer has been able to achieve all this in a fraction of total cost of a separate reporting database in Oracle DB. The reports that used to take 8 hours to generate now are made available in 1 hour.