Patent attributes
The present disclosure relates to a method comprising incorporating a utilization level field for a set of materialized views of database system in a database catalog of the database system. A computer process may be generated to run during a defined time period on a spare host of the database system. The computer process is configured to monitor utilization of the set of materialized views and to collect data of utilized materialized views in a dedicated registry. A check if each materialized view of the set of materialized views is present in the registry may be periodically be performed. The utilization level of a materialized view may be adapted based on its collected data in the registry. A check in catalog utilization levels of the set of materialized views may periodically be performed and based on the utilization levels utilization of the set of materialized views may be adapted.
