US Patent 7930297 Materialized view maintenance and change tracking

Patent 7930297 was granted and assigned to Oracle on April, 2011 by the United States Patent and Trademark Office.

Overview Structured Data Issues Contributors Activity

Is a

Patent

Patent attributes

Current Assignee

Oracle

Patent Jurisdiction

United States Patent and Trademark Office

Patent Number

7930297

Date of Patent

April 19, 2011

Patent Application Number

11004145

Date Filed

December 3, 2004

Patent Primary Examiner

‌

Khanh B. Pham

Patent abstract

A technique for refreshing materialized views in a database is disclosed. The detail table is partitioned, and changes made to the detail table are tracked with information stored, for example. Only sections in the materialized view which correspond to the partitions which include modifications made to the detail table are refreshed, thus avoiding the need of a complete refresh to overcome staleness.