Enterprise Reporting Capabilities In Storage Management Systems

A computing device comprising:

• a memory containing machine readable medium comprising machine executable code having stored thereon instructions for performing a method of refreshing a materialized view;
• and
• a processor coupled to the memory, the processor configured to execute the machine executable code to:
• update, based on discovering a last child storage object associated with a parent storage object, a set of tables stored in a database;
• create a materialized view based on a result of a database query executed against the set of tables stored in the database;
• compare a materialized view update timestamp to an update timestamp of one or more tables of the set of tables, wherein the materialized view update timestamp indicates a last update time of a first materialized view and an update timestamp of a given table indicates a last update time of the given table;
• delay a refresh of the first materialized view until after the last child storage object has been discovered;
• and
• refresh the first materialized view to determine a second materialized view when the last child storage object is discovered, wherein the second materialized view is based on one or more tables affected by the discovery of the last child storage object.

A non-transitory machine readable medium having stored thereon instructions for performing a method, comprising machine executable code which when executed by at least one machine, causes the machine to:

• create a first materialized view based on a first result of a database query executed against a set of tables stored in a database;
• discover a set of child storage objects associated with a parent storage object;
• insert, based on the discovering a set of child storage objects, an entry into one or more tables of the set of tables, the entry including a child storage object of the set of child storage objects;
• delay a refresh of the first materialized view until after the entry is inserted into the one or more tables of the set of tables;
• and
• after the entry is inserted into the one or more tables of the set of tables, refresh the first materialized view to determine a second materialized view, the second materialized view being based on a second result of the database query executed against the set of tables.