Enterprise reporting capabilities in storage management systems

Patent metadata

Field	Value
Publication number	US-9690832-B2
Application number	US-201414507409-A
Country	US
Kind code	B2
Filing date	Oct 6, 2014
Priority date	Oct 6, 2014
Publication date	Jun 27, 2017
Grant date	Jun 27, 2017

Abstract

A method of refreshing a materialized view includes creating a materialized view based on a first result of a database query executed against a set of tables stored in a database and discovering a set of child storage objects associated with a parent storage object. The method also includes inserting, based on discovering the 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. The method further includes delaying a refresh of the materialized view until after the entry is inserted into the set of tables and then refreshing the materialized view, which is based on a second result of the database query executed against the set of tables.

First claim

What is claimed is:

1. A method of refreshing a materialized view, comprising:
creating a first materialized view based on a first result of a database query executed against a set of tables stored in a database;
discovering a parent storage object;
inserting, based on the discovering the parent storage object, a second entry into one or more tables of the set of tables, the second entry including the parent storage object;
discovering a set of child storage objects associated with the parent storage object;
wherein the discovering a set of child storage objects includes discovering the last child storage object of the set of child storage objects, and wherein the entry includes the last child storage object, the method further including:
identifying a materialized view update timestamp for the second materialized view, the materialized view update timestamp indicating a last update time of the second materialized view;
identifying an update timestamp of one or more tables of the set of tables, an update timestamp of a given table indicating a last update time of the given table;
comparing the materialized view update timestamp to the update timestamp of one or more tables of the set of tables; and determining, based on the comparing, whether to refresh the second materialized view;
inserting, 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;
wherein the parent storage object and the set of child storage objects are based on a storage hierarchy representing hardware and software resources for storing data at a storage system;
updating a timestamp for the parent storage object with a timestamp of discovering a last of child storage object from among the set of child storage objects;
delaying a refresh of the first materialized view based on the updated timestamp for the parent storage object and 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, refreshing 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.

2. The method of claim 1 , wherein the first materialized view is different from the second materialized view.

3. The method of claim 1 , wherein the comparing includes determining whether the materialized view update timestamp is earlier than the update timestamp of the one or more tables of the set of tables, wherein in response to determining that the materialized view update timestamp is later than each update timestamp of the set of tables, determining to not refresh the second materialized view.

4. The method of claim 3 , wherein in response to determining that the materialized view update timestamp is earlier than an update timestamp of the set of tables, determining to refresh the second materialized view.

5. The method of claim 1 , further including: in response to determining to refresh the second materialized view, refreshing the second materialized view to determine a third materialized view; submitting a second database query to the third materialized view; and generating a report based on a result of the second database query.

6. The method of claim 5 , further including: in response to determining to not refresh the second materialized view, submitting a second database query to the second materialized view; and generating a report based on a result of the second database query.

7. 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;
wherein the discovering a set of child storage objects includes discovering the last child storage object of the set of child storage objects, and wherein the entry includes the last child storage object, the system further including:
identifying a materialized view update timestamp for the second materialized view, the materialized view update timestamp indicating a last update time of the second materialized view;
identifying an update timestamp of one or more tables of the set of tables, an update timestamp of a given table indicating a last update time of the given table;
comparing the materialized view update timestamp to the update timestamp of one or more tables of the set of tables; and determining, based on the comparing, whether to refresh the second materialized view;
wherein the parent storage object and a set of child storage objects are based on a storage hierarchy representing hardware and software resources for storing data at a storage system;
update a timestamp for the parent storage object with a timestamp of discovering the last child storage object from among the set of child storage objects;
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 based on the updated timestamp of the parent storage object and 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.

8. The system of claim 7 , wherein the system monitoring tool persists a discovery of the parent storage object and the set of child storage objects associated with the parent storage object to the database.

9. The system of claim 7 , wherein the system monitoring tool spawns one or more monitors to discover child storage objects associated with the parent storage object.

10. The system of claim 7 , wherein the system monitoring tool determines whether the materialized view update timestamp is earlier than an update timestamp of the set of tables, wherein in response to determining that the materialized view update timestamp is later than each update timestamp of the set of tables, the system monitoring tool determines to not refresh the second materialized view, and wherein in response to determining that the materialized view update timestamp is earlier than an update timestamp of the set of tables, the system monitoring tool determines to refresh the second materialized view to determine a third materialized view.

11. The system of claim 7 , wherein the system monitoring tool determines whether the materialized view update timestamp is earlier than the update timestamp of the set of tables, wherein in response to determining that the materialized view update timestamp is earlier than an update timestamp of the set of tables, the system monitoring tool refreshes the materialized view and the reporting tool submits a query to the refreshed materialized view that is based on a second result of the database query executed against the set of tables.

12. The system of claim 11 , further including:
a reporti

Assignees

• Netapp Inc

Inventors

• George Jimmy
• Ranganath Rajath

Classifications

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/2393

  Updating materialised views · CPC title

• G06F17/30383

  Physics · mapped topic

• G06F17/30554 Primary

  Physics · mapped topic