Download now Free registration required
Telecom giant Bharti Airtel is the flagship company of Bharti Enterprises. It is the largest private telecom company in India. They have implemented the CRM module of the Oracle E-Business Suite. This application is used 24x7 by the contact centers located at various geographic locations. The users retrieve reports from the CRM system using Oracle Discoverer. Users of these reports prefer that they be as up-to-date as possible - ideally available in real time. However, because of the overhead that it would create on the production system, online reporting is discouraged, and materialized views are used instead. Because these materialized views involve complex joins, they cannot be incrementally maintained. The business requirement of online reports (current time minus one hour) has been very difficult to achieve. There are three steps to the streams replication process - Capture, Propagation, and Apply. The implementation was based on the consideration that Oracle ACS, in conjunction with Bharti Airtel, needed to resolve downstream capture and number of capture. Also, application of processes had to be determined depending on the number of objects being replicated. Supplemental Logging is another prerequisite that need to be carried out on the source (production) database. After implementing Oracle Streams, Bharti needed to monitor performance of the new environment and tune the capture and apply processes as needed on the downstream database to achieve optimal performance.
- Format: PDF
- Size: 0 KB