Background information

A customer provides automated marketing services for garment companies. In most cases, a variety of information such as membership and inventory information is required to generate reports. The amount of information is large and takes a long time to process, which leads to reports being delayed and causes marketing personnel to lose out on valuable opportunities. The large number of queries that are simultaneously processed may also cause instability in the database.

Business effects

The customer configured automatic refresh of materialized views. The views are refreshed at a specific point in time every night. Data contained in the materialized views is already processed. This accelerates queries and makes it easy to generate reports. The customer no longer needs to maintain a separate task scheduling system by using the scheduled refresh mode, which reduces costs.