公开(公告)号：US20160098462A1

公开(公告)日：2016-04-07

申请号：US14507409

申请日：2014-10-06

Applicant: NetApp, Inc.

Inventor： Jimmy George ,  Rajath Ranganath

IPC: G06F17/30

CPC classification number: G06F17/30554 ,  G06F17/30383

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.

Abstract translation: 刷新物化视图的方法包括基于针对存储在数据库中的一组表执行的数据库查询的第一结果来创建物化视图，并发现与父存储对象相关联的一组子存储对象。 所述方法还包括：基于发现所述一组子存储对象，将该条目插入所述一组表中的一个或多个表中，所述条目包括所述一组子存储对象的子存储对象。 该方法还包括延迟物化视图的刷新，直到将入口插入到该组表中，然后刷新物化视图，其基于针对该组表执行的数据库查询的第二结果。

公开(公告)号：US09690832B2

公开(公告)日：2017-06-27

申请号：US14507409

申请日：2014-10-06

Applicant: NetApp, Inc.

Inventor： Jimmy George ,  Rajath Ranganath

IPC: G06F17/30

CPC classification number: G06F17/30554 ,  G06F17/30383

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.