TELCOM PROVIDER- Case Studies
88% reduction in time needed for reporting application for one of Malaysia’s largest telecom providers
About the Customer
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 –
- Cost of having another Oracle database License
- Costly Replication tool/solution
- Logical replication was needed to minimize the changes and tables which would be required to be replicated
- Replication required to be scheduled to propagate changes after closure of daily operations
- There was no primary key on the tables that were to be replicated and hence implementing change data capture was difficult
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-
- Using EnterpriseDB Postgres Plus Advanced Server as reporting database avoids huge cost of Oracle License
- xDB replication server is a bundled product with EnterpriseDB’s Postgres Plus Enterprise Edition and hence no additional cost incurred on replication solution
- Oracle data was migrated to Postgres Plus using migration toolkit that comes along with Postgres Plus Advanced Server.
- Stored procedures and functions in Oracle were migrated using Migration Toolkit. This reduced the effort and cost of migration significantly.
- A solution was designed to capture daily changes in a shadow table based on timestamp at Primary Oracle Server
- The data to be replicated was reduced by avoiding binary columns. Views were created on source database on primary tables (without including binary tables) and the views were replicated using snapshot mode
- xDB replication server allowed scheduling the replication job
- Reports are now being pulled from the Postgres Plus Advanced Server database
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.