US Patent 7191169 System and method for selection of materialized views

Patent 7191169 was granted and assigned to Oracle on March, 2007 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

71911690

Patent Inventor Names

Dongbin Tao0

Date of Patent

March 13, 2007

Patent Application Number

103455650

Date Filed

January 16, 2003

Patent Citations Received

‌

US Patent 12135719 Automatic partitioning of materialized views

‌

US Patent 11882141 Graph-based query composition for monitoring an environment

Patent Primary Examiner

Don Wong

Patent abstract

A method for selecting and recommending materialized views is described, in which a set of workload queries is classified in terms of a number of structural features that includes the structure of the join operations in the query (“full query join graph”), the structure of a specific subset of the join operations (“anchor join graph”), and other characteristics such as the measures, selection predicates, and grouping conditions employed in the query. These features are used to implement a two-level partitioned search for the recommended materialized views.